Modes
Offline (OIM Server Up)
Online (OIM Server Down)
Features
- Data can be loaded into OIM Users, accounts allocated (provisioned) to OIM Users, roles, role hierarchies, role memberships, role categories, or organizations.
- Data can be loaded from a single or multiple CSV files or a database table. Data imported into OIM is automatically converted into OIM Usera, accounts provisioned to OIM Users, roles, role hierarchiesm role memberships, role categories, or organizations.
- Data can be loaded from a single or multiple trusted sources.
- Data can be loaded into either an empty OIM repository or an OIM repository that already contains data about OIM Users and resources.
- The utility is for creating new entities only. It cannot be used to update or delete existing entities.
- Exceptions generated during user data loading are handles, and records that fail the loading process can be retried.
- Audit snapshots can be generated after a bulk load operation for users.
- After bulk loading of OIM User data, password change at first login is enforced because a dummy password is used during the operation.
- Note: You cannot use the utility to encrypt user attributes. In oyjer words, if a user field in OIM us encrypted, then the utility cannot be used to encrypt data that is loaded into that field.
- The utility can be run in offline or online modes.
Zip and copy from
MIDDLEWARE_HOME/Oracle_IDM1/server/db/oim/oracle/Utilities/oimbulkload
It was already copied after installation to C:\Oracle2\Middleware\Oracle_IDM1\server\db\oim\oracle\Utilities\oimbulkload
C:\Oracle2\Middleware\Oracle_IDM1\server\db\oim\oracle\Utilities\oimbulkload\scripts
oim_blkld.bat or oim_blkld.sh
oim_blkld_setup.sql - To add a datafile in OIM tablespaces and provide additional grants to OIM database user.
Temporary Tables Used
OIM_BLKLD_TMP_SUFFIX
OIM_BLKLD_EX_SUFFIX
OIM_BLKLD_LOG
Options
- Load User Data
- Load Account Data
- Load Role Data
- Load ROle Membership
- Load Role Hierarchy
- Load Organizations
- Load Role Category
- Generate Audit Snapshot
Preparation
- Creating a Tablespace
- Creating a Datafile
Running the utility
- Copy the ojdbc5.jar if DB is 12c
- SQLPlus session
- NLS_LANG=UTF8
- oim_blkld.sh -online (default)
- select options
- 2nd menu
- Either CSV File or DB Tables
Loading OIM User Data
- Setting a Default Password for OIM Users Added by the Utility (Uses an existing user's password)
- Creating the Input Source for the Bulk Load Operation
- Determining Values for the Input Parameters of the Utility
- Monitoring the Progress of the Operation
- Handling Exceptions Recorded During the Operation
- Fixing Exceptions and Reloading Data Records
- Verifying the Outcome of the Bulk Load Operation
- Generating an Audit Snapshot
-------------------------------------------------------
- Loading Account Data
- Loading Role, Role Hierarchy, Role Membership, and Role Category Data
- Loading Organization Data
- Data Recorded During the Operation
- Gathering Diagnostic Data from the Bulk Load Operation
- Cleaning Up After a Bulk Load Operation
- Bulk Load High Volume Strategy and Case Studies
