This sample illustrates how to create a query that inserts an object with specified attributes into the table named SQLConnTest1.
Database table structure |
Sample query |
CREATE TABLE [SQLConnTest1]([Id] [bigint] IDENTITY(1,1),[attr1] [nchar](64),[attr2] [nchar](64))) | INSERT into SQLConnTest1(Id) values(@Id) |
This sample illustrates how to create a SQL Server account, and then retrieve the UniqueID attribute for that account.
To define the scope where to create the SQL Server account, insert the following query in the Query Editor dialog box:
SELECT sid as Id,name as login from sys.server_principals
Insert the following SQL query into the Configure SQL Statements dialog box:
EXEC sp_addlogin @login, @newPassword;
EXEC sp_adduser @login,@login,'db_owner';
SELECT sid as Id from sys.server_principals where name=@login;
|
IMPORTANT: None of attribute names used in SQL queries can include white-space characters. For example, you cannot use names such as "user password". |
This section describes how to create or modify a connection to Novell eDirectory so that One Identity Quick Connect for Base Systems could work with data in that data system.
To create a connection to Novell eDirectory, you need to use One Identity Quick Connect Sync Engine in conjunction with a special connector called Novell eDirectory Connector. This connector is included in the One Identity Quick Connect for Base Systems package.
The Novell eDirectory Connector supports the following 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 |
In this section:
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 Quick Connect Administrator Guide.
To create a new connection
From the Authentication method list, select one of the following methods:
You can also use the following check boxes:
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center