Replacement of deprecated "MySQL Dump To Document"

Certified Senior Developer

Hi,

Our client has an Appian process (triggered by a daily batch job) that exports all the data from around fifty tables.
The plugin used for this is: "MySQL Dump To Document".
Since we've upgraded to Appian 25.3, the plugin is now deprecated, and the latter process is failing in error.

*** Error: "Error creating MySQL Dump to Appian Document"


What new plugin alternative could you advise me to use and install ?

Otherwise, which native Appian solution could you propose ?

Our client needs to deploy a solution in Production in few days, so I have to find a solution.

Regards

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer


    Here is a partial example SQL script generated by the plugin (AS_DUMP 9_2_2025 4_00 AM GMT+00_00.sql):

    CREATE DATABASE IF NOT EXISTS Appian 
    USE Appian;
    
    -- ----TABLE Structure for: TT_MY_TABLE1------
    DROP TABLE IF EXISTS `TT_MY_TABLE1`;
    CREATE TABLE `TT_MY_TABLE1` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `fk_case_id` int(11) DEFAULT NULL,
      `comments` varchar(1500) DEFAULT NULL,
      ...
      PRIMARY KEY (`id`),
      KEY ...
    ) ENGINE=InnoDB AUTO_INCREMENT=2610 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
    
    -- ----Dumping data for:TT_MY_TABLE1-----
    LOCK TABLES `TT_MY_TABLE1` WRITE;
    
    INSERT INTO TT_MY_TABLE1 VALUES ('1','2',NULL,NULL,...),('2','5',NULL,NULL,...),('3','6',NULL,NULL,...),...  ;
    
    UNLOCK TABLES;
    
    -- ----TABLE Structure for: TT_MY_TABLE2------
    DROP TABLE IF EXISTS `TT_MY_TABLE2`;
    CREATE TABLE `TT_MY_TABLE2` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `fk_case_id` int(11) DEFAULT NULL,
      `val` varchar(1500) DEFAULT NULL,
      ...
      PRIMARY KEY (`id`),
      KEY ...
    ) ENGINE=InnoDB AUTO_INCREMENT=2610 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
    
    -- ----Dumping data for:TT_MY_TABLE2-----
    LOCK TABLES `TT_MY_TABLE2` WRITE;
    
    INSERT INTO TT_MY_TABLE2 VALUES ('1','2',NULL,NULL,...),('2','5',NULL,NULL,...),('3','6',NULL,NULL,...),...  ;
    
    UNLOCK TABLES;

Reply
  • 0
    Certified Senior Developer


    Here is a partial example SQL script generated by the plugin (AS_DUMP 9_2_2025 4_00 AM GMT+00_00.sql):

    CREATE DATABASE IF NOT EXISTS Appian 
    USE Appian;
    
    -- ----TABLE Structure for: TT_MY_TABLE1------
    DROP TABLE IF EXISTS `TT_MY_TABLE1`;
    CREATE TABLE `TT_MY_TABLE1` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `fk_case_id` int(11) DEFAULT NULL,
      `comments` varchar(1500) DEFAULT NULL,
      ...
      PRIMARY KEY (`id`),
      KEY ...
    ) ENGINE=InnoDB AUTO_INCREMENT=2610 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
    
    -- ----Dumping data for:TT_MY_TABLE1-----
    LOCK TABLES `TT_MY_TABLE1` WRITE;
    
    INSERT INTO TT_MY_TABLE1 VALUES ('1','2',NULL,NULL,...),('2','5',NULL,NULL,...),('3','6',NULL,NULL,...),...  ;
    
    UNLOCK TABLES;
    
    -- ----TABLE Structure for: TT_MY_TABLE2------
    DROP TABLE IF EXISTS `TT_MY_TABLE2`;
    CREATE TABLE `TT_MY_TABLE2` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `fk_case_id` int(11) DEFAULT NULL,
      `val` varchar(1500) DEFAULT NULL,
      ...
      PRIMARY KEY (`id`),
      KEY ...
    ) ENGINE=InnoDB AUTO_INCREMENT=2610 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
    
    -- ----Dumping data for:TT_MY_TABLE2-----
    LOCK TABLES `TT_MY_TABLE2` WRITE;
    
    INSERT INTO TT_MY_TABLE2 VALUES ('1','2',NULL,NULL,...),('2','5',NULL,NULL,...),('3','6',NULL,NULL,...),...  ;
    
    UNLOCK TABLES;

Children
No Data