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

The following features are supported in the Oracle database template:

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

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

To create a synchronization project

Open the Synchronization Editor.
On the Start page, select Start a new Synchronization Project.
On the Choose target system page, select the Generic Database Connector check box and click Next.
Select Create New System Connection.
Select Oracle Database.
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
Click Extended and set DBA Privilege to SYSDBA.
Provide the display name and the identifier.
Select the DSI_ORACLESQL_Configuration.xml configuration file available at DSI/ConfigFiles in the DSI Module folder, and click Next.
Click Finish.
The schema loading window is displayed.
After the schema is loaded, the Template Selection page is displayed.
Select Oracle Database Template and click Next.
Follow the on-screen instructions until the Provisioning Capability window is displayed.

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.