Quick Connect for Base Systems 2.4 - Administration Guide

Working with Oracle user accounts

This section explains how to create or modify a connection to Oracle Database so that One Identity Quick Connect for Base Systems could work with user accounts data in that data system.

To create a connection to Oracle Database so that you could work with user accounts in that data system, you need to use One Identity Quick Connect Sync Engine in conjunction with a special connector called Oracle User Accounts Connector. This connector is included in the One Identity Quick Connect for Base Systems package.

The Oracle User Accounts Connector supports the following features:

This section covers:

• Creating an Oracle user accounts connection
• Modifying an existing Oracle user accounts connection
• Sample SQL queries

For instructions on how to rename a connection, delete a connection, modify synchronization scope for a connection, or specify password synchronization settings for a connection, see the One Identity Quick Connect Sync Engine Administrator Guide.

Creating an Oracle user accounts connection

To create a new connection

1. In the Quick Connect Administration Console, open the Connections tab.
2. Click Add connection, and then use the following options:
   • Connection name. Type a descriptive name for the connection.
   • Use the specified connector. Select Oracle User Accounts Connector.
3. Click Next.
4. On the Specify connection settings page, use the following options:
   • Oracle service name. Specify the name of the Oracle service you want to use to access Oracle Database. You can click Refresh to get a list of available Oracle services.
   • Access Oracle service with. Type the user name and password of the account with which you want to access the Oracle service.
   • Test Connection. Click this button to verify the specified connection settings.
5. Click Finish to create a connection to Oracle Database.

After connecting One Identity Quick Connect Sync Engine to Oracle Database with the Oracle User Accounts Connector, you can specify custom SQL queries you want to automatically run each time after One Identity Quick Connect Sync Engine has created, updated, or deleted a user account in Oracle Database. For more information, see Modifying an existing Oracle user accounts connection.

Modifying an existing Oracle user accounts connection

To modify connection settings

1. In the Quick Connect Administration Console, open the Connections tab.
2. Click Connection settings below the existing Oracle Database connection you want to modify.
3. On the Connection Settings tab, click an appropriate item to expand it and use the options it provides.

   You can expand the following items:

   • Specify connection settings
   • Advanced

   See the next subsections for the descriptions of these items.

4. When you are finished, click Save.

Specify connection settings

This expandable item provides the following options that allow you to modify the connection settings:

• Oracle service name. Specify the name of the Oracle service you want to use to access Oracle Database. You can click Refresh to get a list of available Oracle services.
• Access Oracle service with. Type the user name and password of the account with which you want to access the Oracle service.
• Test Connection. Click this button to verify the specified connection settings.