What users are saying about

1010data

5 Ratings

Pentaho

100 Ratings

1010data

5 Ratings
Score 4.2 out of 101

Pentaho

100 Ratings
Score 7.5 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.
Marc Gilbert profile photo

Pentaho

It is well suited for developers who may not be adept at strict coding, but have experience with GUI development. It is also better for rather simpler ETL, as the GUI interface has natural restrictions that make complex ETL problems challenging to solve. It may also be well suited for companies on a budget, as the free version still has enough features to be reasonably useful.
No photo available

Feature Rating Comparison

BI Standard Reporting

1010data
Pentaho
6.7
Pixel Perfect reports
1010data
Pentaho
6.5
Customizable dashboards
1010data
Pentaho
6.9
Report Formatting Templates
1010data
Pentaho
6.8

Ad-hoc Reporting

1010data
Pentaho
6.2
Drill-down analysis
1010data
Pentaho
7.1
Formatting capabilities
1010data
Pentaho
6.6
Integration with R or other statistical packages
1010data
Pentaho
6.2
Report sharing and collaboration
1010data
Pentaho
4.9

Report Output and Scheduling

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

Data Discovery and Visualization

1010data
Pentaho
6.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
1010data
Pentaho
6.1
Location Analytics / Geographic Visualization
1010data
Pentaho
6.4
Predictive Analytics
1010data
Pentaho
5.9

Access Control and Security

1010data
Pentaho
7.4
Multi-User Support (named login)
1010data
Pentaho
7.5
Role-Based Security Model
1010data
Pentaho
7.3
Multiple Access Permission Levels (Create, Read, Delete)
1010data
Pentaho
7.4
Single Sign-On (SSO)
1010data
Pentaho
7.2

Mobile Capabilities

1010data
Pentaho
6.1
Responsive Design for Web Access
1010data
Pentaho
5.4
Dedicated iOS Application
1010data
Pentaho
6.5
Dedicated Android Application
1010data
Pentaho
6.5
Dashboard / Report / Visualization Interactivity on Mobile
1010data
Pentaho
5.9

Application Program Interfaces (APIs) / Embedding

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

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
Marc Gilbert profile photo
  • The Data Integration tool is fantastic. A novice user can get up to speed quickly with it and the GUI is intuitive
  • Support. As an enterprise customer, I am always thrilled with the fast turnaround on support tickets that I open.
  • Job Scheduling. The Job scheduler is easy to use and very reliable
  • Data Analyzer Tool in "User Console". The drag and drop UI makes it easy for me end users to see the data in whatever way suits them. They can even GEO-MAP the data instantly!!
Sandro Frattura profile photo

Cons

  • The ten.do interface could use more detailed documentation
Marc Gilbert profile photo
  • 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

No score
No answers yet
No answers on this topic
Pentaho8.8
Based on 11 answers
Pentaho continues to fulfill our needs as previously described. We are regularly finding new uses for it as we expand our business and our technology stack.
Kenneth Panacy profile photo

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Henry PAN profile photo
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

No score
No answers yet
No answers on this topic
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

No answers on this topic
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

While we have used SQL, 1010data is really the only industry standard product available for our use.
Marc Gilbert profile photo
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

No score
No answers yet
No answers on this topic
Pentaho7.3
Based on 14 answers
Pentaho has a community online that shares the jobs and transformations. Importing/exporting the jobs is a piece of cake. Within our internal cloud, I am able to share, open, review the jobs and transformations that he has created and we can work together to finalize them. However, the access control comes with the connections themselves; if you don't have access, you don't have access and cannot do much with the tools to help shape and transform the data.
Gordon Yeh profile photo

Data Integration

No score
No answers yet
No answers on this topic
Pentaho7.3
Based on 14 answers
With a built in AR Data source connector, setting this up was very easy. Currently we are using Pentaho to connect it to our multiple-discovery platform, HR user platform and exporting data from our AR system to various consumers of the data. Once I get started, most jobs take 1-2 hours of "coding". Very easy, and I am quite excited to hear about new projects that I can utilize Pentaho to help us deliver what the customer wants.
Gordon Yeh profile photo

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
Marc Gilbert profile photo
  • 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

1010data

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