Plug-in (Function & Smart Service)Free

Import SQL File

by Vuram Technology

Description

Parameters Input: Log Save In Folder (Folder) - Location for the log file to be stored Document (Document) - The DDL Script to be imported Jndi Name (Text) - The data store name to import the scripts into

Output: Log file (Document) - File that contains the error found during import or the log content in case of success Error Occurred (Boolean) - Set to true if any error has occurred. Error Text (Text) - Provides the result message.

Features

Notes :
This smart service works only with MySQL and SQL Server.
The following statement can be used in the SQL file to set the database on which the queries that follow should run on -

  • USE database_name;
    Supported file formats: .sql, .zip. The zipped file can include multiple sql script files.

Release notes

Updated plugins as of Appian Version 23.2

Resources