Skip to main content
Question

Is there any way I can get data from IFS (Aurena) in Power BI? 

  • May 24, 2022
  • 4 replies
  • 468 views

Forum|alt.badge.img+7

Is there any way I can get data from IFS (Aurena) in Power BI? 

4 replies

Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 9 replies
  • May 24, 2022

Hi,
I am also looking for a best practice here. Integrating the Oracle database directly would be the easiest, but I guess it's not allowed due to licensing reasons. 
Therefore, I will probably create quick reports with the required information and read them out via the REST-API. The whole process can be automated and could be updated every x minutes.
Does anyone know an simpler way?


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Customer)
  • 15 replies
  • May 25, 2022

thanks for your reply, Hoehn. Is there any manual available for the REST-API?


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 9 replies
  • May 30, 2022

Forum|alt.badge.img+2
  • Do Gooder (Employee)
  • 10 replies
  • December 5, 2022

If you are running on APP 10, it is possible to access IFS Oracle Database from Power BI. Of course, you cannot connect directly to the database. Power BI would drop down immediately due to huge amount of data. There are some steps which needs to be included to get data from database in to Power BI. 

  1. Install Power BI Gateway. 2. Create new workspace in web Power BI environment 3. Create own Data flow utilizing Power BI Gateway connection 4. Create your own model and set scheduling for data transfer.