# Is it possible to reading the data JDBC connecton and Provisioning to Excel

**URL:** <https://developer.sailpoint.com/discuss/t/is-it-possible-to-reading-the-data-jdbc-connecton-and-provisioning-to-excel/21619>\
**Category:** SHF Discussion and Questions\
**Tags:** identity-security-cloud, provisioning\
**Created:** [November 28, 2023, 12:27am UTC](https://developer.sailpoint.com/discuss/t/is-it-possible-to-reading-the-data-jdbc-connecton-and-provisioning-to-excel/21619 "2023-11-28T00:27:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pkumar22](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@pkumar22](https://developer.sailpoint.com/discuss/u/pkumar22)\
**Post date:** [November 28, 2023, 12:27am UTC](https://developer.sailpoint.com/discuss/t/is-it-possible-to-reading-the-data-jdbc-connecton-and-provisioning-to-excel/21619/1 "2023-11-28T00:27:47Z")

</div>

We want to aggregate the data form DB using the JDBC conncetion and provisioning need provision to excel file.

Is this possible?

Thanks.

---

<div class="post-metadata">

**Author:** ![kjakubiak](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/kjakubiak/32/7052_2.png) [@kjakubiak](https://developer.sailpoint.com/discuss/u/kjakubiak)\
**Post date:** [November 28, 2023, 8:18am UTC](https://developer.sailpoint.com/discuss/t/is-it-possible-to-reading-the-data-jdbc-connecton-and-provisioning-to-excel/21619/2 "2023-11-28T08:18:05Z")

</div>

Hi Prasantha,  
Generaly both Identity IQ and Identity Now expects that you will be consistent with connection - that means if you use JDBC connection then you use it for both aggregation and provisioning.

It is possible to build some “hybrid” solution but it’s definitely far from standard approach. Anyway simply speaking - you would need to for sure use 2 separate connectors for that. JDBC to aggregate data and then for example do provisioning via business roles to the second application which would be XLSX file in this case.

Of course you also need to be aware that you are in cloud so it might be tricky to generate file.

---

<div class="post-metadata">

**Author:** ![adunker](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/adunker/32/2664_2.png) [@adunker](https://developer.sailpoint.com/discuss/u/adunker)\
**Post date:** [November 28, 2023, 3:55pm UTC](https://developer.sailpoint.com/discuss/t/is-it-possible-to-reading-the-data-jdbc-connecton-and-provisioning-to-excel/21619/3 "2023-11-28T15:55:46Z")

</div>

You could consider a Web Services connector with some additional infrastructure. You could build an Azure Function that would read from the database via an API call and then the provisioning API calls could go to something like a Power Automate flow to manipulate the Excel doc.

---

<div class="post-metadata">

**Author:** ![pkumar22](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@pkumar22](https://developer.sailpoint.com/discuss/u/pkumar22)\
**Post date:** [January 12, 2024, 1:43am UTC](https://developer.sailpoint.com/discuss/t/is-it-possible-to-reading-the-data-jdbc-connecton-and-provisioning-to-excel/21619/4 "2024-01-12T01:43:29Z")

</div>

We have removed the JDBC source provision feature string. Once the user is requested the roles manual work item will get generated, and based on the work items API using Powershell, we are provisioning to Excel.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [March 12, 2024, 1:44am UTC](https://developer.sailpoint.com/discuss/t/is-it-possible-to-reading-the-data-jdbc-connecton-and-provisioning-to-excel/21619/5 "2024-03-12T01:44:26Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.