Import SQL File



  • 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


  • 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.


  • 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.