Account Query Settings

Configure the SQL queries Identity Security Cloud uses to retrieve account data from your JDBC server.

Important
SQL entries can't end with a semicolon (;). Ending an SQL entry with a semicolon (;) can cause a general error message to display.

  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.