Good news! The BI Connector, a Power BI-certified connector is created exactly for this purpose!
With BI Connector, it's possible to extract your Oracle Fusion data directly to Power BI. Please check it out below: https://www.biconnector.com/po...
The connector works seamlessly with both Power BI Desktop and Service (or Report Server) and supports Import and Direct Query modes. It also retains the underlying table joins in the Oracle Fusion Cloud, so you don't have to recreate them from scratch in Power BI.
Financial Systems Advisor - US Controller Group at McDonald's
Real User
2023-04-19T16:31:59Z
Apr 19, 2023
Hi Ross,
Easy is a tricky description...We are going through this effort too. We are 'grappling' with the governance of this type of access as well as the technical journey. So you are not alone.
Fusion Middleware applications include a number of connectivity options including native client or Oracle Data Access Components (ODAC), with OLEDB, JDBC, etc., on top. Each has its own quirks. This is the 'plumbing' between the analytic tool and source.
Adding to that is the cloud and database level security of the data source.
A good way to start is to use Oracle's SQL Developer to connect to your data source. It gives developers a great query tool for Oracle and other databases. (https://www.oracle.com/databas...)
Once you understand what you can access, you can easily migrate that connectivity to Power BI.
Moreover, you will have validated queries that you can test directly or simply bring in the tables using the PBI Navigator.
I had the experience of supporting a client.
Could not connect Oracle to Power BI gave an error I learned the following:
The problem is that Microsoft documentation is a simple process and not detailed.
1 - Install and configure the Oracle client (depends on the version)
2 - Must be compatible with the BI desktop version.
3 - Configure the gateway in the BI service.
I suggest you look for someone expert in Oracle to install and configure it for you.
Hi Ross,
Good news! The BI Connector, a Power BI-certified connector is created exactly for this purpose!
With BI Connector, it's possible to extract your Oracle Fusion data directly to Power BI. Please check it out below:
https://www.biconnector.com/po...
The connector works seamlessly with both Power BI Desktop and Service (or Report Server) and supports Import and Direct Query modes. It also retains the underlying table joins in the Oracle Fusion Cloud, so you don't have to recreate them from scratch in Power BI.
Thanks,
Dinesh
Hi Ross,
Easy is a tricky description...We are going through this effort too. We are 'grappling' with the governance of this type of access as well as the technical journey. So you are not alone.
Fusion Middleware applications include a number of connectivity options including native client or Oracle Data Access Components (ODAC), with OLEDB, JDBC, etc., on top. Each has its own quirks.
This is the 'plumbing' between the analytic tool and source.
Adding to that is the cloud and database level security of the data source.
A good way to start is to use Oracle's SQL Developer to connect to your data source. It gives developers a great query tool for Oracle and other databases. (https://www.oracle.com/databas...)
Once you understand what you can access, you can easily migrate that connectivity to Power BI.
Moreover, you will have validated queries that you can test directly or simply bring in the tables using the PBI Navigator.