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 all accounts into the Account SQL Query field.

    For example, you can use the following:

    SELECT userid, fname, lname FROM users

    Enable Use Stored Procedure for Account SQL Query 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.

    This query may match the Account SQL Query, but the single account query includes a WHERE clause to filter results for one specific user. To accomplish this, the query uses the $(identity) placeholder which the connector dynamically replaces with the actual NativeIdentity of the user at runtime.

    For example, if your NativeIdentity is userid, you can use the following:

    SELECT userid, fname, lname FROM users WHERE userid = '$(identity)'

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

  4. Select Save.