What users are saying about

1010data

5 Ratings

Pentaho

97 Ratings

1010data

5 Ratings
Score 5.2 out of 101

Pentaho

97 Ratings
Score 7.4 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.

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.

Feature Rating Comparison

BI Standard Reporting

1010data
Pentaho
6.4
Pixel Perfect reports
1010data
Pentaho
6.1
Customizable dashboards
1010data
Pentaho
6.6
Report Formatting Templates
1010data
Pentaho
6.5

Ad-hoc Reporting

1010data
Pentaho
6.0
Drill-down analysis
1010data
Pentaho
6.9
Formatting capabilities
1010data
Pentaho
6.4
Integration with R or other statistical packages
1010data
Pentaho
5.9
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.3
Report Versioning
1010data
Pentaho
6.4
Report Delivery Scheduling
1010data
Pentaho
6.8
Delivery to Remote Servers
1010data
Pentaho
6.0

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.2
Predictive Analytics
1010data
Pentaho
6.0

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

1010data
Pentaho
5.8
REST API
1010data
Pentaho
6.4
Javascript API
1010data
Pentaho
6.1
iFrames
1010data
Pentaho
4.8
Java API
1010data
Pentaho
5.7
Themeable User Interface (UI)
1010data
Pentaho
5.6
Customizable Platform (Open Source)
1010data
Pentaho
6.3

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
  • 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

Cons

  • The ten.do interface could use more detailed documentation
  • Would like to have a format copy for different objects, tables, cross-tabs, grids, it would make design much more easier. Of course, we use template and CSS design for these objects, from time to time we design something different and it makes it much harder to do this manually for each similar object.
  • Possibility to use multiple DB in the .xaction.

Likelihood to Renew

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

Usability

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

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.

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

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.

Breadth of Deployment

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

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Talend and Pentaho have a lot of the same functionality, but Talend's interface is not as intuitive. Talend generates code that is then executed while Pentaho is an engine based tool with highly optimized Java code templates that are compiled at runtime.

Collaboration and Sharing

No score
No answers yet
No answers on this topic
Pentaho7.3
Based on 14 answers
I am not familiar with this functionality since I am the only user of Pentaho inside my company. But it is easy to distribute a simple report using "Send mail".

Data Integration

No score
No answers yet
No answers on this topic
Pentaho7.2
Based on 14 answers
Range of data sources include MySQL and Impala, which are two main sources we need. It is very easy to set up also.

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.
  • 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.

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