Tuesday, June 23, 2015

OIM Bulk Load Utility: Loading Accounts

Tested On: OIM 11.1.2.2.0
Description: Demonstrates how to use the Bulk Load Utility to load accounts into OIM. A disconnected resource with a child form is used an example.
References:
http://docs.oracle.com/cd/E27559_01/dev.1112/e27150/bulkload.htm#OMDEV1742

Requirements
* If you are bulk loading child data, you must include key parent attribute in the child CSV file(s) so that Oracle Identity Manager knows what account the child data should belong to (Note: The key parent attribute does not have to be a UD column on the child table).
* A reconciliation rule must be defined for the resource object. This is needed for Oracle Identity Manager to associate/assign the resource account to a particular user. Also, ensure the reconciliation rule is active.
* Ensure you have the key parent attribute and the IT Resource attribute defined as reconciliation fields and mapped in the reconciliation mappings on the process definition.
* Duplicate accounts cannot be detected during a bulk load operation.

Loading Account Data
1. Construct header (first line) of the CSV files using the column names in the UD tables delimited by commas. From the second line onward, specify data delimited by commas according to the order of the header. Below are examples CSV files for parent and child forms.


UD Parent Table


UD Child Table

2. Place CSV files in "$MW_HOME/Oracle_IDM1/server/db/oim/oracle/Utilities/oimbulkload/csv_files" directory, where $MW_HOME is the Middleware directory.

3. Run the Bulk Load Utility script located in "$MW_HOME/Oracle_IDM1/server/db/oim/oracle/Utilities/oimbulkload/scripts/oim_blkld.sh". Below is a sample execution of the script.

1 comment:

  1. Hello, though an old post. Just had an issue which I wanted some help on.
    The resource and entitlement is provisioned after the load. Manual provisioning task is not created. But why is an UPDATE task is triggered.

    ReplyDelete