Batch SQL Import

Overview

This smart service allows a user to import an 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 with up to 10 million records being inserted.

Key Features & Functionality

Inputs:

• jndiName - JNDI connection 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