Page created: 26 Jul 2021 |
Page updated: 14 Jan 2022
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 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 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 displayed.
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 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 the
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 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.