Chat now with support
Chat with Support

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

Database Systems Integration Module Installing DSI Working with Oracle Database Working with MSSQL Working with SAP HANA Working with the MySQL database template User scenario Troubleshooting

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 generic 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 Generic Database Connector check box and click Next.
  4. Select Create New System Connection.
  5. Select Oracle Database.
  6. Define the connection parameters as mentioned here:
    • Data source: please use the sample connection string below to form your data source
      (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = {server})(PORT = {port}))
      (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME ={service name})))
      • Server: Provide the hostname.
      • Port: Provide the port to the database. By default, the port is 1521.
      • Service name: Provide the service name of the Oracle database.

    • Username: SYS

    • Password: Provide the password created during the oracle installation

  7. Click Extended and set DBA Privilege to SYSDBA.
  8. Provide the display name and the identifier.

  9. Select the DSI_ORACLESQL_Configuration.xml configuration file available at DSI/ConfigFiles in the DSI Module folder, and click Next.

  10. Click Finish.

    The schema loading window is displayed.

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

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

  1. 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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating