What users are saying about
114 Ratings
421 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.8 out of 100
114 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 6.8 out of 100

Likelihood to Recommend

Oracle Analytics Server

The tool is still very good considering the complexities in data that can be modified within the tool using SQL queries. It can be used with advanced coding to integrate data from non-coherent sources. The only place where it is slightly less appropriate is where there is not a crisp UI. The UI and mobile experience could be more intuitive.
Anonymous | TrustRadius Reviewer

Pentaho

The tool is fast, visually attractive and intuitive to use, but we also have an implementation of Qlik Sense and Pentaho pales in comparison to the overall capabilities. I recommend the tool, but everyone’s solution need is unique, so it may not be the right fit. Larger tools like Qlik are more versatile and easier to recommend. More expensive, yes, but you usually get what you pay for.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

Oracle Analytics Server
8.7
Pentaho
7.0
Pixel Perfect reports
Oracle Analytics Server
7.6
Pentaho
6.4
Customizable dashboards
Oracle Analytics Server
9.3
Pentaho
8.4
Report Formatting Templates
Oracle Analytics Server
9.1
Pentaho
6.1

Ad-hoc Reporting

Oracle Analytics Server
8.6
Pentaho
7.2
Drill-down analysis
Oracle Analytics Server
9.3
Pentaho
7.7
Formatting capabilities
Oracle Analytics Server
8.5
Pentaho
6.7
Integration with R or other statistical packages
Oracle Analytics Server
8.2
Pentaho
7.0
Report sharing and collaboration
Oracle Analytics Server
8.5
Pentaho
7.6

Report Output and Scheduling

Oracle Analytics Server
8.7
Pentaho
6.9
Publish to Web
Oracle Analytics Server
8.1
Pentaho
7.3
Publish to PDF
Oracle Analytics Server
9.0
Pentaho
8.6
Report Versioning
Oracle Analytics Server
8.8
Pentaho
7.0
Report Delivery Scheduling
Oracle Analytics Server
9.5
Pentaho
5.8
Delivery to Remote Servers
Oracle Analytics Server
8.1
Pentaho
5.7

Data Discovery and Visualization

Oracle Analytics Server
8.6
Pentaho
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
Oracle Analytics Server
8.8
Pentaho
8.9
Location Analytics / Geographic Visualization
Oracle Analytics Server
8.8
Pentaho
7.5
Predictive Analytics
Oracle Analytics Server
8.4
Pentaho
7.9

Access Control and Security

Oracle Analytics Server
8.9
Pentaho
7.4
Multi-User Support (named login)
Oracle Analytics Server
8.9
Pentaho
8.0
Role-Based Security Model
Oracle Analytics Server
8.8
Pentaho
8.0
Multiple Access Permission Levels (Create, Read, Delete)
Oracle Analytics Server
8.8
Pentaho
7.0
Single Sign-On (SSO)
Oracle Analytics Server
9.0
Pentaho
6.5

Mobile Capabilities

Oracle Analytics Server
8.2
Pentaho
7.8
Responsive Design for Web Access
Oracle Analytics Server
8.9
Pentaho
8.4
Dedicated iOS Application
Oracle Analytics Server
7.8
Pentaho
7.0
Dedicated Android Application
Oracle Analytics Server
7.9
Pentaho
7.9
Dashboard / Report / Visualization Interactivity on Mobile
Oracle Analytics Server
8.3
Pentaho
7.9

Application Program Interfaces (APIs) / Embedding

Oracle Analytics Server
8.0
Pentaho
7.1
REST API
Oracle Analytics Server
8.1
Pentaho
6.7
Javascript API
Oracle Analytics Server
8.3
Pentaho
6.5
iFrames
Oracle Analytics Server
7.7
Pentaho
6.7
Java API
Oracle Analytics Server
8.0
Pentaho
7.9
Themeable User Interface (UI)
Oracle Analytics Server
8.1
Pentaho
5.7
Customizable Platform (Open Source)
Oracle Analytics Server
8.1
Pentaho
9.2

Pros

