Integrating IIQ to PowerBI

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

8.4p2

Share all details about your problem, including any error messages you may have received.

Hi All, I have a requirement to integrate IIQ to PowerBI for reporting purpose/dashboard, I could not find any documentation specific to IIQ, so I was wondering if anyone has connected IIQ to PowerBI or have any suggestions on how to go about it.

2

Hi @soumayv
Sailpoint IIQ’s OOTB reporting is limited, especially for dashboards. While there is no direct document for IIQ to power BI. Here are some approaches I consider.

  1. You can connect power BI directly to the IIQ database [MYSQL, SQL server, Oracle] using JDBC connectors.
  2. Next method is using SailPoint IIQ reports export by running IIQ report and Export CSV/XML outputs then load into Power BI.
3

Hi
SailPoint IdentityIQ has limited out-of-the-box (OOTB) reporting and dashboard capabilities, but it can be effectively integrated with Power BI using this common approaches.
This involves connecting Power BI directly to the IIQ backend database (such as MySQL, Oracle, or SQL Server).
This allows real-time access to identity data by using Power BI’s built-in database connectors.
After establishing a read-only connection using the appropriate connector, users can select relevant tables such as spt_identity, spt_identity_entitlement, spt_link, spt_work_item, and spt_audit to build dashboards for tracking user access, approvals, provisioning status, and more.