2014-06-12T11:29:00Z

What are the key advantages of OBIEE compared to Microsoft BI?

Can you please give me some key points on the advantages of OBIEE compared to MS BI tools?

Thank you! --Joyce

it_user125577 - PeerSpot reviewer
User at a tech company with 51-200 employees
  • 9
  • 95
8
PeerSpot user
8 Answers
it_user108354 - PeerSpot reviewer
Manager of Data Analytics at Tata Consultancy Services
Real User
2014-06-17T09:21:17Z
Jun 17, 2014

I used both products rather briefly. In my experience, OBIEE is better product than MSBI. While both products have limitations in ETL, reporting performance is better in OBIEE. Further, Oracle has proven credentials in handling large volumes of data, whereas MS SQL Server Suite struggles in processing large volume (and complex) of data. Oracle offers many features at database level and reporting level to enhance performance as well as usability experience. MSBI lags providing similar degree of capability to both the developer or the user.

Product comparison that may be of interest to you
Vendor
2014-06-12T18:00:40Z
Jun 12, 2014

I would concur with Reviewer78465 above, and suggest you strongly consider Information Builders - a vastly superior platform and much easier to work with as a company.

it_user125577 - PeerSpot reviewer
User at a tech company with 51-200 employees
Vendor
2014-06-12T13:44:24Z
Jun 12, 2014

Thank you all.

it_user74910 - PeerSpot reviewer
User at a tech company with 51-200 employees
Vendor
2014-06-12T13:29:54Z
Jun 12, 2014

I'd suggest you look at these links:

http://www.itcentralstation.com/products/comparisons/obiee_vs_microsoft-bi

http://www.itcentralstation.com/products/obiee

Thanks,
Biswojit Sen

it_user116742 - PeerSpot reviewer
Oracle Web Administrator at a tech services company with 1,001-5,000 employees
Consultant
2014-06-12T12:46:45Z
Jun 12, 2014

OBIEE is very powerful when it comes to huge data volumes

it_user79650 - PeerSpot reviewer
Architect at a tech vendor with 501-1,000 employees
Vendor
2014-06-12T12:12:22Z
Jun 12, 2014

I think OBIEE isvery powerful when it comes to huge data volumes. You can set up a so called aggregate content, which means that if you have a for example a materialized view, you can configure OBIEE to use your fact table for low level data, and your MV for aggregated data. Your aggregate content can even be in a separate database.
Also a huge advantage is that you are not restricted to the MS world. If for example you use a different LDAP server than MS AD, you can very easily connect it to OBIEE. And this is not a pathological example, that can be a real world and license sensitive question.
You can also run OBIEE over Linux (Red Hat or Oracle Linux).
You can scale OBIEE both vertically and horizontally for availability and performance improvements.
These are my first thoughts, there are probably other advantages as well.
Kind regards:

Gyuri

Find out what your peers are saying about Microsoft BI vs. Oracle OBIEE and other solutions. Updated: September 2023.
735,432 professionals have used our research since 2012.
it_user78465 - PeerSpot reviewer
CEO at a consultancy with 501-1,000 employees
Consultant
2014-06-12T12:08:27Z
Jun 12, 2014

I don't have any experience with these two BI solutions, but just came back from a Information Builders Users Summit, in Orlando, FL yesterday, and they are doing some tremendous things in the BI space!

Vendor
2014-06-12T11:52:56Z
Jun 12, 2014

I haven't used either, but I can Imagine that if you already have an Oracle 12g database established maybe OBIEE will be best bet for integration.

By the way, if you need to BI something from (say) SAP (SAP-PS or SAP-PM) then you won't gain much of an advantage from using OBIEE compared to MS BI.

Of course if there is no other restrictions (say financials)…

Related Questions
PS
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
RV
ICT Business Engagement at Ipswich City Council
Apr 23, 2023
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.
2 out of 3 answers
PM
Financial Systems Advisor - US Controller Group at McDonald's
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.
DM
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: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
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...
EB
Director of Community at PeerSpot (formerly IT Central Station)
May 2, 2022
Hi peers, We're happy to share our new bi-weekly Community Spotlight with you. Here you'll find recent contributions by PeerSpot community members: questions, articles and trending discussions. Trending See what your peers are discussing at the moment! What to choose: an endpoint antivirus, an EDR solution, or both? What is your recommended IT Service Management (ITSM) tool in 2022? W...
EB
Director of Community at PeerSpot (formerly IT Central Station)
Apr 4, 2022
Hi peers, This is our new Community Spotlight that includes recent contributions (questions, articles and discussions) by the PeerSpot community members. Trending Is RPA beneficial for a healthcare organization? With the increasing risk of cyber attacks in the west, due to the war in Ukraine, how safe is your data in the cloud? Articles 8 Business Automation Ideas to Save Time and...
EB
Director of Community at PeerSpot (formerly IT Central Station)
Mar 18, 2022
Hi community members, Here we go with a new Community Spotlight. We publish it to help YOU catch up on recent contributions by community members. Trending What open-source HCI solution do you recommend? How much time does SSO save? What are the main technical differences between Microsoft Power Automate and Blue Prism? Articles Top HCI in 2022 What is Web Design? The Ultima...
EB
Director of Community at PeerSpot (formerly IT Central Station)
Mar 4, 2022
Hi community members, Here is our new Community Spotlight for YOU. We publish it to help you catch up on recent contributions by community members. Do you find it useful? Please comment below! Trending Top HCI in 2022 What are the main differences between XDR and SIEM? Articles Top 5 Ethernet Switches in 2022 SASE: what is it and what are the main benefits? Questions Che...
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...
EB
Director of Community at PeerSpot (formerly IT Central Station)
May 2, 2022
Community Spotlight #13: Top Products and Solutions
Hi peers, We're happy to share our new bi-weekly Community Spotlight with you. Here you'll find ...
Download Free Report
Download our FREE report comparing Microsoft BI and Oracle OBIEE based on reviews, features, and more! Updated: September 2023.
DOWNLOAD NOW
735,432 professionals have used our research since 2012.