OIM 11g R2 Generic Connector for Flatfile recon

GTC Connector recon

Flat file reconciliation.

To configure the flatfile recon, prepare the CSV file and the Stnaging and archive directories for the flatfile.

• Staging directory: D:\OIMSTAG (directory of your choice)
• Flatfile name –hrfeed (pick any name)
• Archiving Director - D:\OIMSTAG\Archive (must be in the staging directory)

Contents of the CSV file hrfeed.csv

#GTC Trusted Resource userId,firstname,lastname,email,organization,department,managerid,userType,employeeType testFlatFile,test1,flatfile,test.flatfile@email.com,Xellerate Users,IAM,xelsysadm,End-User,Full-Time

Create a new GT connector. 

1. Login to http://<host>:port/sysadmin 
2.  Click on Generic Connector under Configuration tab on the left pane.

 

Connector creation page opens: Click  “Create” Button –

Enter the connector details as shown in the below screens.

Click “continue”

Click “continue”

Connector configuration page displays –

Map the attributes from the reconciliation staging to OIM

To Map the attributes, click on Edit button besides the OIM attribute name:

Eg: To map the userId -> user login

Click on User Login Edit button on the OIM table, the following screen appears.

Select matching only check box

NOTE: – Matching only is only for this field.

Select the mapping filed from the CSV.

 Click continue and Exit.

Follow the same steps to map all other attributes. Do not select Matching only for other attributes.

Map the attributes to the following OIM attributes.

userId -> user Login

firstname -> First name

lastname -> Last name

email -> Email

organization -> organization

department -> Department name

managerId -> manager

userType -> user type

employeeType - > role

Make sure that you map at least all the mandatory attributes. If you wish add any other attributes, you may add the same either by adding it in the CSV file or directly in the connector configuration page by clicking the + button on the top of the reconciliation mapping table.

Click close once the mapping in done. Review the details and SAVE the connector.

From OIM Admin console – click on Scheduler under System Management

Search for GTC* -> the result lists the schedule task for the connector that was created in the above steps.

Click Run now -> make sure the hrfeed file is in the right directory.

If the status is scuuess, search for reconciliation events. On the  same scheduler page -> click on 

reconciliation tab and click the search button.

It lists all the events generated.

If there any errors verify the errors from the OIM log file and correct them accordingly.

If the error is : No Recon profile.

Follow these steps to create a profile for this connector.

1. From design console, open the resource object for the newly created connector.

2. Click on "Object reconciliation" tab.

3. Click on "Create reconciliation profile" button.

4. Make sure all the mapped fields are listed under reconciliation Fields tab.

5. Click on reconciliation action rules tab - and make sure there are rules for "Create user if no match found"