What users are saying about
103 Ratings
18 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 6.4 out of 101
103 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.4 out of 101

Add comparison

Likelihood to Recommend

OpenText Analytics

If you are a techie and love to face challenges, then Actuate is the choice. You can do anything in Actuate. It has nice security features page level security.
No photo available

Pentaho

Well suited scenarios: When we need to deal with any type of RDBMS, from data input to the data loading, Pentaho is super fast. It has many bulk loaders available too. Dealing with the tables is the specialty of Pentaho.

Less Appropriate scenarios: When you have a star schemas with the bridge tables or snow-flake schemas, you will need a lot of additional work to be done in Pentaho apparently. Also, dealing with the files is not bad, but it should be improved.
** My review is for Pentaho 5.4.0.8 or previous releases.
Nikhil Karkare profile photo

Feature Rating Comparison

Ad-hoc Reporting

OpenText Analytics
4.5
Pentaho
6.4
Drill-down analysis
OpenText Analytics
6.0
Pentaho
7.2
Formatting capabilities
OpenText Analytics
3.0
Pentaho
6.9
Integration with R or other statistical packages
OpenText Analytics
Pentaho
6.4
Report sharing and collaboration
OpenText Analytics
Pentaho
5.1

BI Standard Reporting

OpenText Analytics
Pentaho
7.3
Pixel Perfect reports
OpenText Analytics
Pentaho
7.1
Customizable dashboards
OpenText Analytics
Pentaho
7.5
Report Formatting Templates
OpenText Analytics
Pentaho
7.1

Report Output and Scheduling

OpenText Analytics
Pentaho
6.8
Publish to Web
OpenText Analytics
Pentaho
6.3
Publish to PDF
OpenText Analytics
Pentaho
7.7
Report Versioning
OpenText Analytics
Pentaho
6.7
Report Delivery Scheduling
OpenText Analytics
Pentaho
7.1
Delivery to Remote Servers
OpenText Analytics
Pentaho
6.2

Data Discovery and Visualization

OpenText Analytics
Pentaho
6.3
Pre-built visualization formats (heatmaps, scatter plots etc.)
OpenText Analytics
Pentaho
6.3
Location Analytics / Geographic Visualization
OpenText Analytics
Pentaho
6.7
Predictive Analytics
OpenText Analytics
Pentaho
5.9

Access Control and Security

OpenText Analytics
Pentaho
7.3
Multi-User Support (named login)
OpenText Analytics
Pentaho
7.6
Role-Based Security Model
OpenText Analytics
Pentaho
7.3
Multiple Access Permission Levels (Create, Read, Delete)
OpenText Analytics
Pentaho
7.4
Single Sign-On (SSO)
OpenText Analytics
Pentaho
7.1

Mobile Capabilities

OpenText Analytics
Pentaho
6.3
Responsive Design for Web Access
OpenText Analytics
Pentaho
5.9
Dedicated iOS Application
OpenText Analytics
Pentaho
6.5
Dedicated Android Application
OpenText Analytics
Pentaho
6.5
Dashboard / Report / Visualization Interactivity on Mobile
OpenText Analytics
Pentaho
6.4

Application Program Interfaces (APIs) / Embedding

OpenText Analytics
Pentaho
6.2
REST API
OpenText Analytics
Pentaho
7.0
Javascript API
OpenText Analytics
Pentaho
6.6
iFrames
OpenText Analytics
Pentaho
5.4
Java API
OpenText Analytics
Pentaho
6.1
Themeable User Interface (UI)
OpenText Analytics
Pentaho
5.6
Customizable Platform (Open Source)
OpenText Analytics
Pentaho
6.4

Pros

  • Actuate has permitted us to create stronger visualizations of data and customer data for our clients so they can make better decisions about the course of their businesses.
  • Birt Analytics integrates with Salesforce.com, Microsoft Dynamics, Xcel in a short period of time and permits stronger massaging of data and integration with better "what if"scenarios.
  • The ROI on this product is remarkable.
  • Employees who visualize the data and other components who have been questioning the direction of management change their focus upon what they can do to improve the company. Managers who are "micro-managers of data" actually begin to visualize where some of the sub-strata they have wasted time is impairing company results.
  • Customer support for their products is excellent. If you need support on site they are there when you need them.
