JDBC Connector > Synchronization tasks with JDBC > JDBC sources in synchronization tasks
  

JDBC sources in synchronization tasks

When you configure a synchronization task to use a JDBC source, you can configure advanced source properties. To optimize performance, you can configure a filter in the Data Filters page.
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.
A simple filter includes a field name, operator, and value. Use an advanced filter to define a more complex filter condition, which can include multiple conditions using the AND or OR logical operators.
You can sort and group records by using Sort By and Group By fields in Data Filters page.
Advanced source properties appear on the Schedule page of the Synchronization Task wizard.
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.
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.
Enable Pagination
Not applicable.
Number of rows to be fetched
Number of rows that are read from a JDBC source. Specify the number of rows fetched to limit the data retrieved. Default is zero, which indicates that an unlimited number of rows are fetched.
Number of rows to be skipped
Not applicable.