Insert Bulk into Table Via JDBC

Use the Insert bulk into table via JDBC activity to provide a source table for inserting bulk data into a database.

Usage

Complete the following properties to use this activity:

• SQL - Specify the following information or click the Variable Reference icon to choose a variable:
  • Source data To Insert - Enter the source data to be inserted into the database.
  • Name of the target table - Enter the name of the target table in which the data has to inserted.
  • Columns to write - Click Add to enter the appropriate information:
    • Source column - Enter the source column name.
    • Column type - Choose the column type from drop-down list, such as Boolean, Decimal, Integer, or String.
    • Target Column - Enter the target column name.