Is there anyway to integrate Pega with Power BI tool? intention not to use any ETL tool like bix to load the data to other DB and use reporting tool. Is there any way to leverage a reporting tool from Pega directly?
***Edited by Moderator: Pallavi to change content type from Discussion to Question***
Even though BIX is an ETL tool it cannot transform the source data in to different formats and load the data in to target DB. The main purpose of BIX tool is to deflate the data that is inside the BLOB and insert in to in-house or separate data base so that this data can be used for any other reporting purposes by down stream systems. Any other tool cannot read this data from the BLOB as the data in the column is understandable by Pega. BIX doesn't have any configurations to transform the data in to various formats and load it to external DB. The data in Pega DB is loaded in to external DB as is by deflating the BLOB. As this is within Pega data extraction will be quick.
Power BI : Power BI is an ETL tool and predominantly it is used for Reporting purposes. Power BI can have the capability to read the flat columns but it cannot understand the BLOB column of Pega as there wont be specific configuration to read the BLOB column of Pega. But BIX extract rule is the configuration in Pega that will be used to configure the properties for which the data is required. The properties can be either the exposed columns or the property residing inside the BLOB.
As per my knowledge BIX is only the reporting tool that is used widely to pull the Pega Data.
As of now Reports in Pega can be built only by using existing Reporting feature. But as reporting will consider millions of records to provide various in-sights on the data the best way is to use external reporting tools as they are specifically built for that purpose and also they will be having support for various functionalities and advanced features. If we use Pega for pulling large sets of data this will result in degrading the Performance of the system.
1. Do you have similar implementation connected with Prod server pega DB? is there any limitation/challenges if we really connect to Prod system? Nope, I did this POC for your request. But if you implement in enterprise level, it should work.
2. Is it only doable with powerBi desktop app? what about web? I don't have any web access, but if you see the power BI architecture diagram, web also supports the DB connection.
3. How secure the connectivity approach for production data? We are doing simple DB connection - if the enterprise BI has all the corporate security policies enabled. It should be secure.