34 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
9 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.1 out of 100

Feature Set Ratings

    BI Standard Reporting

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    10.0

    ClicData

    100%
    ClicData ranks higher in 2/2 features

    Pixel Perfect reports

    N/A
    0 Ratings
    10.0
    100%
    1 Rating

    Customizable dashboards

    N/A
    0 Ratings
    9.9
    99%
    3 Ratings

    Ad-hoc Reporting

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    8.9

    ClicData

    89%
    ClicData ranks higher in 3/3 features

    Drill-down analysis

    N/A
    0 Ratings
    8.0
    80%
    3 Ratings

    Formatting capabilities

    N/A
    0 Ratings
    8.9
    89%
    3 Ratings

    Report sharing and collaboration

    N/A
    0 Ratings
    9.9
    99%
    2 Ratings

    Report Output and Scheduling

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    8.5

    ClicData

    85%
    ClicData ranks higher in 4/4 features

    Publish to Web

    N/A
    0 Ratings
    10.0
    100%
    2 Ratings

    Publish to PDF

    N/A
    0 Ratings
    9.0
    90%
    2 Ratings

    Report Versioning

    N/A
    0 Ratings
    7.0
    70%
    2 Ratings

    Report Delivery Scheduling

    N/A
    0 Ratings
    8.0
    80%
    1 Rating

    Data Discovery and Visualization

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    8.5

    ClicData

    85%
    ClicData ranks higher in 2/2 features

    Pre-built visualization formats (heatmaps, scatter plots etc.)

    N/A
    0 Ratings
    9.9
    99%
    3 Ratings

    Location Analytics / Geographic Visualization

    N/A
    0 Ratings
    7.0
    70%
    2 Ratings

    Access Control and Security

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    10.0

    ClicData

    100%
    ClicData ranks higher in 2/2 features

    Multi-User Support (named login)

    N/A
    0 Ratings
    10.0
    100%
    2 Ratings

    Multiple Access Permission Levels (Create, Read, Delete)

    N/A
    0 Ratings
    10.0
    100%
    2 Ratings

    Mobile Capabilities

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    5.9

    ClicData

    59%
    ClicData ranks higher in 3/3 features

    Responsive Design for Web Access

    N/A
    0 Ratings
    6.9
    69%
    2 Ratings

    Mobile Application

    N/A
    0 Ratings
    1.0
    10%
    1 Rating

    Dashboard / Report / Visualization Interactivity on Mobile

    N/A
    0 Ratings
    9.9
    99%
    2 Ratings

    Application Program Interfaces (APIs) / Embedding

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    10.0

    ClicData

    100%
    ClicData ranks higher in 2/2 features

    iFrames

    N/A
    0 Ratings
    10.0
    100%
    1 Rating

    Themeable User Interface (UI)

    N/A
    0 Ratings
    10.0
    100%
    1 Rating

    Attribute Ratings

    • ClicData is rated higher in 3 areas: Likelihood to Recommend, Usability, Support Rating

    Likelihood to Recommend

    8.8

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    88%
    8 Ratings
    10.0

    ClicData

    100%
    3 Ratings

    Usability

    9.5

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    95%
    2 Ratings
    10.0

    ClicData

    100%
    1 Rating

    Support Rating

    9.5

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    95%
    2 Ratings
    10.0

    ClicData

    100%
    1 Rating

    Contract Terms and Pricing Model

    10.0

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    100%
    1 Rating

    ClicData

    N/A
    0 Ratings

    Likelihood to Recommend

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    In terms of a well-suited scenario - the Azure Synapse can be used to capture data from multiple sources (especially from onPrem sources apart from Dataverse) and update the transformed data based on the given conditions (eg: refresh data based on the specified date/time ranges). Also, the transformed data can simply be transferred to Azure Data Lake for further processing by utilizing other analytics tools such as PowerBI.
    Anonymous | TrustRadius Reviewer

    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.
    Ben Warren | TrustRadius Reviewer

    Pros

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    • Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
    • Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
    • Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.
    Anonymous | TrustRadius Reviewer

    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.
    Anonymous | TrustRadius Reviewer

    Cons

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    • Integrating external 3rd party data sources is very easy in Snowflake and it’s missing in Azure Synapse
    • Master data services and data quality services are missing in Azure Synapse. They are useful features present in on Orem Sql server
    • Resource usage reports (top 10 expensive queries, most frequently run queries, etc) are a feature that can be added in Azure Synapse. It’s present in an on-prem SQL server. DMVs are there but viewing it visually as a report is more helpful.
    Anonymous | TrustRadius Reviewer

    ClicData

    • More widgets.
    • Sometimes it takes a while to refresh.
    Anonymous | TrustRadius Reviewer

    Pricing Details

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    General

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

    Starting Price

    Azure Synapse Analytics (Azure SQL Data Warehouse) Editions & Modules

    Additional Pricing Details

    ClicData

    General

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

    Starting Price

    $79 per month

    ClicData Editions & Modules

    Edition
    Premium$791
    Team$2691
    EnterpriseCustom Quote
    Business$5253
    1. per month
    2. none
    3. per month
    Additional Pricing Details
    All 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.

    Usability

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Azure Synapse Analytics (Azure SQL Data Warehouse) 9.5
    Based on 2 answers
    The data warehouse portion is very much like old style on-prem SQL server, so most SQL skills one has mastered carry over easily. Azure Data Factory has an easy drag and drop system which allows quick building of pipelines with minimal coding. The Spark portion is the only really complex portion, but if there's an in-house python expert, then the Spark portion is also quiet useable.
    Anonymous | TrustRadius Reviewer

    ClicData

    ClicData 10.0
    Based on 1 answer
    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.
    Anonymous | TrustRadius Reviewer

    Support Rating

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Azure Synapse Analytics (Azure SQL Data Warehouse) 9.5
    Based on 2 answers
    Microsoft does its best to support Synapse. More and more articles are being added to the documentation, providing more useful information on best utilizing its features. The examples provided work well for basic knowledge, but more complex examples should be added to further assist in discovering the vast abilities that the system has.
    Anonymous | TrustRadius Reviewer

    ClicData

    ClicData 10.0
    Based on 1 answer
    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.
    Anonymous | TrustRadius Reviewer

    Alternatives Considered

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    We also looked at Oracle Data Warehouse as part of our short list of products to implement as a solution. Oracle's product turned out to have less support by way of easily accessible internet blogs. Oracle was also considerably more expensive and we would have needed to hire the skillset needed to implement.
    Samir Patel, PMP | TrustRadius Reviewer

    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.
    Ben Warren | TrustRadius Reviewer

    Contract Terms and Pricing Model

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Azure Synapse Analytics (Azure SQL Data Warehouse) 10.0
    Based on 1 answer
    Basically, the billing is predictable, and this all about it.
    Vladimír Mužný | TrustRadius Reviewer

    ClicData

    No score
    No answers yet
    No answers on this topic

    Return on Investment

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    • Azure Synapse has predominately reduced the time being used for processing data being extracted from multiple sources
    • Ability to integrate multiple data sources and create a single dataset that could be used for further analytics to find KPIs
    Anonymous | TrustRadius Reviewer

    ClicData

    • ClicData was by far the most reasonable cost-wise, and we were able to get ROI within just minutes of using it.
    Anonymous | TrustRadius Reviewer

    Screenshots

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Add comparison