MySQL Dump To Document
by Appian Corporation
Description
Used to backup a subset of tables in an automated fashion. This is an updated version that uses modernized Appian APIs for document writes, and fixes an issue with interfacing with MariaDB using a JDBC driver >= 3.0 and removes deprecated smart services.
Features
- IMPORTANT NOTE * MySQLDumpToAppianDocV2 has been removed from this version, so implementing this plugin will require updating existing processes!
Smart Services: MySQLDumpToAppianDocV3
Smart service taking in a DB name, and table prefix for exporting the table create, inserts, and optionally views into a SQL Document file. Inputs: Database name (text) - Database name to export Table Names Start With (text list) - List of prefixes to export Include Views (boolean) - Toggle whether or not to include views in export Document to overwrite (document) - Document to overwrite with the new export. New Document Name (text) - Text for the new .sql document to be created. Destination Folder (Folder) - Folder where new document should be placed. Fetch Buffer Row Count (Integer) - Optional parameter to override default fetch buffer, use for performance tuning as needed, to balance memory consumption and execution speed. Lock Tables (boolean) - Toggle whether to lock tables for export or not.
Outputs: Generated Dump Document (Document) - Document that was generated or updated by this smart service
Release notes
6.0.5
- Improved Datasource connectivity
- Enhanced Performance & Stability when dumping large tables
- Other Improvements, Optimizations and Maintenance
Version history (1)
6.0.1
6.0.1 Performance optimization used to default the fetch buffer from 1 row to 1000 rows. New optional parameter provided to adjust this as needed.