Import Batch SQL From Collab
by Appian Corporation
Description
Automate DB management (bulk inserts in DB table)
Features
The plugin provides a smart service which imports and executes file(s) containing SQL INSERT statements.
Release notes
Updated deprecated APIs, and changed the application minimum version to 23.2
Version history (2)
1.1.3
https://docs.google.com/document/d/1qKYOgqXbOlSY1B-Uo95__NU3TiSpT9ei1pFzwN3pwfk/edit#
1.1.2
[MIGRATED] This smart service utility allows a user to import a sql file or zip of sql files that have been uploaded into Appian content management into their connected database.
The utility will only process INSERT style statements. It has been tested with MySQL and SQL Server, on Appian 7.5 and 7.6 (On-premise and Cloud). Tested up to 10 million records being inserted.
==== (INPUTS) >jndiName - JNDI connectio name (e.g. jdbc/Appian) >document - Appian document to load (ZIP or single file) >commitEvery - number of lines to read from file before committing to the database >startLine - if only processing a part of a file, you can have the service read to this line before starting to commit data
(OUTPUTS) >errorText - error message/stack trace >errorOccurred - true/false that error occurred >numberOfInserts - number of inserts processed >linkNumberOfLastInsert - line number in the last file processed >lastFileAttempted - if using a zip, indicates the name of the last file being read before completion or failure