JDBC Connector > Mappings and mapping tasks with JDBC > JDBC targets in mappings
  

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.