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

Specify attributes to identify objects

This expandable item provides the following options that allow you to specify the attributes with which you want to uniquely identify each object in the connected data system:

  • Available attributes. Lists the attributes that are available in the external data system. Use this list to select the attributes whose values you want to use to generate a unique identifier for each object in the external data system. You can filter attributes by typing in the text box at the top of this list. To select multiple attributes, hold down CTRL and click to select attributes in the list.
  • UniqueID attributes. Lists the attributes whose values are currently used to generate a unique identifier for each object in the external data system.
  • Add->. Moves the selected attributes from the Available attributes list to the UniqueID attributes list.
  • <-Remove. Moves the selected attributes from the UniqueID attributes list to the Available attributes list.
  • Constructed UniqueID. Displays a combination of the attributes whose values will make up a unique identifier for each object in the external data system.

Sample SQL queries

Working with Oracle Database > Sample SQL queries

The sample queries provided in this section are only applicable if One Identity Quick Connect Sync Engine is connected to the target Oracle Database through the Oracle Connector.

Sample SQL query 1

This SQL query illustrates how to add a new entry to the table named SQLConnTest1 in Oracle Database to which you want to provision data from another connected system.

 

Table 9: Add a new entry to the SQLConnTest1 table

Database table structure

Sample query

CREATE TABLE "SQLConnTest1"("Id" number,"attr1" nchar(64), "attr2" nchar(64))

Insert into SQLConnTest1(attr1) values(:attr1) returning Id into :Id

In this sample query, Id stands for the attribute that uniquely identifies each object in Oracle Database.

Sample SQL query 2

This SQL query illustrates how to create a new user in Oracle Database:

call dbms_utility.exec_ddl_statement('CREATE USER ' || :USERNAME || ' IDENTIFIED BY ' || :newPassword)

In this sample query:

  • USERNAME refers to the name of the attribute that uniquely identifies a user in Oracle Database.
  • newPassword refers to the name of the attribute that will store the initial password you want to set for the Oracle user being created.
Related Documents