In this page you will learn how to create and configure a SQL integration object for use with a custom JDBC connected system. The custom JDBC connected system combined with the SQL integration object allows you to connect your Appian application to an unsupported database that supports the JDBC protocol to exchange data using SQL statements.
Any database that is not in this list is considered an unsupported database.
Before you begin, ensure that you have:
After you have deployed a database driver and created the custom JDBC connected system, you can then create your SQL integration object.
To create a SQL integration object in Appian:
Select a SQL integration type from the Operation dropdown list.
Integrations that query data can be used in any expression. Do not use them to modify data in the external system because duplicate updates may occur. Additionally, using DDL commands such as
CREATE can permanently alter your data and database schema.
Configure the following properties.
|Name||Enter a name that follows the recommended naming standard.|
|Description||(Optional) Enter a brief description of the integration.|
|Save In||Browse to and select an existing folder to store the integration object, or click Create New Rule Folder to create and select a new folder for the object.|
After you have created a SQL integration object with a custom JDBC connected system, you can design the SQL statements you will call in your integrations. To see what you can do with your newly designed integration, see Call an Integration.
In the integration object, enter the SQL statements you want to use. You can also create a parameterized query that uses an expression to reference the parameter value.
For specific examples, see the following:
Create a SQL Integration