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

Add comparison

Likelihood to Recommend

OpenText Analytics

If you do not have a large budget and are a large organization, I would steer clear of Actuate. If you are looking to do very complex washboarding, I would not use them. Your developers have to be very skilled to work with this. Plan to bring in consultants if necessary to help your process. Adhoc reporting is weak. If your pricing is user based and you expand, this could be very expensive.
Christopher Noyes profile photo

Pentaho

As far as generating and maintaining a data warehouse, Pentaho does an excellent job and I would highly recommend it. For analysis and gaining insight into your data, Pentaho is excellent. For visualization, dashboarding, or executive grade reporting it may not be as beautiful or flashy as your clients require
Jordan Squire profile photo

Feature Rating Comparison

Ad-hoc Reporting

OpenText Analytics
4.5
Pentaho
6.3
Drill-down analysis
OpenText Analytics
6.0
Pentaho
7.1
Formatting capabilities
OpenText Analytics
3.0
Pentaho
6.7
Integration with R or other statistical packages
OpenText Analytics
Pentaho
6.3
Report sharing and collaboration
OpenText Analytics
Pentaho
5.0

BI Standard Reporting

OpenText Analytics
Pentaho
7.0
Pixel Perfect reports
OpenText Analytics
Pentaho
6.8
Customizable dashboards
OpenText Analytics
Pentaho
7.2
Report Formatting Templates
OpenText Analytics
Pentaho
7.0

Report Output and Scheduling

OpenText Analytics
Pentaho
6.7
Publish to Web
OpenText Analytics
Pentaho
6.2
Publish to PDF
OpenText Analytics
Pentaho
7.5
Report Versioning
OpenText Analytics
Pentaho
6.6
Report Delivery Scheduling
OpenText Analytics
Pentaho
7.0
Delivery to Remote Servers
OpenText Analytics
Pentaho
6.2

Data Discovery and Visualization

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

Access Control and Security

OpenText Analytics
Pentaho
7.4
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.2
Responsive Design for Web Access
OpenText Analytics
Pentaho
5.6
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.1

Application Program Interfaces (APIs) / Embedding

OpenText Analytics
Pentaho
6.1
REST API
OpenText Analytics
Pentaho
6.8
Javascript API
OpenText Analytics
Pentaho
6.4
iFrames
OpenText Analytics
Pentaho
5.2
Java API
OpenText Analytics
Pentaho
6.0
Themeable User Interface (UI)
OpenText Analytics
Pentaho
5.6
Customizable Platform (Open Source)
OpenText Analytics
Pentaho
6.4

Pros

  • The software can be tied to Actuate Basic which is much like MS Visual Basic and can provide an almost custom application feel to some reports.
  • Actuate had field movement tools that allowed a user to line rows up and disperse them across a report based off the width. Comparative tools like Crystal did not provide these.
  • The Actuate Server also gave easy access to review who had been running a report or reports via its web interface.
Todd Bellamy profile photo
  • Pentaho works as advertised -- it provides a truly drag-and-drop customizable interface for your data.
  • The Enterprise Suite has everything you need to start working and showing results right away.
  • Pentaho's customer support has been responsive and timely when we've had issues.
Kenneth Panacy profile photo

Cons

  • Report rendering can take a long time for large reports (250,000+ pages) - we run these in batch over night
  • The deployment of production code from development to test to production enviroments can be complex due to the number of components that must compile
No photo available
  • The Report Designer interface can seem clunky at times when trying to perform additional calculations on previously calculated fields or pass values to subreports.
  • There is inconsistency within the tools in Data Integration -- it is clear the various tools were authored by different engineers at different times. It is not always obvious what goes where.
  • There is inconsistency between all the products within the Pentaho Suite. Each has a different look and feel and none work the same way.
  • The product is not without flaws, but so far none have been insurmountable.
  • Upgrading to the latest version has proven to be EXTREMELY challenging for both us AND Pentaho customer services.
Kenneth Panacy profile photo

Likelihood to Renew

OpenText Analytics3.9
Based on 9 answers
We have invested much into the software and hardware that supports our reporting platform - Actuate is a staple in our environment.
No photo available
Pentaho8.8
Based on 11 answers
Basically, the cost is very affordable, if you have already done everything and the project is working then you don't want to replace it because that means making a whole new project. Also I think its very good and the competitor will not overcome the functionality. So you will find your self spending a lot of time and money to get to the same place.
Itamar Steinberg 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

Breadth of Deployment

The design tool is useful for basic reporting, but many reports require some experience in SQL and JavaScript. Java programming, though not a required skill for basic reports, is needed for better reporting and to access the more advanced features (such as debugging).
Bri Gipson profile photo
This is not a relevant question, it is in the background. But I can say that when we add a new module / department we need to bring the data from more tables and sources.
Itamar Steinberg profile photo

Alternatives Considered

We looked at a few other competitor's products but based on value for features chose Actuate for its total cost of ownership.
No photo available
It has been too long since we did the research (over three years) before choosing Pentaho so I cannot remember exactly which competing products we looked at. In the end, the problem with all the others was that they were too expensive for our small company. Pentaho was reasonably priced and was exactly what we were looking for.Microsoft, Oracle, SAP, SAS all provide similar, but very expensive products.
Kenneth Panacy profile photo

Collaboration and Sharing

OpenText Analytics6.1
Based on 7 answers
Engineers can share and collaborate building tasks - e.g. One develope builds the report design while another builds the query. But I can't pass in a requirements template from a spreadsheet to construct the report. Collaboration is still strongly based on comminication between stakeholders and engineers rather than through automation
Bri Gipson profile photo
Pentaho7.3
Based on 14 answers
Pentaho checked all the boxes with respect to security, formatting of reports/dashboards, distribution etc. In terms of collaborative capabilities, features like annotation, 'users-who-saw-this-also-saw' capabilities were missing. In hindsight we would have liked workflow integration to have been tightly coupled with collaboration so that all users in the same business process would have benefited from each others work and not have to redo
Deepak Paramanand profile photo

Data Integration

OpenText Analytics7.7
Based on 7 answers
We connect to various data sources and enjoy quick connectivity
No photo available
Pentaho7.5
Based on 14 answers
Range of data sources you could connect to. The fact that you could read unstructured data into a Hadoop workflow, enrich and load it to a Relational database, refresh a report and finally burst it to end users was easily doable with Pentaho Data Integration. Had we used other tools we would have to build the integration ourselves which is wasted time and money.
Deepak Paramanand 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
  • Because of the security issue we have had to spin up an additional reporting portal using another vendor. This means we have two reporting tools that we must maintain and support.
  • Since Pentaho is used by a limited audience it gets sidelined as a solution that requires our customers and partners to access their reporting via the web.
Stephanie Dozier profile photo

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