Database

Automation can use Java Database Connectivity (JDBC) API calls to update database tables on a remote database server. You can also use database tables as the data source for a For Each Loop to iterate through each row in the table.

All Database activities use JDBC Database Server targets with JDBC Login Credentials account keys.

Note: Variable size is limited to 1 MB. As of October 4, 2023, the size of the Large String workflow variable type is limited to 10 MB.

The Database adapter executes the following activities using Java Database Connectivity (JDBC):

• Call Procedure Via JDBC
• Delete from Table Via JDBC
• Insert Bulk into Table Via JDBC
• Insert into Table Via JDBC
• Select from Table Via JDBC
• Update Table Via JDBC