JDBC Connector

Back Next

JDBC sources in mappings

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

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

The following table describes the JDBC source properties:

Property	Description
Connection Name	Name of the source connection.
Source Type	Source type. Select one of the following types: Single. Select to specify a single JDBC object. Multiple. Select to specify multiple JDBC objects. Related objects appear based on simple primary key-foreign key relationship. Query. Select to specify user defined query to select data from source 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	Source object for the mapping.
Filter	Configure a simple filter or an advanced filter to remove rows at the source. You can improve efficiency by filtering early in the data flow.

The following table describes the JDBC advanced source properties:

Advanced Source Property	Description
Page Size	Number of rows that are cached from a JDBC source. Default is 1000.
Isolation Level	Determines the level of concurrency in transactions to avoid data inconsistency. Select from the following isolation levels: None TRANSACTION READ COMMITTED TRANSACTION READ UNCOMMITTED TRANSACTION REPEATABLE READ TRANSACTION SERIALIZABLE Default is None.
Override Isolation Level	Overrides the isolation level if the database does not support it. If this option is checked, the task runs successfully with the default isolation level of the database.
Enable Pagination	Not applicable.
Pre SQL	Pre-SQL command to run against the source database before reading data from the source.
Post SQL	Post-SQL command to run against the source database after reading data from the source.
Tracing Level	Sets the amount of detail that appears in the log file. You can choose terse, normal, verbose initialization or verbose data. Default is normal.