What users are saying about

Pentaho

100 Ratings

OpenText Analytics

18 Ratings
Score 6.7 out of 101

Pentaho

100 Ratings
Score 7.5 out of 101

Add comparison

Likelihood to Recommend

OpenText Analytics

What is the licensing structure? How long does it take to get licenses? Can an OEM reseller of Actuate get one license for the entire development organization?
Amy Broome profile photo

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.
No photo available

Feature Rating Comparison

Ad-hoc Reporting

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

BI Standard Reporting

OpenText Analytics
Pentaho
6.7
Pixel Perfect reports
OpenText Analytics
Pentaho
6.5
Customizable dashboards
OpenText Analytics
Pentaho
6.9
Report Formatting Templates
OpenText Analytics
Pentaho
6.8

Report Output and Scheduling

OpenText Analytics
Pentaho
6.6
Publish to Web
OpenText Analytics
Pentaho
6.2
Publish to PDF
OpenText Analytics
Pentaho
7.4
Report Versioning
OpenText Analytics
Pentaho
6.5
Report Delivery Scheduling
OpenText Analytics
Pentaho
6.9
Delivery to Remote Servers
OpenText Analytics
Pentaho
6.1

Data Discovery and Visualization

OpenText Analytics
Pentaho
6.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
OpenText Analytics
Pentaho
6.1
Location Analytics / Geographic Visualization
OpenText Analytics
Pentaho
6.4
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.5
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.2

Mobile Capabilities

OpenText Analytics
Pentaho
6.1
Responsive Design for Web Access
OpenText Analytics
Pentaho
5.4
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
5.9

Application Program Interfaces (APIs) / Embedding

OpenText Analytics
Pentaho
6.0
REST API
OpenText Analytics
Pentaho
6.7
Javascript API
OpenText Analytics
Pentaho
6.3
iFrames
OpenText Analytics
Pentaho
5.0
Java API
OpenText Analytics
Pentaho
5.9
Themeable User Interface (UI)
OpenText Analytics
Pentaho
5.6
Customizable Platform (Open Source)
OpenText Analytics
Pentaho
6.4

Pros

  • The performance of Actuate IServer is tremendous. It can handle a large volume of reports with many concurrent users.
  • We can do anything in Actuate. We can write our own function, procedures, methods in Actuate. Basically we can create our own framework in Actuate. No other reporting tool is proving this functionality.
  • It supports the OLTP system very well. The data can be flowed easily from one report to another report, by using array.
  • Control level formatting is available.
No photo available
  • First thing what I have experienced about Pentaho is that it is user friendly. The best thing about Pentaho is Pentaho Data Integration. I have never used more user friendlier ETL tool like PDI. All the jobs and transformation steps are easy to understand. And I like the sample transformations and jobs that are provided with the package. It is so user friendly that, even if you don't know SQL, it will generate it for you. If you don't want to write scripts, that's fine, you can do it in PDI.
  • I have found that Pentaho can be integrated with any technology or framework. I have easily and successfully integrated it with HDFS, EMR, S3, CouchDB, many different RDBMSs. I would consider it as a strength of Pentaho. Also if you are stuck or you find any error, the type of logging will have an answer for you. I found the logging mechanism very effective.
  • I have mostly used Pentaho Analyzer and Schema Workbench at the BI side. It is user friendly too and we have a very few users who come to the developers to help them understanding the UI of PUC.
Nikhil Karkare profile photo

Cons

  • Support for more databases, such as other BI tools.
  • There can be more graph types.
No photo available
  • Lack of support. Unlike many Microsoft products, there is not a great wealth of support out there for Pentaho on the web. It is much harder to track down solutions.
  • Non-intuitive. There is a learning curve, and there are subtle nuances to Pentaho that even experienced ETL developers will take a while to get used to.
  • Less reputable. Despite all of Pentaho's benefits, it just hasn't gotten to that critical mass in the marketplace. Thus it does not garner as much respect as Microsoft or Oracle, which in turn makes it harder to find online support. It's a vicious cycle.
No photo available

Likelihood to Renew

OpenText Analytics3.9
Based on 9 answers
Difficulty with some extensibility that should be fairly easy, lack of shading in the reports (even simple phong shading), lack of out-of-the box capabilities that seem like no brainers and instability with the design tools all drop the product a few marks, but the support community and the overall product experience is well above average. It's at least worth a try and its extensibility makes it a good contender
Bri Gipson profile photo
Pentaho8.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 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
Typically system analysts, business analysts and departmental managers were our target audience. 10-15 users was the most we could reach before we decided to go with another suite of Products. But who ever used it did appreciate the end to end flow of data that they could see as opposed to the data obfuscation they noticed before.
Deepak Paramanand profile photo

Alternatives Considered

Actuate has a HUGE number of features that can tie nicely into almost any ERP but it takes some time to learn and the development community was relatively small compared to the Crystal Reports alternative. Crystal was far easier to learn and had a massive support base. Probably because it is now owned by SAP.
Todd Bellamy profile photo
We evaluated Panorama, Cognos, MicroSrategy, Jasper Reports, Talend and homegrown solutions. Though each were awesome in their own right, none of them provided a end to end integration like we wanted. Pentaho did the job for us and more. Knowing that Pentaho was built by a team who were industry veterans made us feel comfortable that the basics were always a given and that we could always reach out to them for more. Plus Pentaho's responsiveness in providing a hands on expert to train us was a huge plus.
Deepak Paramanand profile photo

Collaboration and Sharing

OpenText Analytics6.1
Based on 7 answers
Having more that one developer working on Actuate reports became quite a problem because once a report was compiled it was published to the server. The published file then could not be decompiled and the design files had to be stored in a particular shared location on the server. Also, I experienced issues leaving code notes in the SQL statements of the reports when I tried to compile them
Todd Bellamy profile photo
Pentaho7.3
Based on 14 answers
The access control capabilities are generally sufficient, but not stellar. Most of the data sharing and access control is managed completely through pentaho's BI server, and there doesn't seem to be super strict security around the configuration and setup of permissions, who can view what reports, etc. The dashboarding capability of "putting a bunch of reports together" is extremely clunky, it's something we steer clear of trying to implement where possible.
Ivan Miller profile photo

Data Integration

OpenText Analytics7.7
Based on 7 answers
This was a feature of Actuate I almost forgot. You could connect to number of different data sources across the organization from Oracle to MySQL and just about everything in between. Also if you have multiple environments of the same system (DEV,QA,PROD) you can change the connection string each time you compile the same report to promote changes. This was easier then changing the connections in alternative software like Crystal Reports
Todd Bellamy profile photo
Pentaho7.3
Based on 14 answers
This is one of the areas where I think pentaho has done a great job--and with every iteration of the product they seem to include more and more data sources to connect to. Given the data we've been working with, I don't think we've come across a situation yet where we haven't had a relatively simple connector to use.
Ivan Miller 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