JDBC Palette

The JDBC palette contains activities for querying, updating, or calling stored procedures in the database.

  • JDBC Call Procedure
    JDBC Call Procedure is an asynchronous activity that calls a database procedure or function using the specified JDBC connection. If this activity is not part of a transaction group, the SQL statement is committed after the activity completes.
  • JDBC Query
    JDBC Query is an asynchronous activity that performs the specified SQL SELECT statement. If this activity is not part of a transaction group, the SQL statement is committed after the activity completes.
  • JDBC Update
    JDBC Update is an asynchronous activity that performs the specified SQL INSERT, UPDATE, or DELETE statement.
  • SQL Direct
    SQL Direct is an asynchronous activity that executes an SQL statement that you supply. With this activity you can build an SQL statement dynamically using other activities, then pass the SQL statement into this activity's input. You can use this activity to execute DDL SQL statements like CREATE and DROP. You can also execute SQL statements that are not supported by other activities in the JDBC palette.