Interface IFS APPS10 data with PowerBI

Question

Hello All,We would like to have IFS data with PowerBI so we can have live reporting. does anyone know how to do the complete setup process so that we can access IFS data (some particular table or view) in PowerBi app? (For IFS APPS10 UPD22). Thank you in advance.

Marcel.Ausan · Answer

@SaaAvinakin Apps10 this would be possible only if you have a access to a DB user that has read access on the views that you wanna query. If it’s an on-prem installation, then probably you have DB access already, but for IFS Managed/Hosted environment this would be more difficult to get.Once you have access to the DB via PL/SQL, you could:install ODAC (Oracle Data Access Components) on the servere where you have PL/SQL installed →64-bit Oracle Data Access Components (ODAC) for WindowsThe you should be able to connect to an Oracle Datasource via ODAC from Power BI. Also below article might be helpful.Getting Power BI Desktop to work with Oracle ODAC ... - Microsoft Fabric CommunityWhen it comes to IFS Cloud there’s dedicated functionality for Self-Hosted BI😁, but not for Apps10.Index - Technical Documentation For IFS Cloud

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded