Data Sync Server Documentation Index
Configuration Reference Home

Third Party JDBC Sync Source

Third Party JDBC Sync Source provide JDBC sync source implementations created in third-party code using the UnboundID server SDK.

Parent Component
Properties
dsconfig Usage

Parent Component

The Third Party JDBC Sync Source component inherits from the JDBC Sync Source

Properties

The properties supported by this managed object are as follows:


Basic Properties: Advanced Properties:
↓ description ↓ max-open-connections
↓ server
↓ database-entry-type
↓ changelog-maximum-age
↓ ignore-changes-by-user
↓ extension-class
↓ extension-argument

Basic Properties

description

Description
A description for this Sync Source
Default Value
None
Allowed Values
A string
Multi-Valued
No
Required
No
Admin Action Required
None. Modification requires no further action

server

Description
Specifies the name of the JDBC External Server that should be used as the source of synchronization.
Default Value
None
Allowed Values
The DN of any JDBC External Server.
Multi-Valued
No
Required
Yes
Admin Action Required
None. Modification requires no further action

database-entry-type

Description
This property lists the types of database "entries" that can be synchronized by this JDBC Sync Source. Database entries that do not match one of the types listed here will be dropped by this sync source. A database entry type is used to uniquely identify the set of data in the database that makes up an LDAP entry. It is initially set by the ScriptedJDBCSyncSource interface when a change is detected, either during real-time sync or during a resync operation. It is then used during later phases of the sync operation to determine how to process the change.
Default Value
None
Allowed Values
A string
Multi-Valued
Yes
Required
Yes
Admin Action Required
None. Modification requires no further action

changelog-maximum-age

Description
Specifies the period of time after which changelog entries are deleted automatically from the changelog table in the database. This effectively determines the value for the 'maxAgeMillis' parameter that is passed to the cleanupChangelog() method in the ScriptedJDBCSyncSource implementation (see the 'script-class' property). This implemenation may choose not to perform any deletes and simply return if you do not want the Ping Identity Data Sync Server to manage the changelog table or if no such table is being used to detect changes.
Default Value
3 hours
Allowed Values
A duration. Lower limit is 1 milliseconds.
Multi-Valued
No
Required
No
Admin Action Required
None. Modification requires no further action

ignore-changes-by-user

Description
Modifications performed by accounts with the specified user name(s) will not be synchronized. This property is particularly useful when also using the Ping Identity Data Sync Server to synchronize changes to this source (i.e. bi-directional sync). In this case, a unique user account should be used by the Sync Pipe that applies changes to this source, and that user should be specified here to prevent those changes from being synchronized back to their original source.
Default Value
No changes are ignored.
Allowed Values
A string
Multi-Valued
Yes
Required
No
Admin Action Required
None. Modification requires no further action

extension-class (Read-Only)

Description
The fully-qualified name of the Java class providing the logic for the Third Party JDBC Sync Source.
Default Value
None
Allowed Values
The fully-qualified name of a Java class that extends or implements com.unboundid.directory.sdk.sync.api.JDBCSyncSource
Multi-Valued
No
Required
Yes
Admin Action Required
None. Modification requires no further action

extension-argument

Description
The set of arguments used to customize the behavior for the Third Party JDBC Sync Source. Each configuration property should be given in the form 'name=value'.
Default Value
None
Allowed Values
A string
Multi-Valued
Yes
Required
No
Admin Action Required
None. Modification requires no further action


Advanced Properties

max-open-connections (Advanced Property)

Description
The maximum number of connections that the JDBC Sync Source is allowed to have open to the database at a given time. Care should be taken that the number of worker threads (specified by the num-worker-threads property on the Sync Pipe) does not exceed the number of available connections; otherwise thread starvation may occur.
Default Value
30
Allowed Values
An integer value. Lower limit is 1. Upper limit is 1000 .
Multi-Valued
No
Required
Yes
Admin Action Required
None. Modification requires no further action


dsconfig Usage

To list the configured Sync Sources:

dsconfig list-sync-sources
     [--property {propertyName}] ...

To view the configuration for an existing Sync Source:

dsconfig get-sync-source-prop
     --source-name {name}
     [--tab-delimited]
     [--script-friendly]
     [--property {propertyName}] ...

To update the configuration for an existing Sync Source:

dsconfig set-sync-source-prop
     --source-name {name}
     (--set|--add|--remove) {propertyName}:{propertyValue}
     [(--set|--add|--remove) {propertyName}:{propertyValue}] ...

To create a new Third Party JDBC Sync Source:

dsconfig create-sync-source
     --source-name {name}
     --type third-party
     --set server:{propertyValue}
     --set database-entry-type:{propertyValue}
     --set extension-class:{propertyValue}
     [--set {propertyName}:{propertyValue}] ...

To delete an existing Sync Source:

dsconfig delete-sync-source
     --source-name {name}