Insert into Table Via JDBC

Use the Insert into Table via JDBC activity to insert values into a table by executing a SQL query.

Usage

Complete the following properties to use this activity:

  • SQL - Specify the SQL query to be Executed or click the Variable Reference icon to choose a variable. For example, this query inserts values into a table:

                          ```
      INSERT INTO mytable (column1,column2) VALUES ('val1','val2')
      ```