Is it easy to extract data from Oracle Fusion into Power BI?

Hello peers,  

I am looking into extracting reports, dashboards, and data from Oracle Fusion into Power BI. It is easy to do? What is the best practice for this?

Thank you for your help.

ICT Business Engagement at Ipswich City Council
  • 3
  • 52
PeerSpot user
3 Answers
Technical Marketing Specialist at Guidanz Inc
Apr 20, 2023

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:

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.


Product comparison that may be of interest to you
Ronald Chavez - PeerSpot reviewer
Cloud Services
Top 5
Apr 23, 2023

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.

Financial Systems Advisor - US Controller Group at McDonald's
Real User
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.

Related Questions
Solutions Architect at Seattle School District
Aug 19, 2023
Hi Community, I am a Solutions architect for a large educational organization. Currently, we use SAP HCM for concurrent employment. We are planning to upgrade, which one is better for concurrent employment: Oracle Fusion or SuccessFactors? As we have a lot of customization and complexity with payroll. Thank you for your help.
See 1 answer
Anne Cubarrubia - PeerSpot reviewer
Editor at PeerSpot
Aug 19, 2023
Oracle Fusion HCM and SuccessFactors are both enterprise-grade HCM solutions that can be used for concurrent employment. They have different strengths and weaknesses, so what would be better for concurrent employment will depend on your specific needs and requirements. Here is a comparison of the two solutions: Oracle Fusion HCM Pros: Strong integration with other Oracle products Highly customizable Robust reporting and analytics capabilities Cons: Complex to implement and maintain Expensive SuccessFactors Pros: Cloud-based solution Easy to use and configure Cost-effective Cons: Not as customizable as Oracle Fusion HCM Reporting and analytics could be improved If you are looking for a highly customizable solution with robust reporting and analytics capabilities, then Oracle Fusion HCM may be a good option. However, if you are looking for a solution that is easy to use and configure and that is cost-effective, many recommend SuccessFactors.
Founder & CEO at PiSigma
Apr 29, 2023
Hello community,  I am currently researching BI tools. I'm looking for a comparison between Sigma and Power BI in terms of costs, performance, and ease of use. Which of these solutions do you prefer and why? Thank you for your help.
See 2 answers
Ronald Chavez - PeerSpot reviewer
Cloud Services
Apr 29, 2023
The two are similar, it is cars but of different brands; I ask 1-) the users use Windows 2-) you have Office 365 3-) They will use Excel for the data. If you answer yes to the 3, better BI due to integration, and learning is easier for the user. If they are non-Microsoft databases, investigate on the provider's side, for example, SAP, IBM, etc. I have trained end users in Power BI. I know that Power BI has the majority of connectors. I hope my comment is helpful. Regards
Ronald Chavez - PeerSpot reviewer
Cloud Services
Apr 29, 2023
This market comparison chart....https://www.gartner.com/doc/re...;ct=230130&st=sb
Related Articles
Anna Odrynska - PeerSpot reviewer
Chief Strategy Officer at Alpha Serve
Oct 11, 2022
Business owners cannot rely on their own market assessments and strategic assumptions to make informed tactical decisions. Rapid technology development and tough competition mean that thorough data analysis is vital for success. In this article, we explain how business analysts, IT teams, and company managers can benefit from Microsoft Power BI integration with the help of BI connectors. Why i...
Product Comparisons
Related Articles
Anna Odrynska - PeerSpot reviewer
Chief Strategy Officer at Alpha Serve
Oct 11, 2022
Power BI Integration: Why Should You Integrate Power BI and Your Software?
Business owners cannot rely on their own market assessments and strategic assumptions to make inf...