PingDataSync Server provides a DBSync example between two endpoints consisting of a Ping Identity 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 LDAP group entry with objectclass:groupOfUniqueNames.