Information
  • Author: Vuram
  • Type: Plug-in (Function & Smart Service)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Industry: All Industries
  • Compatible Version(s): 23.2
  • First Released:
  • Last Updated:
  • Cost: Free
Resources
Share
Home » AppMarket » Import SQL File

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.
Anonymous
Parents

  • Hi, Health check report says it has reference to Appian Deprecated API's. Is there a new version of this plugin?

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

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

Children
No Data

© 2024 Appian. All rights reserved.