Two hands are holding holographic documents which are being interchanged.

OrangeHRM is an open source HRM system. In this guide, we are going to use it as the authoritative source for Dell Identity Manager.

Data Connectivity

First, we need to ensure data connectivity between the OrangeHRM and Dell Identity Manager system. In my test environment, I have both systems running on the same server. Since OrangeHRM has a MySQL backend, we installed the MySQL ODBC Connector our server and created an ODBC Data Source for the OrangeHRM database.

Data Import

Next, we will use the Data Import tool to perform the initial load and create a script that we can use later on when we automate the import process.

Step 1: Launch the Data Import tool

Step 2: In the Welcome screen, click Next.

Step 3: Login as a system user.

Step 4: We do not have an import definition file, so just click Next on the “Loading an import definition file” screen.

Step 5: Select Import from database. Click Next.

Step 6: In the “Select external database” screen, choose Odbc Data Provider as the Connection type. Enter Dsn=orangehrm as the Connection data. Make sure you replace “orangehrm” with whatever name you used in your ODBC data source setup. (TIP: Click on the lock icon to encrypt/decrypt the Connection data value). Click the Check to test the connectivity. When the smiley face turns yellow, the Next button will become enabled. Click Next.

Selecting database to get the data from.

Step 7: We're only interested in the employee id, first name and lastname, so in this screen, I chose to specify a simple sql statement.

Step 8: Set Target table = Person. Map the orangehrm columns to appropriate Person attributes in Identity Manager. Choose UID_Person as the primary key. TIP: Click the magic wand button in the top right are of the screen to make Identity Manager suggest mappings.

Matching target tables and columns in Data import.

Step 9: We are just going to accept the default options of inserting new records and updating existing ones. Click Next.

Handling options for data sets in data import.

Step 10: In the Connection Variables screen, we don’t need to specify any connection variables, so just click Next.

Step 11: Specify a location where to save the import definition file in case we need to use it again in the future. Also check the “Create import script” option. Click Next.

Saving the import definition on data import.

Step 12: When prompted to compile the database scripts, click Yes.

Step 13: When the database compilation is complete, click Next.

Step 14: Data Import process will run and give you a report on statistics of the import. Click Next.

Step 15: Data migration is complete. Click Finish.

Step 16: Login to Manager and confirm new employee records have been created.

Confirming new employee records have been created in Manager.

Our next guide will cover how you can automate the data import process and have it run on schedule.

Dell Identity Manager – How to Import Data From OrangeHRM

Services

Solutions

Pricing

Resources

Events

About Us

Get Started