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 Oracle server hostname (or its IP address) to which Cayosoft Administrator will connect.

By default, the value is taken from the Utils extension settings.

NOTE: For more information, please read the Connecting to Oracle database article.

Specify Oracle user account name and password.

Specify the Oracle database service name.

Specify Oracle SQL*Net Listener port number; the default is 1521.

Define a WHERE statement in the query sent to the data source to limit the rows returned by the Oracle 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.