PingDirectory

Configure DBSync

About this task

Configuring a DBSync system includes extra tasks to create the extensions and to configure the database. The overall configuration process is provided here:

Steps

  1. Download the appropriate Java database connectivity (JDBC) driver to PingDataSync’s /PingDataSync/lib directory, and restart the server for the driver to load into the runtime.

  2. Open the java.properties file with a text editor and add the jdbc.drivers argument. Save the file. When using custom JDBC endpoints, SQL statements cannot be called unless JDBC drivers are set in the java.properties file.

  3. Run the dsjavaproperties command to apply the change. For example, enter the following for start-sync-server:

    start-sync-server.java-args=-d64 -server -Xmx256m -Xms256m -
    XX:+UseConcMarkSweepGC -
    Djdbc.drivers=foo.bah.Driver:wombat.sql.Driver:com.example.OurDriver ...
    etc.
  4. Create one or more JDBC extensions based on the Server SDK. If configuring for bidirectional synchronization, two scripts are needed: one for the JDBC Sync Source and the other for the JDBC Sync Destination. Place the compiled extensions in the /lib/extensions directory.

  5. Configure the database change log table and triggers (presented later). The vendor’s native change tracking mechanism can be used, but a change log table should also be configured. Each table requires one database trigger to detect the changes and loads them into the change log table.

  6. Configure the Sync Pipes, Sync Classes, external servers, distinguished name (DN) and attribute maps for one direction.

  7. Run the resync --dry-run command to test the configuration settings.

  8. Run realtime-sync set-startpoint to initialize the starting point for synchronization.

  9. Run the resync command to populate data on the destination endpoint.

  10. Start the Sync Pipes using the realtime-sync start command.

  11. Monitor PingDataSync using the status commands and logs.

  12. For bidirectional synchronization, configure another Sync Pipe, and repeat steps 4–8 to test the system.