Account Query Settings

Configure the SQL queries IdentityNow uses to retrieve account data from your JDBC server.

1. (Optional) Enter a simple SQL query to test the connection to the database in the Test Connection SQL Query field.

   Select the Use Stored Procedure for Test Connection SQL Query checkbox to execute a stored procedure on the database.

2. Enter an SQL query to load accounts into the Account SQL Query field.

   Select the Use Stored Procedure for Account SQL Query checkbox to execute a stored procedure on the database.

3. (Optional) Enter an SQL query to load a single account into the Single Account SQL Query field.

   Select the Use Stored Procedure for Single Account SQL Query checkbox to execute a stored procedure on the database.

4. Select Save.