Sunday 3 July 2016

OIM Bulk Load Utility - Load Role Membership.

To load Roles Membership in OIM, follow the below steps:

 

Step 1: Copy the “oimbulkload” folder from OIM machine to database machine (i.e. the machine where Oracle database is installed and used by OIM). If database is on the OIM machine itself then skip this step.

 

The oimbulkload folder is present in the following location:
          MW_HOME/Oracle_IDM1/server/db/oim/oracle/Utilities/oimbulkload
 
 

Step 2: Create the .csv file and place it in /oimbulkload/csv_files folder.

(Some of the sample csv files are present in / oimbulkload/sample_data folder which can be used as reference).

 

 

The Rolem.csv file looks like,

 

UGP_NAME,USR_LOGIN
CRM Administrator,jbaker
CRM Administrator,abadal
AD Admin,ukumar
AD Admin,akumar
 

 

Step 3: Create a .txt file named master.txt. Enter the name of the csv file which you want to use for bulk load operation and place it in /oimbulkload/csv_files folder.

 

 

 
 
 
 
 
 

 

 

In this case, master.txt file looks like below:

 

 

 
 
 
 
 
 
 

 

 

Step 4: The following variables need to be set before we execute the bulk load script:

 

JAVA_HOME: path till jdk
eg: export JAVA_HOME=/home/oracle/jdk1.7.0_25
ORACLE_HOME: path till db_home 
eg: /home/oracle/app/oracle/product/11.2.0/dbhome_1

 

Step 5: Stop Oracle Identity Manager server.

 

Step 6: Execute bulkload script

 

Go to /oimbulkload/scripts directory and run below command :
              ./oim_blkld.sh

 
It will prompt to ask which script to run.
Select option 5. Load Role Membership.
 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Press enter if you have set ORACLE_HOME , otherwise give the path till DB_HOME.

 

 

 

Enter db details:

//HostIPAddress:Port/ServiceName

 

 

Enter the OIM schema user name.

 

 

Enter the OIM schema password.

 

 

Enter the OIM schema password again.

 

 

 

 

 

 

 

 

 

 

 

 

 

Select the type of input which will be used to get data. In this case, we are taking data from a csv file, so enter 2. 


 

 

 

 

 

 

 

 

 

 

Enter the file which contains the list of csv files to be used as input. In this case, enter “master.txt”.

 

Enter the name of the tablespace to be used for creating custom objects. In this case, we are using the default tablespace (R2PS2_OIM) 

 

It also gives us an option whether we want to insert log messages or not. Enter Y or N, as needed.

 

Role Memberships are created successfully in OIM.

 

 

 Happy Learning!!!

 

5 comments:

  1. Hi Anand,

    I am trying the load the role membership. Using a cvs file for the same.
    This is the content for CSV,

    UGP_NAME,USR_LOGIN
    OPERATORS,OIMINTERNAL

    But once i run the bulk upload utility for role, I am getting the below error,

    SQL*Loader: Release 11.2.0.1.0 - Production on Fri Oct 14 10:25:08 2016

    Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

    SQL*Loader-350: Syntax error at line 1.
    Expecting field-name, found ",".
    OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( , "UGP_NAME"

    Can you please advice.
    Its urgent.

    ReplyDelete
    Replies
    1. Open file in Notepad++,Select all the data and go to Edit Tab ->Blank Operations ->Trim Trailing Spaces

      Delete
    2. Looks like there are no blank spaces at the end. But still it gives that error error described above. Tried Notepad++, select all data, go to edit tab -> Blank Operations -> Trim Trailing Space. It did not work.

      Delete
  2. Despite being mechanical in nature, the hydraulic type is more common than other types. Its weight ranges are estimated at up to 10 million lbs while its accuracy is valued at 0.25%. yük hücresi

    ReplyDelete