The Bulk Load Utility is the most efficient way to load massive amount of user profiles shortcutting OIM business layer using a client utility communicating directly with the database. It automates the process of loading large amounts of data into Oracle Identity Manager, reducing the down time that can be experienced from performing this action.
Advantages of the Bulk Load Utility include:
• Speed: Using the Bulk Load Utility reduces the down time involved in loading data.
• Performance: Actions initiated by the Bulk Load Utility are processed directly on the Oracle Identity Manager database. As a result, the utility leverages the database’s RDBMS infrastructure for high performance.
• Cost: Integration costs are reduced for deployment scenarios where bulk data must be loaded from numerous heterogeneous applications.
a) Using Bulk Load Utility in OIM, data can be loaded directly from comma-separated value (CSV) files or from database tables.
b) Data can be loaded either immediately after installing Oracle Identity Manager, where only the default data is loaded, or into an existing Oracle Identity Manager environment that is already loaded with customer data.
c) Data is loaded to the Oracle Identity Manager repository, as long as
it exists on the same server serving Oracle Identity Manager.
d) The utility enables you to load:
• User data that corresponds with user accounts in OIM.
• Account data that corresponds to user account data in Oracle Identity Manager. User account data is associated with resource account data, such as data pulled from Microsoft Active Directory or Oracle Unified Directory servers.
• Role data for data corresponding to OIM roles
• Role membership data for data corresponding to role memberships in OIM.
• Role hierarchy data for the relationship of roles to one another in OIM.
• Role category data for data corresponding to role categories in OIM.
e) User accounts are loaded with a default password. Users who log in to these accounts are forced to change the password on the initial login.
f) The Bulk Load Utility can handle any exceptions generated while loading user data. Any records that fail the loading process can be retried.
g) You can also use the utility to generate an audit snapshot for the data that is loaded into Oracle Identity Manager.
h) Refer below the important location of all the files required for Bulk Load Utility.
i) Data loaded from CSV files is loaded into temporary database tables built during the bulk load itself. Two types of database tables are created for each CSV file loaded. These database tables are suffixed with the first six characters of the CSV file name specified, followed by a unique number.
> OIM_BLKLD_TMP_suffix: Data loaded from the CSV file is loaded into this table
> OIM_BLKLD_EX_suffix: Data records that fail to be added into the Oracle Identity Manager repository are stored in this database table. This database table also has a column called EXCEPTION_MSG, which stores the reason for the failure of each record in the corresponding table.
> A third type of database table, OIM_BLKLD_LOG, contains progress and error messages for transactions that occur during the bulk-load activity. This table can be monitored to view the progress of the bulk load.
j) Every separate execution of the Bulk Load Utility creates a summary log file, along with
control and SQL scripts that are built and executed for that transaction. The files are saved
into the logs_YYYYMMDD_hhmi directory nested in the oimbulkload directory. These files can be helpful in troubleshooting problems that may arise during the transaction.
k) Important Notes:
> The default size of the Oracle Identity Manager repository tablespace is 500 MB.Depending on the amount of accounts that you are loading, you may need to add space to this data file to accommodate the data. The oim_blkld_setup.sql script, available in the scripts directory, enables you to define the data file to accommodate the data load.
> While the Bulk Load Utility automatically generates tables based on the file name for data in CSV files, you must specify the name of the temporary table when loading data from database tables.
> OIM should be down while using bulkload utility.
l) When working with either CSV files or other database tables as the input source for the Bulk Load Utility, you must specify a control line, which represents the column names of the Oracle Identity Manager database table that will receive the final data.
m) When using a database table as the input source, the table must contain the following primary key column, OIM_BLKLD_USRSEQ NUMBER(19). The utility uses this column as the primary key.
Please refer here to see demo on HOWTO import bulk users in OIM using bulk load utility.