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

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.