Oracle Human Resources Integration: Configuring the connector

Now we will finish configuring the HR import agent profile. First we need to launch the Oracle Directory Manager (ODM) GUI tool and login to it as the "orcladmin" user. Once you have successfully logged into ODM, navigate through the DIT starting at "Server Management" and then to the"Integration Servers". Click on "Configuration Set1". You will see all of the default DIP profiles. Double click on the agent named "OracleHRAgent".

Configuring the General tab

When the OracleHRAgent profile form comes up you will be in the "General" tab. The only properties you need to set at this time is the "Debug Level" (optional) and the "Scheduling Interval".

Setting the "Debug Level" to "63" will generate a log file that records all transactions for this agent. Remember to prune this log file from time to time if you turn on debug tracing.

The "Scheduling Interval" should be set in seconds to how often you want OID to check the HR database for changes.

Configuring the Execution tab

Next we want to switch to the "Execution" tab. Here we need to set the "Agent Execution Command". This command tells the DIP server which procedures to use when processing HR data, the HR database connect string, the login name and password for connecting to the HR database, and the date of the last successful time the agent connected with the HR database. Here is a sample of the command we will use for this exercise:

odihragent OracleHRAgent connect=HRDB login=apps pass=apps date=orclodiplastsuccessfulexecutiontimeodihragent

Enter this value into the "Agent Execution Command".

Configuring the Mapping tab

In this tab we only need to set one field, the "OID Matching Filter". Set this value to "employeenumber".

Configure the Status tab

Here we need to set the "Last Successful Execution Time". This value tells the DIP server each time it connects with the HR database, how far back in time it needs to check for changes to the HR database. In our example we will set this to the current date. This will get all changes that happened today.

If this is the first time you have setup the HR integration you may want to bootstrap the OID server with all employees in the HR database. If this is the case then you will want to set the initial value of this field to a date and time far enough in the past so as to provision all employees from the HR database into OID.

After each successful pass the DIP server will automatically set this value to the current date and time.

Enabling the OracleHRAgent

When you are ready to begin synchronizing with the HR database, you will need make sure the DIP server is started. To star the DIP server enter the following command:

# oidctl connect=db_connect_string server=odisrv instance=1 start

Next you need to go back to the "General" tab and set the "Profile Status" to "Enabled".

If you chose to bootstrap all of the employees in the HR database as mentioned previously, the first pass may take several minutes to finish provisioning all of the employees from the HR database. Subsequent passes should execute immediately.

Watch a viewlet to see how this is done.