JDBC V2 Connector

Back Next

JDBC V2 targets in mappings

When you configure a mapping to use a JDBC V2 target, you can configure the target properties.

Specify the name and description of the JDBC target. Configure the target and advanced target properties for the JDBC object in a Target transformation.

You can parameterize the target and advanced target properties for the JDBC target object in a mapping. You can also parameterize the JDBC V2 target connection and target object with values specified in a parameter file when you configure a mapping in advanced mode.

The following table describes the target properties that you can configure in a Target transformation:

Property	Description
Connection	Name of the target connection.
Target Type	Type of target object. Select one of the following target types: Single. Select to specify a single JDBC object. Parameter. Select to specify a parameter name. You can configure the target object in a mapping task associated with a mapping that uses this Target transformation.
Object	Name of the target object. You can select an existing object.
Create New at Runtime	Creates a target table at runtime using the object name and path you specify. You can create a target table at runtime only for PostgreSQL or Azure SQL Database. Ensure that you have selected PostgreSQL or Azure SQL Database in the JDBC V2 connection advanced properties based on the database that you want to connect. To create a target table at runtime, provide the following parameters: Object name . Specify the name for the target table. Path . Specify the target table name and schema in the following format: <Schema-Name>/<TableType> , where the mandatory value for TableType is `TABLE`.
Operation	Type of the target operation. Select Insert, Update, Upsert, Delete, or Data Driven.
Update columns	The temporary key column that identifies rows in the target table to update, upsert, or delete data.
Data Driven Condition	Flags rows for an insert, update, delete, or reject operation based on the data driven expression you specify. Appears only when the operation type is Data Driven . To configure a data driven expression in a mapping, you need to specify the expression that uses the IIF function.

The following table describes the JDBC advanced target properties that you can configure in a Target transformation:

Advanced Target Property	Description
Pre SQL	The SQL statement to run before writing data to the target.
Post SQL	The SQL statement to run after writing data to the target.
Truncate Target	Truncates the target table before inserting records to the target.
Reject Truncated/Overflow Rows	Writes truncated and overflow data to the reject file. If you select Reject Truncated/Overflow Rows, the Data Integration Service sends all truncated rows and any overflow rows to the reject file.
Table Name	Overrides the table name used in the metadata import with the table name that you specify.
Schema Name	Overrides the schema name of the target object. If you specify the schema name both in the connection and the target properties, the Secure Agent considers the schema name specified in the target properties.
Update Mode	Determines the mode how the Secure Agent writes data to the target. Select one of the following modes: Update As Update. Updates all rows flagged for update if the entries exist. Update Else Insert. Updates all rows flagged for update if the entries exist in the target. If the entries do not exist, the agent then inserts the entries.
Forward Rejected Rows	Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the agent forwards rejected rows to the next transformation.