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…

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.

@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 …

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, …

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

IdentityIQ (IIQ) IIQ Discussion and Questions

IslamElkhouly (islam elkhouly) May 31, 2026, 6:05am 15

I had a similar scenario before, where we used the out-of-the-box (OOTB) connector for aggregation and APIs for provisioning. This link should be helpful for your use case.

I also have a question: what is preventing you from using APIs for both aggregation and provisioning?

Topic		Replies	Views
Provisioning of users in two different databases using a single JDBC connector application in IIQ Community Blog	2	159	June 16, 2026
For JDBC Application, Requests stuck in provisioning state ISC Discussion and Questions identity-security-cloud , identityiq	3	690	January 23, 2024
IIQ (8.1) JDBC Provisioning rule IIQ Discussion and Questions identityiq , provisioning	4	623	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	654	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	98	November 6, 2024

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

Related topics