Anyone using DataExtract in IIQ 8.4 with Power BI? Looking for JMS setup insights

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Hi all,

Is anyone actively using the DataExtract feature in SailPoint IIQ 8.4 and integrated it with Power BI (or similar BI tools)? IdentityIQ 8.4 - Data Extract - Compass

Would like to hear:

  • What kind of data you’re extracting, and any limitations you’ve faced?
  • How is JMS configured for the extract (broker used, setup tips, issues)?
  • How is the data integrated into Power BI (file-based, staging DB, etc.)?

Looking for real-world examples or references. Appreciate any inputs!

Thanks!

2

Hi @kaselva

I have seen uses cases where data sources are created and database queries are run against identity iq tables and the data is dissolved as dashboards in tableau.

1 Like
3

Hi Karthikeyan,

Yes, the DataExtract feature in IIQ 8.4 can be used to extract identity and entitlement data. Typically, people extract it either as files (CSV/JSON) or load it into a staging database, which can then be connected to Power BI or other BI tools.

For JMS, ActiveMQ was commonly used, but from 8.4p2 onwards, it’s not required for DataExtract.

Integration with Power BI is usually file-based or via a staging DB. Some limitations include handling large volumes of data and ensuring timely updates.

4

I did this at one of my customer:

Worked out pretty well.

1 Like
5

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