Allows you to configure the execution timeout for all SQL queries you specified in the connection settings (for example, those specified in the Specify How to Select and Modify Data option). Use the SQL query execution timeout box to type the timeout value you want to use.
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:
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) |
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy