Chat now with support
Chat with Support

Quick Connect for Base Systems 2.4 - Administration Guide

Installing One Identity Quick Connect for Base Systems Working with a delimited text file Working with an LDAP directory service Working with Microsoft SQL Server Working with Novell eDirectory Working with an OLE DB-compliant relational database Working with Oracle Database Working with Oracle user accounts Working with Sun One Directory Server Working with OpenDS Working with Red Hat Directory Server Working with MySQL database Working with IBM DB2 Working with an ODBC-compliant data source Working with an OpenLDAP directory service

Working with Oracle user accounts

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:

 

Table 10: Supported features

Feature

Supported

Bidirectional synchronization

Allows you to read and write data in the connected data system.

Yes

Delta processing mode

Allows you to process only the data that has changed in the connected data system since the last synchronization operation, thereby reducing the overall synchronization operation time.

No

Password synchronization

Allows you to synchronize user passwords from an Active Directory domain to the connected data system.

Yes

Password synchronization is only supported for user accounts that are authenticated entirely by Oracle Database. Oracle User Accounts Connector does not support password synchronization for Oracle user accounts that use external or global authentication in Oracle terms.

This section covers:

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

Working with Oracle user accounts > 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

Working with Oracle user accounts > 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:

    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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating