What users are saying about
113 Ratings
4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.2 out of 100
113 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

Db2 Warehouse on Cloud

IBM dashDB's ability to store and provide fast access to data both on-premise and in the cloud makes it best-of-breed when it comes to implementation flexibility. All the while you can have one data solution that pulls data together from Hyperion Planning (Oracle) and Microsoft Dynamics (MM) into the same system as part of an EDW project.
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

Db2 Warehouse on Cloud
Pentaho
6.9
Pixel Perfect reports
Db2 Warehouse on Cloud
Pentaho
6.4
Customizable dashboards
Db2 Warehouse on Cloud
Pentaho
8.3
Report Formatting Templates
Db2 Warehouse on Cloud
Pentaho
6.1

Ad-hoc Reporting

Db2 Warehouse on Cloud
Pentaho
7.2
Drill-down analysis
Db2 Warehouse on Cloud
Pentaho
7.6
Formatting capabilities
Db2 Warehouse on Cloud
Pentaho
6.7
Integration with R or other statistical packages
Db2 Warehouse on Cloud
Pentaho
6.9
Report sharing and collaboration
Db2 Warehouse on Cloud
Pentaho
7.6

Report Output and Scheduling

Db2 Warehouse on Cloud
Pentaho
6.9
Publish to Web
Db2 Warehouse on Cloud
Pentaho
7.3
Publish to PDF
Db2 Warehouse on Cloud
Pentaho
8.6
Report Versioning
Db2 Warehouse on Cloud
Pentaho
7.0
Report Delivery Scheduling
Db2 Warehouse on Cloud
Pentaho
5.8
Delivery to Remote Servers
Db2 Warehouse on Cloud
Pentaho
5.7

Data Discovery and Visualization

Db2 Warehouse on Cloud
Pentaho
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
Db2 Warehouse on Cloud
Pentaho
8.9
Location Analytics / Geographic Visualization
Db2 Warehouse on Cloud
Pentaho
7.4
Predictive Analytics
Db2 Warehouse on Cloud
Pentaho
7.9

Access Control and Security

Db2 Warehouse on Cloud
Pentaho
7.4
Multi-User Support (named login)
Db2 Warehouse on Cloud
Pentaho
8.0
Role-Based Security Model
Db2 Warehouse on Cloud
Pentaho
8.0
Multiple Access Permission Levels (Create, Read, Delete)
Db2 Warehouse on Cloud
Pentaho
7.0
Single Sign-On (SSO)
Db2 Warehouse on Cloud
Pentaho
6.5

Mobile Capabilities

Db2 Warehouse on Cloud
Pentaho
7.8
Responsive Design for Web Access
Db2 Warehouse on Cloud
Pentaho
8.4
Dedicated iOS Application
Db2 Warehouse on Cloud
Pentaho
6.9
Dedicated Android Application
Db2 Warehouse on Cloud
Pentaho
7.8
Dashboard / Report / Visualization Interactivity on Mobile
Db2 Warehouse on Cloud
Pentaho
7.9

Application Program Interfaces (APIs) / Embedding

Db2 Warehouse on Cloud
Pentaho
7.1
REST API
Db2 Warehouse on Cloud
Pentaho
6.7
Javascript API
Db2 Warehouse on Cloud
Pentaho
6.5
iFrames
Db2 Warehouse on Cloud
Pentaho
6.6
Java API
Db2 Warehouse on Cloud
Pentaho
7.8
Themeable User Interface (UI)
Db2 Warehouse on Cloud
Pentaho
5.7
Customizable Platform (Open Source)
Db2 Warehouse on Cloud
Pentaho
9.2

Pros

Db2 Warehouse on Cloud

  • You can size dashDB to your current needs and expand its capability later on as the needed.
  • I like the way dashDB allow for connecting to the cloud that my network engineer to set things up quickly.
  • IBM dashDB's ability to store and provide fast access to data both on-premise and in the cloud makes it a real winner for me.
Anonymous | 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

Db2 Warehouse on Cloud

  • IBM dashDB could be clearer about the technology used to deliver the particular tier of the service you buy.
  • IBM dashDB can be cost prohibitive for folks needing to push a lot of data from on-premise into the cloud on a regular basis.
  • IBM dashDB is really like three data technologies in one and the sales teams at IBM sometimes can't explain why the MPP tier is better for certain uses over the db2 BLU based tier.
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

Db2 Warehouse on Cloud

No score
No answers yet
No answers on this topic

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

Db2 Warehouse on Cloud

No score
No answers yet
No answers on this topic

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

Db2 Warehouse on Cloud

No score
No answers yet
No answers on this topic

Pentaho

Pentaho 9.9
Based on 2 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

Online Training

Db2 Warehouse on Cloud

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

Db2 Warehouse on Cloud

No score
No answers yet
No answers on this topic

Pentaho

Pentaho 5.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 | TrustRadius Reviewer

Alternatives Considered

Db2 Warehouse on Cloud

IBM dashDB stacks up well against both on-premise (SQL Server and DB2), but it was a tough choice to go with over AzureDB. Ultimately, the deep discount by IBM led us to go with dashDB with the understanding that we could back out of the technology at a later date.
Anonymous | 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

Db2 Warehouse on Cloud

No answers on this topic

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

Screenshots

Pricing Details

Db2 Warehouse on Cloud

General

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

Db2 Warehouse on Cloud Editions & Modules

Edition
dashDB Entry50 / month1
dashDB EnterpriseVaries
dashDB Enterprise MPPVaries
dashDB Entry (Free)$03
  1. Per instance
  2. Up to 50 GB
Additional Pricing Details

Pentaho

General

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

Pentaho Editions & Modules

Additional Pricing Details

Rating Summary

Likelihood to Recommend

Db2 Warehouse on Cloud
7.0
Pentaho
7.7

Likelihood to Renew

Db2 Warehouse on Cloud
Pentaho
8.8

Usability

Db2 Warehouse on Cloud
Pentaho
5.0

Support Rating

Db2 Warehouse on Cloud
Pentaho
9.9

Online Training

Db2 Warehouse on Cloud
Pentaho
9.5

Implementation Rating

Db2 Warehouse on Cloud
Pentaho
5.0

Add comparison