Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to JDBC Connector
  3. JDBC connections
  4. Synchronization tasks with JDBC
  5. Mappings and mapping tasks with JDBC
  6. Appendix A: JDBC data type reference

JDBC Connector

JDBC Connector

Back Next

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.
0 COMMENTS
We’d like to hear from you!