Oracle Analytics Server

  • Ease of development and quick turnouts as the build is easier compared to some other BI tools for both reporting developers as well as the power users. The RPD development is comparatively easier to build for star schemas and also the subject areas are easier to use by the power users.
  • Easy integration of Mobile BI interface and sharing features in the same layer.
  • Easy integration of other functionality like MapViewer. Multi database type integration is enabled which is not really a distinctive feature in market, but has been improved a lot in OBIEE now.
Vineet Rai | TrustRadius Reviewer

Pentaho

  • Being able to use the OLAP Analyzer tool saved our organization a lot of time in not needing to develop an OLAP tool on our own.
  • The ability to customize the tool and integrate all the internationalization we required was pretty straightforward.
Anonymous | TrustRadius Reviewer

Cons

Oracle Analytics Server

  • Some issues that require the assistance of support at Oracle can be time-consuming and difficult to solve.
  • Upgrade from 10g to 11g has made the OBI Foundation Suite very performance intensive. Requires much better hardware support now.
  • Initial setup is not as straightforward as that of previous versions.
Anonymous | TrustRadius Reviewer

Pentaho

  • At first, one needs to learn the basic concept of this software before going for the implementation. Once you are an expert on this then you will rock it.
  • Some of the basic features need to be enhanced such as sharing and collaboration capabilities
  • Needs to support automatically generated analytic visualizations or models
Ilham AB | TrustRadius Reviewer

Likelihood to Renew

Oracle Analytics Server

Oracle Analytics Server 8.3
Based on 7 answers
Scalability and rich integration capabilities. In the future, if we go with Hyperion for the Financial Consolidation and planning purposes -BI integration with Hyperion is going to be much simpler as it has native interface connectivity and even integration capabilities with well known CRM products (Siebel) and ERP Products (Oracle EBS, Peoplesoft, SAP) is going to be easy and straight forward.
Satyendra Yenugula | TrustRadius Reviewer

Pentaho

Pentaho 8.8
Based on 11 answers
I will use Pentaho until I find a better tool with a better, easier to use report designer client. For now, Pentaho has been the most powerful reporting tool for our clients because of its ability to connect to Odoo, integrate in Odoo (reports are accessible in Odoo) and the flexibility in report design and parameter integration
Adam O'Connor | TrustRadius Reviewer

Usability

Oracle Analytics Server

Oracle Analytics Server 8.0
Based on 1 answer
For me or a staff memeber that uses it frequently, its usability is sufficient. However newbies could have a few issues but find their workflow
Daniel J. Lewis | TrustRadius Reviewer

Pentaho

Pentaho 5.0
Based on 1 answer
I would have liked some hands on help in trying to match what Customers were already used to. Plus having a team of Java/BI folks was difficult to assemble since what required to be done in an object oriented fashion could have easily been done via a SQL construct. This hash of technologies was difficult to manage.
Deepak Paramanand | TrustRadius Reviewer

Support Rating

Oracle Analytics Server

Oracle Analytics Server 9.0
Based on 4 answers
It's fast, efficient and easy to work with. Scheduling could help when planning out a day however overall it's a big plus when rolling out and supporting Oracle.
Daniel J. Lewis | TrustRadius Reviewer

Pentaho

Pentaho 9.9
Based on 4 answers
We are an Enterprise customer. They handle problems INSTANTLY when they are critical, including initiation an immediate WebEx screen share call when needed. Smaller/less-critical problems are handled within 1-2 days -- and NEVER fall off their radar, no matter how small.As needed, we can also leverage "professional services" from them -- much of which is included in our Enterprise contract. Finally, when a problem I have discovered turns out to be a bug..they create a JIRA for the fix, and make me a watcher. I love seeing notes come in showing me status updates of bugs filed because of something I found. They really are TOP-NOTCH.
Sandro Frattura | TrustRadius Reviewer

In-Person Training

Oracle Analytics Server

Oracle Analytics Server 9.0
Based on 1 answer
Oracle University offers very in-depth training.
Tom Jaskula | TrustRadius Reviewer

