Expose Saviynt table data to external tools like PowerBI for reporting

[AP3]

Hi,

We are have a use case where we want to expose few Saviynt tables to PowerBI so that reports can be build from there. Saviynt have the analytics capability but as client have PowerBI as central tool for reporting so we want to use that building report Saviynt as well.

Has anyone done this kind of integration before?

Thanks.

[adarshk]

Saviynt does not expose the data tables to external tools. 

You can get export the results from Saviynt Analytics and use the export or use Saviynt APIs 

https://documenter.getpostman.com/view/1797923/RWaLwo21#2ee1eb47-d65a-4b82-b25c-adc7e91d1b1b

[rushikeshvartak]

we have implemented same use case. below is high level process

• Create report with required details
• create external Jar 
• use saviynt APIs to generate files
• use SFTP connector to send file on target location

Saviynt REST API doc - https://documenter.getpostman.com/view/23973797/2s9Ykhh4VH 

In another client , report is manually uploaded to shared location and Power BI daily pulls from location

[AP3]

But this will not be real time data. The process has to run frequently to upload latest data.

[rushikeshvartak]

You can't have real time. however you can schedule the job on set frequency