9 Synchronization with Relational Database Tables

This chapter explains how to synchronize data to Oracle Internet Directory from tables in a relational database. The synchronization can be either incremental—for example, one database table row at a time—or all the database tables at once. The process of synchronization with a database server involves executing a directory integration profile. This process has two steps:

1. Retrieving the data from the database. This involves executing a SQL SELECT statement that retrieves the specified data records from the database.

2. Writing the data into the directory. This involves converting the retrieved data records to LDAP attribute values and performing the LDAP operation on the directory.

Note: Before reading this chapter, be sure to familiarize yourself with the introductory chapters about Directory Integration and Provisioning—specifically: Chapter 1, "Introduction to Oracle Identity Management Integration" Chapter 5, "Oracle Directory Synchronization Service" Also, be aware that Oracle Internet Directory 10g Release 2 (10.1.2) does not enable exporting data from Oracle Internet Directory to a relational database.

This chapter contains these topics:

• Preparing the Additional Configuration Information File

• Preparing the Mapping File

• Preparing the Directory Integration Profile

• Example: Synchronizing a Relational Database Table to Oracle Internet Directory