Import SQL File

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.

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.

MauRap1993 1 month ago

Hello Team,

We are encountering the following issue when using the plugin to import a zip file containing SQL files:

Cannot invoke "String.equalsIgnoreCase(String)" because "extension" is null.

Do you know what might be causing this problem?

Thanks in advance and best regards,

Maurizio
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket over 1 year ago
v1.0.1 Release Notes
- Updated plugins as of Appian Version 23.2
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket over 1 year ago in reply to jasmithak

In the 23.2 release, Appian introduced modernized file management APIs that offer a cleaner abstraction layer for easier file handling within Appian. We simultaneously announced that we are deprecating some older APIs. We are aware of the utilization of deprecated APIs within some AppMarket plug-ins that work with documents. As part of our commitment to ensuring compatibility, we anticipate all Appian-authored plug-ins currently using deprecated APIs to be updated for API compatibility by the 24.1 General Availability (GA) release. We also proactively work with Partner plug-in authors to ensure all AppMarket plug-ins have optimal performance and functionality.

If you have any questions or require AppMarket assistance, please don't hesitate to reach out by sending an email to appmarket@appian.com.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
jasmithak over 2 years ago

Hi, Health check report says it has reference to Appian Deprecated API's. Is there a new version of this plugin?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Santhosh Kumar over 4 years ago in reply to VP

Hi Vaiyapuri,

Since the file is read in Java and each line is imported to the database, the file size limit depends on your server's heap memory size.

Thanks.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
VP over 4 years ago

Good Morning.

Is there any file size limit for import sql?

Thanks,
Vaiyapuri
- Cancel
- Up 0 Down
- Reply
- More
- Cancel