ClicData vs. Pentaho

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
ClicData
Score 8.5 out of 10
N/A
ClicData is a 100% cloud-based business intelligence platform that allows users to connect, process, blend, visualize and share data from a single place. As an automated platform, users are able to rely on the latest version of company data, to ensure users make the right decisions. Hundreds of data connectors ClicData has connectors that allow users to pull data automatically from hundreds of business applications and databases. Data warehousing and ETL…
$79
per month
Pentaho
Score 6.8 out of 10
N/A
Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.N/A
Pricing
ClicDataPentaho
Editions & Modules
Premium
$79
per month
Team
$269
per month
Business
$525
per month
Enterprise
Custom Quote
No answers on this topic
Offerings
Pricing Offerings
ClicDataPentaho
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup Fee$71 data volume, type of data source and level of automationNo setup fee
Additional DetailsAll plans include multiple users licenses but dashboards can be shared with external users via live links, no license needed. Plans and pricing vary based on the data connectors, refreshes, and the level of automation needed. A few hours of Expert Service are including in all plans but more hours can be purchased. A white label option is also available for consultants and agencies.
More Pricing Information
Features
ClicDataPentaho
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
ClicData
10.0
3 Ratings
20% above category average
Pentaho
9.0
20 Ratings
10% above category average
Pixel Perfect reports10.01 Ratings8.618 Ratings
Customizable dashboards10.03 Ratings9.918 Ratings
Report Formatting Templates00 Ratings8.718 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
ClicData
9.0
3 Ratings
11% above category average
Pentaho
8.7
19 Ratings
8% above category average
Drill-down analysis8.03 Ratings7.618 Ratings
Formatting capabilities9.03 Ratings8.319 Ratings
Report sharing and collaboration10.02 Ratings9.717 Ratings
Integration with R or other statistical packages00 Ratings9.312 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
ClicData
8.5
3 Ratings
2% above category average
Pentaho
9.6
20 Ratings
14% above category average
Publish to Web10.02 Ratings9.618 Ratings
Publish to PDF9.02 Ratings9.819 Ratings
Report Versioning7.02 Ratings9.713 Ratings
Report Delivery Scheduling8.01 Ratings9.917 Ratings
Delivery to Remote Servers00 Ratings9.310 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
ClicData
8.5
3 Ratings
6% above category average
Pentaho
8.1
17 Ratings
1% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)10.03 Ratings7.916 Ratings
Location Analytics / Geographic Visualization7.02 Ratings8.216 Ratings
Predictive Analytics00 Ratings8.314 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
ClicData
10.0
2 Ratings
16% above category average
Pentaho
9.1
20 Ratings
6% above category average
Multi-User Support (named login)10.02 Ratings9.320 Ratings
Multiple Access Permission Levels (Create, Read, Delete)10.02 Ratings9.918 Ratings
Role-Based Security Model00 Ratings9.519 Ratings
Single Sign-On (SSO)00 Ratings7.610 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
ClicData
6.0
2 Ratings
28% below category average
Pentaho
8.3
11 Ratings
4% above category average
Responsive Design for Web Access7.02 Ratings9.710 Ratings
Mobile Application1.01 Ratings7.07 Ratings
Dashboard / Report / Visualization Interactivity on Mobile10.02 Ratings8.711 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
ClicData
10.0
1 Ratings
24% above category average
Pentaho
8.6
10 Ratings
9% above category average
iFrames10.01 Ratings7.39 Ratings
Themeable User Interface (UI)10.01 Ratings8.910 Ratings
REST API00 Ratings8.310 Ratings
Javascript API00 Ratings9.09 Ratings
Java API00 Ratings8.79 Ratings
Customizable Platform (Open Source)00 Ratings9.610 Ratings
Best Alternatives
ClicDataPentaho
Small Businesses
SAP Crystal
SAP Crystal
Score 9.0 out of 10
SAP Crystal
SAP Crystal
Score 9.0 out of 10
Medium-sized Companies
Reveal
Reveal
Score 10.0 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
ClicDataPentaho
Likelihood to Recommend
10.0
(3 ratings)
9.1
(31 ratings)
Likelihood to Renew
-
(0 ratings)
8.8
(11 ratings)
Usability
10.0
(1 ratings)
9.3
(6 ratings)
Support Rating
10.0
(1 ratings)
9.3
(7 ratings)
Online Training
-
(0 ratings)
9.5
(2 ratings)
Implementation Rating
-
(0 ratings)
5.0
(1 ratings)
User Testimonials
ClicDataPentaho
Likelihood to Recommend
ClicData
We used ClicData dashboards in a somewhat unorthodox way: we used "Indicators", or icons within tables to represent data, and the results looked great. The ability to integrate 3rd party HTML into dashboards was valuable (although Clic Data correctly warns that response time may suffer). The ability to start small and release dashboards incrementally suited our needs very well. We also valued the responsive account team getting us quickly pointed in the right direction.
Read full review
Hitachi Vantara
Pentaho is very well suited to perform data extraction & data mining from various cloud storage & transform that data using various available data models. However, the software struggles when it comes to visualizing the extracted data in an appealing manner & can be difficult for end-users to get an understanding of data tables created using those models.
Read full review
Pros
ClicData
  • Ease of use, I can put together a dashboard in about an hour that is used by daily.
  • Support, their support team is super helpful and always has detailed insight.
  • Connectors, they have a huge number of connectors that allow easy integration of your data sources.
