DBSync example

PingDataSync provides a DBSync example between two endpoints consisting of a PingDirectory server source and a RDBMS system, which will be used in this chapter.

The entity-relational diagram for the normalized database schema is available in <server-root>/config/jdbc/samples/oracle-db/ComplexSchema.jpg, and is illustrated here:

Entry relation diagrams for schema tables.

Five tables are represented with their primary keys in bold. The entity relations and foreign keys are marked by the relationship lines. The illustration shows mapping to a custom object class on the directory server, while the "groups" table maps to a standard Lightweight Directory Access Protocol (LDAP) group entry with objectclass:groupOfUniqueNames.