Page created: 22 Jul 2020 |
Page updated: 1 Feb 2021
The following procedures configure the Sync Pipe, external servers, and Sync Classes. The examples are based on the Complex JDBC sample in the config/jdbc/samples/oracle-db directory. The create-sync-pipe-config tool can be run with the server offline and the configuration can later be imported.
- Run the create-sync-pipe-config tool.
- At the
Initial Synchronization Configuration Toolprompt, press Enter to continue.
- On the Synchronization Mode menu, select Standard Mode or Notification Mode.
- On the Synchronization Directory menu, choose one-way or bidirectional synchronization.
Configure the sync source
- On the Source Endpoint Type menu, enter the number for the sync source corresponding to the type of source external server.
- Enter a name for the Source Endpoint.
- Enter the base DN for the directory server, which is used as the base for LDAP searches. For example, enter dc=example,dc=com, and then press Enter again to return to the menu. If entering more than one base DN, make sure the DNs do not overlap.
- On the Server Security menu, select the type of communication that PingDataSync Server will use with the endpoint servers.
- Enter the host and port of the source endpoint server. The Sync Source can specify a single server or multiple servers in a replicated topology. The server tests that a connection can be established.
- Enter the DN of the Sync User account and create a password for this account.
The Sync User account enables PingDataSync Server to access the source
endpoint server. By default, the Sync User account is stored as
Configure the destination endpoint server
- On the Destination Endpoint Type menu, select the type of datastore on the endpoint server. This example is configuring an Oracle Database.
- Enter a name for the Destination Endpoint.
- On the JDBC Endpoint Connection Parameters menu, enter the fully-qualified host name or IP address for the Oracle database server.
- Enter the listener port for the database server, or press Enter to accept the default (1521).
- Enter a database name such as
- The server attempts to locate the JDBC driver in the lib
directory. If the file is found, a success message is
Successfully found and loaded JDBC driver for: jdbc:oracle:thin:@//dbsync-w2k8-vm-2:1521/dbsync-test
If the server cannot find the JDBC driver, add it later, or quit the create-sync-pipe-config tool and add the file to the lib directory.
- Add any additional JDBC connection properties for the database server, or press Enter to accept the default (no). Consult the JDBC driver’s vendor documentation for supported properties.
- Enter a name for the database user account with which PingDataSync Server will communicate, or press Enter to accept the default (SyncUser). Enter the password for the account.
- On the Standard Setup menu, enter the number for the language (Java or Groovy) that was used to write the server extension.
- Enter the fully qualified name of the Server SDK extension class that implements
Enter the fully qualified name of the Java class that will implement com.unboundid.directory.sdk.sync.api.JDBCSyncDestination: com.unboundid.examples.oracle.ComplexJDBCSyncDestination
- Configure any user-defined arguments needed by the server extension. These are defined in the extension itself and the values are specified in the server configuration. If there are user-defined arguments, enter yes.
- To prepare the Source Endpoint server, which tests the connection to the server
with the Sync User account, press Enterto accept the default (yes). For
the Sync User account, it will return "Denied" as the account has not been
written yet to the Directory Server at this
Testing connection to server1.example.com:1389 Done Testing 'cn=Sync User,cn=Root DNs,cn=config' access Denied
- To configure the Sync User account on the directory server, press Enter to
accept the default (yes). Enter the bind DN
cn=DirectoryManager) and the bind DN password of the directory server so that you can configure the
cn=Sync Useraccount. PingDataSync Server creates the Sync User account, tests the base DN, and enables the change log.
Created 'cn=Sync User,cn=Root DNs,cn=config' Verifying base DN 'dc=example,dc=com' Done Enabling cn=changelog .....
- Enter the maximum age of the change log entries, or press Enter to accept the default.