Oracle Human Resources Integration: Configure the HR .cfg file

One of the first things you need to do is evaluate which tables and columns in the HR database you want to synchronize with OID. This is configured using the OracleHRAgent.cfg file.

This file is located in your $ORACLE_HOME/ldap/odi/conf directory. In most cases the default settings in this file will suffice and are already loaded in your default OracleHRAgent profile. If these default setting are ok for your integration needs then it will not be necessary to change or load the OracleHRAgent.cfg settings into your OracleHRAgent profile and you may skip this configuration page entirely.

Here is what the default file looks like:

ATTRNAME:COLUMN_NAME:TABLE_NAME:FORMAT:MAP PersonId:person_id:PER:NUMBER:Y PersonType:person_type_id:PER:NUMBER:Y PersonTypeName:system_person_type:PPT:ASCII:Y LastName:last_name:PER:ASCII:Y StartDate:start_date:PER:DATE:Y BirthDate:date_of_birth:PER:DATE:Y EMail:email_address:PER:ASCII:Y EmployeeNumber:employee_number:PER:NUMBER:Y FirstName:first_name:PER:ASCII:Y FullName:full_name:PER:ASCII:Y knownas:known_as:PER:ASCII:Y MaritalStatus:marital_status:PER:ASCII:Y middleName:middle_names:PER:ASCII:Y country:country:PA:ASCII:Y socialsecurity:national_identifier:PER:ASCII:Y Sex:sex:PER:ASCII:Y Title:title:PER:ASCII:Y suffix:suffix:PER:ASCII:Y street1:address_line1:PA:ASCII:Y zip:postal_code:PA:ASCII:Y Address1:address_line1:PA:ASCII:Y Address2:address_line2:PA:ASCII:Y Address3:address_line3:PA:ASCII:Y TelephoneNumber1:telephone_number_1:PA:ASCII:Y TelephoneNumber2:telephone_number_2:PA:ASCII:Y TelephoneNumber3:telephone_number_3:PA:ASCII:Y town_or_city:town_or_city:PA:ASCII:Y state:region_2:PA:ASCII:Y Start_date:effective_start_date:PER:DATE:Y End_date:effective_end_date:PER:DATE:Y per_updateTime:last_update_date:PER:DATE:Y pa_updateTime:last_update_date:PA:DATE:Y

Lets examine one line from this file:

PersonId:person_id:PER:NUMBER:Y

The first thing to note about each line is the five sections that are delimited by four ":" characters.

The first column is the HR attribute called "PersonId".

PersonId:person_id:PER:NUMBER:Y

The next column is the database column name for this attribute called "person_id".

PersonId:person_id:PER:NUMBER:Y

The next column is the name of the database table where we are getting our data from.

PersonId:person_id:PER:NUMBER:Y

The next column in this line is the data type for the values we wish to import form the HR database. In this example it is the data type is NUMBER.

PersonId:person_id:PER:NUMBER:Y

The last column basically asks us if we want to use this column for mapping to OID.

PersonId:person_id:PER:NUMBER:Y

The OracleHRAgent.cfg file tells the DIP server the name of the database table, and the columns in the database table to check for new employees or changes to employee information. It also tells the DIP server what datatype to use when processing the employee attributes.

Uploading the OracleHRAgent.cfg file

If you find it necessary to change any of this default information, it will be necessary to upload the file to the OracleHRAgent profile. This is done using the "ldapUploadAgentFile.sh" command.

The ldapUploadAgentFile.sh program is located in the ORACLE_HOME/ldap/admin directory. The following is an sample command using this program to upload the OracleHRAgent.cfg file.

Watch a viewlet to see how its done.