Pentaho

No score
No answers yet
No answers on this topic

Online Training

Oracle Analytics Server

No score
No answers yet
No answers on this topic

Pentaho

Pentaho 9.5
Based on 2 answers
Course Taken: DI1000 Pentaho Data Integration FundamentalsSetup A week before your class started, the instructor will start sending out class material and lab setup instructions. This is helpful so that you understand how the environment is laid out and can start reviewing the content. Ultimately it saved about a 1/2 day trying to setup with 10 other people online which was great! The CourseThe 3-day course was laid out like many other technical classes with 15-30 minutes instruction and 15-60 minutes of lab exercises. The instructor was very knowledgeable with the functionality from version to version and answered questions as we went along. I was amazed at some of the functionality that was available that I was not using at the time and quickly implemented changes to many existing transformations and jobs. The novice users seemed to catch on quickly and more experienced users explained how some of the functionality was used in their home environments. Towards the end there was enough time so that we were able to ask very directed questions about our own environments. Overall, I really found the class to be informative and deliver enough information to be dangerous. My skills improved and I was able to design better and efficient transformations for the HIE. Course Description: https://training.pentaho.com/instructor-led-training/pentaho-data-integration-fundamentals-di1000
Stephanie Dozier | TrustRadius Reviewer

Implementation Rating

Oracle Analytics Server

Oracle Analytics Server 8.0
Based on 4 answers
A properly implemented Endeca solution performs extremely well on the largest of datasets and it positions your organization to immediately achieve your ROI.
Tom Jaskula | TrustRadius Reviewer

Pentaho

Pentaho 5.0
Based on 2 answers
Get the right people in before starting implementation. Start small and build as you go approach is time consuming and involves lot of rework.Evangalize within the organization the capabilities and limitations equally so that correct delivery expectations are set.Set expectations with the Customer that the tool cannot replace proprietary software in terms of stability/usability and that timelines could change given the new ness of the product.
Deepak Paramanand | TrustRadius Reviewer

Alternatives Considered

Oracle Analytics Server

At the time we made the decision, we also evaluated other tools such as QlikView and SAP Power BI. But since our main solutions are Oracle (ERP, planning, consolidation), it was natural to adopt OBI. And it was also less expensive than the others.
Federico Shortrede | TrustRadius Reviewer

Pentaho

I was not with the company when they selected Pentaho over any other tool. As per my experience, I would recommend Pentaho. One of the reasons are that it is open source. If you know JAVA, you can create your own plugins. I have found its customer support pretty good and quick. And the most important thing is the cost. If you are not using the DI server, you can just use the community edition and it should fulfil your purpose too.
Nikhil Karkare | TrustRadius Reviewer

Return on Investment

Oracle Analytics Server

  • We've used OBIEE (or it's previous named product) for over 13 years and it's still the most used tool for BI by the business.
  • We moved our largest business system off of Business Object into OBI so we could gain improved performance, reliability, and easier management of metadata.
Mary BrowningSmith | TrustRadius Reviewer

Pentaho

  • It's cheap. The version we have is free, so it has an immediate positive impact on ROI in that regard. However, a lot of our developers don't like it, which eats away our ability to be effective and productive.
  • It gets the job done. It may not be the most elegant tool, but for our purposes it works. There are probably better tools out there, and Pentaho has limited capabilities, but at the end of the day it works well enough.
Anonymous | TrustRadius Reviewer

Pricing Details

Oracle Analytics Server

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Pentaho

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Oracle Analytics Server
8.6
Pentaho
7.7

Likelihood to Renew

Oracle Analytics Server
8.3
Pentaho
8.8

Usability

Oracle Analytics Server
8.0
Pentaho
5.0

Support Rating

Oracle Analytics Server
9.0
Pentaho
9.9

In-Person Training

Oracle Analytics Server
9.0
Pentaho

Online Training

Oracle Analytics Server
Pentaho
9.5

Implementation Rating

Oracle Analytics Server
8.0
Pentaho
5.0

Add comparison