Jeffrey Fischer profile photo
  • Connect via JDBC
  • Integrates with Odoo (formerly OpenERP)
  • Grouping, summing seem to work well even though they are not intuitive as far as set up goes.
  • The multiple report output types are great (PDF, CSV, Excel, Word, Text, etc)
  • Connect via the web client of Odoo
  • Easy to build in parameters for filtering in the report
Adam O'Connor profile photo

Cons

  • Anything that I would consider an area for improvement and have asked about from the company is a area where they are already doing development and refinement and when it is available it comes as a simple upgrade.
Jeffrey Fischer profile photo
  • Data Visualization. Provide richer library of data visualization capabilities. Ultimately the dashboards are the end result of all the hard work done at the back office. Yes, Pentaho has a lower TCO compared to other Products but richer data visualization capabilities would make it a winner! Pentaho has overcome this limitation by allowing external charting engines to be integrated with their product suite, but more needs to be done to strengthen core Pentaho Data Visualizaiton capabilities. Alternatively the external charting engine capabilities need to be documented and evangalized.
  • Alternative to Mondrian. In our case we needed to analyse data for a million subscribers over key performance areas like Churns, Activations etc. In these scenarios semi additive measures needed to be calculated and presented in a report across days to years grains of time. In such scenarios the Mondrian based ROLAP capability did not scale up to our expectation. Pentaho needs to address such issues and fast.
  • In the world of R/SAS/SPSS its hard to find use cases where WEKA was used in Production environments to solve a business problem. We would have needed some hand holding to replace our R/SPSS code to WEKA and help us build newer alogorithms on this platform ground up.
Deepak Paramanand profile photo

Likelihood to Renew

OpenText Analytics3.9
Based on 9 answers
We will continue to resell and support Actuate and its products.
Jeffrey Fischer profile photo
Pentaho8.8
Based on 11 answers
We have moved to homegrown ETL and have matured as a company as to what we need from a BI tool. Our focus is now rich and intuitive data visualization with blazing speed. Our customers had already used MicroStrategy/Tableau in the past so that bar was already set very high. Unfortunately Pentaho could not give us a better if not similar experience as the tools our Customers had already used.
Deepak Paramanand profile photo

Usability

No score
No answers yet
No answers on this topic
Pentaho5.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 profile photo

Support

OpenText Analytics9.1
Based on 1 answer
Always there on the front and backend for us and the client.
Jeffrey Fischer profile photo
Pentaho9.9
Based on 2 answers
They were responsive to our questions when we raised issues.They gave us workarounds when required.They were quite knowledgeable when it came to issue analysis and providing fixes.They were forthright in informing us if a bug was not due for release soon.
Deepak Paramanand profile photo

Online Training

No score
No answers yet
No answers on this topic
Pentaho9.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 profile photo

Implementation

No score
No answers yet
No answers on this topic
Pentaho5.0
Based on 1 answer
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 profile photo

Alternatives Considered

It is vastly superior to these in many ways, for complex reporting it is a much more sophisticated solution. Visualizations are very good. Javascript extensibility is very powerful, others don't support this or as well. Pentaho and MS are both OLAP oriented. Pentaho is moving more toward big data, which was not our primary focus. Others are stuck in the Crystal Reports Band metaphor.
Christopher Noyes profile photo
In a past life I have used Business Objects which is a great product but requires an army of people to support. Pentaho can be managed by a smaller team of developers because you don't have to have expertise in Universe design, Report design and ETL. Pentaho's interfaces allow for a quick ramp up of the software and support all three areas pretty easily
Stephanie Dozier profile photo

Return on Investment

  • Actuate can handle 50 to 60 sub reports inside a report very well.
  • Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.
No photo available
  • Good client feedback - caters to specific requirements
  • Low learning curve for new staff
  • Good community backup
No photo available

Pricing Details

OpenText Analytics

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

Pentaho

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