JDBC Connector

Back Next

JDBC targets in mappings

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

Specify the name and description of the JDBC target. Configure the target and advanced target properties for the JDBC object.

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	Target type. 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 source object in a mapping task associated with a mapping that uses this source transformation.
Object	Name of the target object. You can select an existing object.
Operation	Target operation. Select one of the following operations: Insert. Update. Upsert. Delete. Data Driven. Configure an expression to specify an update strategy based on the data. You can use the DD_INSERT constant in an expression.

The following table describes the JDBC advanced target properties:

Advanced Target Property	Description
Commit Interval	Interval in rows between commits. Default is 100.
Number of Retries	An integer value. Number of times to retry if the query execution fails due to a closed connection. Default is 5.
Retry Wait Period	Interval in seconds between two retry attempts. Default is 3 seconds.
Pre SQL	Pre-SQL command to run against the target database before writing data to the target.
Post SQL	Post-SQL command to run against the target database after writing data to the target.
Success File Directory	Directory for the success file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Data Integration writes the success rows file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/success Enter a directory local to the Secure Agent. Ensure that your administrator has granted you access to this directory.
Error File Directory	Directory for the error rows file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Data Integration writes the error rows file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/error Enter a directory local to the Secure Agent. Ensure that your administrator has granted you access to this directory.
Forward Reject Rows	Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the mapping task forwards rejected rows to the next transformation.

Rename Saved Search

Table of Contents

JDBC Connector

JDBC Connector

JDBC targets in mappings

JDBC targets in mappings