Query Settings

Configure the SQL queries IdentityIQ 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.

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

Select the Use Stored Procedure checkbox to execute a stored procedure on the database.

Note
If the Test Connection SQL query is not provided, then the connector uses the Account Aggregation query to connect to the managed system.
Enter an SQL Statement attribute that can be used to customize the selected statement that is generated when iterating over objects. You can specify the exact SQL Statement that is executed if you want to filter out objects or only want to select a few objects from a table. Additionally, if you need to perform joins between more than one table, it's impossible to describe with the schema alone.

Select the Use Stored Procedure checkbox to execute a stored procedure on the database.
(Optional) Enter the getObjectSQL statement.

Select the Use Stored Procedure checkbox to execute a stored procedure on the database.
Select Save.

Feedback is provided as an informational resource only and does not form part of SailPoint's official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.


	You are here:

Query Settings

Documentation Feedback