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