Open topic with navigation

TIBCO® Patterns 6.1.2

### Prerequisites

Before using Patterns Data Synchronizer, familiarize yourself with the following information:

- Editing YAML files.

- Apache™ JDBC, which PDS uses to communicate with the source database. Before you begin, see the database vendor’s documentation for the following details:

  - Formatting a JDBC connection string. Place the connection string in the PDS configuration file.

  - The required driver jar files. Place these in the Java™ class-path.

- Application Database Maintenance: PDS accesses a change-log table and a state table in the source database. Your application must create these two tables in the source database. It must also insert a row into the change-log table each time a record is changed.

YAML
Configuring PDS requires familiarity with editing YAML files.

JDBC
PDS uses JDBC to communicate with the source database.

- Consult your database vendor’s documentation on formatting a JDBC connection string. Place the connection string in the PDS configuration file.

- PDS packages publically-available JDBC drivers for PostgresTM and Microsoft SQL ServerTM.

- For other databases, consult your vendor's documentation for require jar files and the driver class-name. Place the driver jar file(s) in the JavaTM class-path. Configure the driver class-name in the yaml configuration file using the jdbcDriver setting.

- Consult your database vendor’s documentation for required jar files. Place these in the Java™ class-path.

Application Database Maintenance
PDS accesses a change-log table and a state table in the source database. Your application must create these two tables in the source database. It must also insert a row into the change-log table each time a record is changed.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® Patterns

Copyright © 2010-2025. Cloud Software Group, Inc. All Rights Reserved.