This section provides some sample SQL queries illustrating how to modify SQL Server data during synchronization operations. In the sample queries, Id refers to an attribute (a column name in an SQL Server table) that uniquely identifies an object in your SQL database. These examples can be used only for configuring connections to Microsoft SQL Server 2005.
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 Micro Focus NetIQ Directory so that Synchronization Service could work with Micro Focus NetIQ Directory data in that data system.
To create a connection to Micro Focus NetIQ Directory, you need to use Synchronization Service in conjunction with a special connector called Micro Focus NetIQ Directory Connector. This connector is included in the Synchronization Service package.
NOTE: Micro Focus NetIQ Directory was formerly know as Novell eDirectory.
The Micro FocusNetIQ Directory 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:
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
