Is there a way to connect Power BI and Outsystems as well as its Database??
Hello Frances,
Yes, you should be able to do so.
If you're using an on-prem infrastructure, you can create some views in the OutSystems database server and use a ODBC connection to access that data.
Another solution would be simply expose an OutSystems API and consume it in your data warehouse system. For example, we have several solutions where we consume an OutSystems API with PowerCenter and pull this data to Teradata. Once it is in Teradata, you can create dashboards and reports with Power BI or Qlik Sense tools.
Hope that this helps you!
Kind regards,
Rui Barradas
hallo @Frances Abadilla ,
can you check next component Power BI - Embed Reports Reactive may help you
https://www.outsystems.com/forge/component-overview/10463/power-bi-embed-reports-reactive-o11
Hi Frances,
Another option although will take extra configuration, would be to create an Azure Blob Storage Subscription and Storage account, you could then create a process to create a container and then a blob which would house the excel/csv data from Outsystems into the blob.
You can do this using an Azure Blob Storage connector in the forge.
You can then create the connection between the Azure Blob Storage Account and Power BI.
If you just overwrite the excel/CSV file every time you want to update the data then you can just refresh the data in Power BI.
One possible approach that we used in one of our projects is - We have an on cloud infrastructure, however, we have a back up database for different purposes that pulls the data every day (the frequency of sync between the two databases can be configured based on your need ) from OutSystems database. Power BI points to this back up database and generates the desired reports.
Hope it helps!
Junaid