You can use the point-and-click filter builder for the specified data source.

NOTE: If the Where Clause is also specified, it will be applied and the DataSource Filter will be ignored.

Defines the column in the Data Source that will be used to determine if the user account already exists. This value is compared to the Active Directory Anchor Attribute.

Because user names are likely to have duplicates, some other attribute with a unique value should be used to determine if records read from the Data Source have already been processed.

Defines the attribute in the Active Directory to which the Data Source anchor attribute is to be compared.

This setting defines the search query scope.

To improve query performance, limit the scope to specific OU.

Query criteria are sent with the query and may improve query performance.

Specify the name of the SQL Instance as defined in the Utils extension settings SQL Server configuration. Using the Default SQL Instance setting will retrieve the current setting from the SQL Connection settings of the Utils extension.

NOTE: For more information, please see Connecting to Microsoft SQL Server data source article.

Specify the database from the data source SQL Instance. Click the [...] button to enter SQL Credentials.

NOTE: The Cayosoft Administrator does not support Windows Authentication for connecting to a Microsoft SQL Server database. The database connection must use SQL Server Authentication, where the credentials (username and password) are created and managed within SQL Server itself. Mixed Mode refers to the SQL Server configuration that allows both SQL Server Authentication and Windows Authentication, but only SQL Server Authentication is supported by Cayosoft.

Specify the database name from the selected SQL Instance.

Define a WHERE statement in the SQL query sent to the data source to limit the rows returned by SQL Server.

NOTE: If the Datasource filter is also specified, it will be ignored.

Define a SELECT statement to override all query settings, including SQL table, Data Source filter, and Data Source WHERE clause.

IMPORTANT: The statement must include a Data Source Anchor attribute column in the result set matching the attribute name in the Data Source Anchor attribute field.