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:
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.
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.
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.
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:
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center