ClicData vs. Amazon Redshift

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
Amazon Redshift
Score 7.8 out of 10
N/A
Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.
$0.24
per GB per month
Pricing
ClicDataAmazon Redshift
Editions & Modules
Premium
$79
per month
Team
$269
per month
Business
$525
per month
Enterprise
Custom Quote
Redshift Managed Storage
$0.24
per GB per month
Current Generation
$0.25 - $13.04
per hour
Previous Generation
$0.25 - $4.08
per hour
Redshift Spectrum
$5.00
per terabyte of data scanned
Offerings
Pricing Offerings
ClicDataAmazon Redshift
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
Community Pulse
ClicDataAmazon Redshift
Top Pros
Top Cons
Features
ClicDataAmazon Redshift
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
ClicData
10.0
3 Ratings
20% above category average
Amazon Redshift
-
Ratings
Pixel Perfect reports10.01 Ratings00 Ratings
Customizable dashboards10.03 Ratings00 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
Amazon Redshift
-
Ratings
Drill-down analysis8.03 Ratings00 Ratings
Formatting capabilities9.03 Ratings00 Ratings
Report sharing and collaboration10.02 Ratings00 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
Amazon Redshift
-
Ratings
Publish to Web10.02 Ratings00 Ratings
Publish to PDF9.02 Ratings00 Ratings
Report Versioning7.02 Ratings00 Ratings
Report Delivery Scheduling8.01 Ratings00 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
Amazon Redshift
-
Ratings
Pre-built visualization formats (heatmaps, scatter plots etc.)10.03 Ratings00 Ratings
Location Analytics / Geographic Visualization7.02 Ratings00 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
Amazon Redshift
-
Ratings
Multi-User Support (named login)10.02 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)10.02 Ratings00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
ClicData
6.0
2 Ratings
28% below category average
Amazon Redshift
-
Ratings
Responsive Design for Web Access7.02 Ratings00 Ratings
Mobile Application1.01 Ratings00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile10.02 Ratings00 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
Amazon Redshift
-
Ratings
iFrames10.01 Ratings00 Ratings
Themeable User Interface (UI)10.01 Ratings00 Ratings
Best Alternatives
ClicDataAmazon Redshift
Small Businesses
SAP Crystal
SAP Crystal
Score 8.9 out of 10
Google BigQuery
Google BigQuery
Score 8.6 out of 10
Medium-sized Companies
Reveal
Reveal
Score 9.9 out of 10
Snowflake
Snowflake
Score 9.0 out of 10
Enterprises
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
Snowflake
Snowflake
Score 9.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
ClicDataAmazon Redshift
Likelihood to Recommend
10.0
(3 ratings)
8.0
(37 ratings)
Usability
10.0
(1 ratings)
10.0
(9 ratings)
Support Rating
10.0
(1 ratings)
9.0
(7 ratings)
Contract Terms and Pricing Model
-
(0 ratings)
10.0
(1 ratings)
User Testimonials
ClicDataAmazon Redshift
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
Amazon AWS
If the number of connections is expected to be low, but the amounts of data are large or projected to grow it is a good solutions especially if there is previous exposure to PostgreSQL. Speaking of Postgres, Redshift is based on several versions old releases of PostgreSQL so the developers would not be able to take advantage of some of the newer SQL language features. The queries need some fine-tuning still, indexing is not provided, but playing with sorting keys becomes necessary. Lastly, there is no notion of the Primary Key in Redshift so the business must be prepared to explain why duplication occurred (must be vigilant for)
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
Amazon AWS
  • [Amazon] Redshift has Distribution Keys. If you correctly define them on your tables, it improves Query performance. For instance, we can define Mapping/Meta-data tables with Distribution-All Key, so that it gets replicated across all the nodes, for fast joins and fast query results.
  • [Amazon] Redshift has Sort Keys. If you correctly define them on your tables along with above Distribution Keys, it further improves your Query performance. It also has Composite Sort Keys and Interleaved Sort Keys, to support various use cases
  • [Amazon] Redshift is forked out of PostgreSQL DB, and then AWS added "MPP" (Massively Parallel Processing) and "Column Oriented" concepts to it, to make it a powerful data store.
  • [Amazon] Redshift has "Analyze" operation that could be performed on tables, which will update the stats of the table in leader node. This is sort of a ledger about which data is stored in which node and which partition with in a node. Up to date stats improves Query performance.
Read full review
Cons
ClicData
  • More widgets.
  • Sometimes it takes a while to refresh.
Read full review
Amazon AWS
  • We've experienced some problems with hanging queries on Redshift Spectrum/external tables. We've had to roll back to and old version of Redshift while we wait for AWS to provide a patch.
  • Redshift's dialect is most similar to that of PostgreSQL 8. It lacks many modern features and data types.
  • Constraints are not enforced. We must rely on other means to verify the integrity of transformed tables.
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
Amazon AWS
Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.
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
Amazon AWS
The support was great and helped us in a timely fashion. We did use a lot of online forums as well, but the official documentation was an ongoing one, and it did take more time for us to look through it. We would have probably chosen a competitor product had it not been for the great support
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
Amazon AWS
Than Vertica: Redshift is cheaper and AWS integrated (which was a plus because the whole company was on AWS).
Than BigQuery: Redshift has a standard SQL interface, though recently I heard good things about BigQuery and would try it out again.
Than Hive: Hive is great if you are in the PB+ range, but latencies tend to be much slower than Redshift and it is not suited for ad-hoc applications.
Read full review
Contract Terms and Pricing Model
ClicData
No answers on this topic
Amazon AWS
Redshift is relatively cheaper tool but since the pricing is dynamic, there is always a risk of exceeding the cost. Since most of our team is using it as self serve and there is no continuous tracking by a dedicated team, it really needs time & effort on analyst's side to know how much it is going to cost.
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
Amazon AWS
  • Our company is moving to the AWS infrastructure, and in this context moving the warehouse environments to Redshift sounds logical regardless of the cost.
  • Development organizations have to operate in the Dev/Ops mode where they build and support their apps at the same time.
  • Hard to estimate the overall ROI of moving to Redshift from my position. However, running Redshift seems to be inexpensive compared to all the licensing and hardware costs we had on our RDBMS platform before Redshift.
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