Read full review
Hitachi Vantara
  • Integrate and synchronize with big data easily
  • Import data from any sources and different databases
  • Managing data in on-premise, hybrid and cloud environments.
  • Compatibility and flexibility of the platform with any type of scenario and any business or industry
  • Various tools in the software suite to transformation of data
  • Simple interface appearance and creative UI graphics
Read full review
Cons
ClicData
  • More widgets.
  • Sometimes it takes a while to refresh.
Read full review
Hitachi Vantara
  • I think the relative obscurity of the tool is a downside, not as many developers, consultants or peers you can tap into.
  • Lack of a solid user community held us back, looking at Power BI and Qlik, they have huge user communities that help each other out. Would have liked that here.
  • Smaller company means smaller sales force, and the lack of a local presence made it hard to only interact online with the account rep. Other companies have someone local who often stops by with pre-sales developers to just pitch in free of charge when they have time.
Read full review
Likelihood to Renew
ClicData
No answers on this topic
Hitachi Vantara
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
Read full review
Usability
ClicData
Like I mentioned before, the ease of use means we not only get very quick results and beautiful dashboards in minutes, it means my team is actually using it because they aren't frustrated in the learning curve or wasting time trying to accomplish simple tasks.
Read full review
Hitachi Vantara
The Pentaho tools are designed so you can start playing around on your own. Of course, you will need guidance at some point, but the training teams are good at guiding new users, and the online documentation is usually pretty up-to-date.
Some of the tools, such as the Pentaho Data Integration tool and the Pentaho Server, are pretty self-explanatory. The other tools maybe are not so quickly and obvious to use, but again, with some documentation and some customer support, you can find your way around them.
Read full review
Support Rating
ClicData
We've only needed support a couple times in the beginning as we were learning the system and how to display our data in interesting ways. Every time we reached out we got very detailed responses and were connected to someone that you could tell was very interested in making sure we were happy with how things were going.
Read full review
Hitachi Vantara
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.
Read full review
Online Training
ClicData
No answers on this topic
Hitachi Vantara
Course Taken: DI1000 Pentaho Data Integration Fundamentals Setup 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 Course The 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
Read full review
Implementation Rating
ClicData
No answers on this topic
Hitachi Vantara
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.
Read full review
Alternatives Considered
ClicData
ClicData was the most flexible. It is cloud-based and even has WebService access. You can publish your data for access from other applications. The sheer number of data connectors is amazing. The ability to not only create dashboards, but you can schedule them to be delivered to specific recipients on a scheduled basis via PDF or a static HTML page.
Read full review
Hitachi Vantara
Since the Pentaho platform offers a range of broad functionality across data preparation and advanced analytics, it also can be easily integrated to support many data sources and machine-learning frameworks. Based on that fact, we selected Pentaho to be used in our internal department. It also supports many of our BI use cases as required by company management or the business user. Last but not least, the Pentaho license is cheaper than their competitor.
Read full review
Return on Investment
ClicData
  • ClicData was by far the most reasonable cost-wise, and we were able to get ROI within just minutes of using it.
Read full review
Hitachi Vantara
  • Pentaho has improved our overall business process.
  • Pentaho has helped the Managers and Directors to analyze the numbers going up and down from time to time.
  • We have a started a big project using Pentaho that is going to include all the business processes in the organization.
Read full review
ScreenShots

ClicData Screenshots

Screenshot of Screenshot of ClicData's data warehouse where all your company's data is centralized.Screenshot of Some of ClicData's connectors. 250+ data connections are available.Screenshot of Preview of a joint between datasets from two different sources. Do basic or advanced data transformations with ClicData's ETL features.Screenshot of Daily Sales Productivity dashboard exampleScreenshot of Financial KPIs Dashboard example