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:
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
.