Hi guys,
Quick question: do you know if there is a way to connect Power BI to the d/EPM staging database and report from it?
Thanks,
Daniel
This is a subject I would really like to explore. Ideal would be to be able to get a connection directly to the OLAP cubes. Where a successful connection has been made the use of the OAuth2 API seems to be the way to go. This does exist in the Infor OS API library. It would be ideal to be able to surface Info Dashboards inside PowerBI as a frameset so we could "use" PowerBI as a front end for Budgeting and forecasting
That would be awesome too. But can it be done?
To my knowledge, this is not possible. We have investigated this some years back with Tableau as a frontend.
We have been told, that Birst was the only frontend-tool available, but as this is no option for us, we export the data from Infor and display this in Tableau. Not the best solution and a direct connection would be preferred.
As Mike mentioned OAuth2 could potentially be the bridge we are looking for. From a high level perspective we don’t necessarily need to access the cubes rather the relational database…
Would be nice to get some eyes on this from Infor. I’ll be following this thread for sure.
Agreed-I'll be following as well
Hi, thanks for that comment, so far we got feedback from Microsoft that PowerBI stopped supporting cube like connection and want everyone to work through table-based API.
Still, using Staging database is the wrong approach due to the very definition of that storage - it is 'staging', not data warehouse. It also consumes data limits, so definitely not something I would recommend to use in the cloud. Instead, Infor is working on the data warehouse as a service approach where data from d/EPM and other systems can be stored in single DB on top of Data Lake.
Just stopping by... Once the Datawarehouse as a service is available, I assume that d/epm data will be publishable to the warehouse and PowerBI will read directly from the warehouse. The reason we have suggested the Oauth API is because this how another OLAP tool makes the connection from PowerBI. PowerBI connects directly to the cubes and extracts the data for transformation in PBI and then there is just a single data refresh required to get the latest data. This is a single tenant solution.
Have you explored creating App Studio interfaces for the front end? Any specific reason you prefer Power BI? I assume you are seeking to do data entry for budgeting/forecasting as well as reporting.
Hello Malte,
how do you export the data from Infor d/EPM -> Excel Integration, Self Service or Application Studio ?
Hi Christian,
We export to a relational database. You could use AppEngine or the Importmaster (on-prem only) for the export.
Best regards,Malte
