Hi Sailors, We are currently integrating an application with SailPoint IdentityIQ and wanted to get suggestions on the best approach. Our application team has provided the following: * **Database queries (JDBC)** for account and entitlement aggregation. * These queries are **read-only**. * We do…

@Harikrishna_06 Please check this post: https://community.sailpoint.com/t5/IdentityIQ-Forum/Mixed-connector-for-in-outbound/m-p/131985#M113866 So you might want to configure two apps: one for aggregation and webservice one for provisioning. This type of integration called as Dual Channel or Mixed …

As you are rightly assuming, using two separate applications would complicate things. There will be duplicate accounts in IIQ for each target account. IMO, if the API are not that complex then JDBC connector would be better choice for aggregation and provisioning rules to call API. Custom connecto…

Hi @Harikrishna_06 , The recommended approach would be to use JDBC connector and use APIs to perform Create , Update and Delete Operations in Operation specific rules in JDBC

Thank you for the replies. Is there any other better approach recommended.

Hi @Harikrishna_06 , You can make use of integration config to handle this requirement. Solved: Integration Config vs Before Provisining Rule - Compass Solved: Integration Config Architecture Question - Compass Thanks

[image] Harikrishna Tungala: We are currently integrating an application with SailPoint IdentityIQ and wanted to get suggestions on the best approach. Our application team has provided the following: Database queries (JDBC) for account and entitlement aggregation. These queries are read-o…

[image] Sanjay Sutar: custom Hi @Harikrishna_06 What I have done in such cases previously is: Use JDBC connector to perform account/group aggregation Build an IntegrationConfig and custom Integration executor class to invoke rest apis to do the provisioning. Register your applicatio…

Hi @pradeep1602 , Can you please share the reference for integrationconfig and java code. It will be helpful to work. Thank you Harikrishna

Hi @Harikrishna_06 , Unfortunately I don’t have access to the code I built previously. But I am sure if you search on community.sailpoint.com you can find some examples.

You can probably refer this post as well: [image] IntegrationConfig IIQ Discussion and Questions Which IIQ version are you inquiring about? Version 8.3 Share all details related to your problem, including any error messages you may have received. Hello Team, …

You can also use this as reference: [image] src/com/identityworksllc/iiq/common/integration/NoOpIntegrationExecutor.java... IIQCommon is a utility library used in virtually all of our SailPoint IdentityIQ installations and plugins. This is the ever-expanding open source portion of this …

SailPoint IIQ Integration – Read via JDBC queries and Provisioning via REST APIs

IdentityIQ (IIQ) IIQ Discussion and Questions

pradeep1602 (Pradeep gupta) May 30, 2026, 6:42am 11

You can probably refer this post as well:

Please mark this as solution if it resolves your query

Topic		Replies	Views
Provisioning of users in two different databases using a single JDBC connector application in IIQ Community Blog	2	216	June 16, 2026
For JDBC Application, Requests stuck in provisioning state ISC Discussion and Questions identity-security-cloud , identityiq	3	709	January 23, 2024
IIQ (8.1) JDBC Provisioning rule IIQ Discussion and Questions identityiq , provisioning	4	774	August 5, 2024
Enhancement: Low-Code Provisioning for JDBC – Simplifying Database Integration with Identity Security Cloud Product News identity-security-cloud , connectors , new-enhancement	7	747	May 15, 2026
Need to connect to target application with both JDBC and rest API connectors IIQ Discussion and Questions apis , aggregation , identityiq , connectors , entitlements	2	122	November 6, 2024

SailPoint IIQ Integration – Read via JDBC queries and Provisioning via REST APIs

Related topics