Identity Manager 8.1.4 - Administration Guide for Connecting to Native Databases through Database Systems Integration Module

Working with Oracle Database

This chapter provides information about the Oracle database template provided in the Database Systems Integration (DSI) module that is used to create mappings, workflows, startup configurations, and synchronize objects.

Features supported

Features supported

The following features are supported in the Oracle database template:

• Read all user accounts and their attributes

• Read all user roles

• Read all user profiles

• Read all tablespaces

• Read user role membership

• Read role membership

• Create and delete operations for users

• Change password for users

• Lock or unlock users
• Change role membership
• Change user role membership

Prerequisites to configure the Oracle database

Ensure that the following prerequisites are met before configuring Oracle database:

• Ensure that the information about the following attributes are available.

  • Hostname
  • Service name
  • Port
  • Username
  • Password
• The native database configuration server function must be enabled on the Designer for the Job server.

For more information on assigning server function, refer to the One Identity Manager Configuration Guide.

Creating a synchronization project

Creating a synchronization project

The following procedure describes how to create and configure synchronization projects to work with the Oracle database.

To create a synchronization project

1. Open the Synchronization Editor.
2. On the Start page, select Start a new Synchronization Project.
3. On the Choose target system page, select the Native Database Connector check box and click Next.
4. Select Create New System Connection.
5. Select Oracle Database.
6. By default, the Direct Access check box is selected. If not, select the check box and proceed further.
7. Define the connection parameters as mentioned here:
   • Server: Provide the Hostname.
   • Port: Provide the port to the database. By default, the port text field is populated.
   • Service Name: Provide the service name of the Oracle database.
   • User: SYSTEM.
   • Password: Provide the password created during Oracle database installation.
8. Click Extended and set Connect Mode to SYSDBA.
9. Provide the display name and the identifier.

10. Select the DSI_ORACLESQL_Configuration.xml configuration file available at DSI/ConfigFiles in the OneIM installation folder, and click Next.

11. Click Finish.

    The schema loading window is displayed.

12. After the schema is loaded, the Template Selection page is displayed.
13. Select Oracle Database Template and click Next.

    Follow the on-screen instructions until the Provisioning Capability window is displayed.

14. Select the synchronization server and click Finish.

    The synchronization project is created successfully.

After creating the synchronization project, set the variable value in the DefaultUserPassword field.