TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    CData Sync

    Score7 out of 10
    N/ACData's Sync is a data pipeline tool able to connect data sources to the user's database or data warehouse, supporting at present over 200 possible sources, and a range of destinations (e.g. Snowflake, S3, Redshift), connecting on-premise or SaaS sources and destinations.N/A

    Denodo

    Score8 out of 10
    N/ADenodo is the eponymous data integration platform from the global company headquartered in Silicon Valley.N/A
    Pricing
    CData SyncDenodo
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    CData SyncDenodo
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Features
    CData SyncDenodo
    Data Source Connection
    Comparison of Data Source Connection features of CData Sync and Denodo
    Feature
    CData Sync
    8.0
    1 Ratings
    5% below category average
    Denodo
    -
    Ratings
    Connect to traditional data sources8.01 Ratings00 Ratings
    Data Modeling
    Comparison of Data Modeling features of CData Sync and Denodo
    Feature
    CData Sync
    7.5
    1 Ratings
    6% below category average
    Denodo
    -
    Ratings
    Collaboration8.01 Ratings00 Ratings
    Testing and debugging7.01 Ratings00 Ratings
    Best Alternatives
    CData SyncDenodo
    Small Businesses
    Skyvia
    Score10 out of 10
    No answers on this topic
    Medium-sized Companies
    IBM InfoSphere Information Server
    Score10 out of 10
    No answers on this topic
    Enterprises
    SolarWinds Task Factory
    Score8.3 out of 10
    No answers on this topic
    All AlternativesView all alternativesView all alternatives
    User Ratings
    CData SyncDenodo
    Likelihood to Recommend
    7.0
    (2 ratings)
    8.8
    (6 ratings)
    Usability
    8.0
    (1 ratings)
    8.0
    (1 ratings)
    Performance
    -
    (0 ratings)
    8.0
    (1 ratings)
    User Testimonials
    CData SyncDenodo
    Likelihood to Recommend
    CData Software
    Evidently, CData Sync is an excellent middleware tool that is perfect for syncing data between systems. It is especially suitable and works well on SQL servers, DB2, MySQL, and Snowflake, and some of their brothering domains. However, it is a limitation in working with Sage 50 API. But if it is extracted with ODBC, it works well.
    Incentivized
    Read full review
    Denodo
    Denodo allows us to create and combine new views to create a
    virtual repository and APIs without a single line of code. It is excellent
    because it can present connectors with a view format for downstream consumers
    by flattening a JSON file. Reading or connecting to various sources and
    displaying a tabular view is an excellent feature. The product's technical data
    catalog is well-organized.
    Incentivized
    Read full review
    Pros
    CData Software
    • UPSERT
    • Friendly interface
    Incentivized
    Read full review
    Denodo
    • Database Agnostic: You can easily connect to different environments and mash up data sets.
    • The "magic" of data virtualization: No data is created, so data is reported in near-real-time to end users.
    • It's easy to use UI for developers. You just connect to a data source, create tables, and join them to other datasets.
    Incentivized
    Read full review
    Cons
    CData Software
    • Although efficient for SQL servers and MySQL, as well as Snowflake. It is not strong for other database engines, and an upgrade on this would do a lot.
    • The installation process is manual as opposed to the cloud installation it should be.
    • A feature of syncing auto increment ID key, that will help in existing data management.
    Incentivized
    Read full review
    Denodo
    • Caching - but I am sure it will be improved by now. There were times when we expected the cache to be refreshed but it was stale.
    • Schema generation of endpoints from API response was sometimes incomplete as not all API calls returned all the fields. Will be good to have an ability to load the schema itself (XSD/JSON/Soap XML etc).
    • Denodo exposed web services were in preliminary stage when we used; I'm sure it will be improved by now.
    • Export/Import deployment, while it was helpful, there were unexpected issues without any errors during deployment. Issues were only identified during testing. Some views were not created properly and did not work. If it was working in the environment from where it was exported from, it should work in the environment where it is imported.
    Incentivized
    Read full review
    Usability
    CData Software
    It is easy to setup and use
    Incentivized
    Read full review
    Denodo
    Denodo is very easy to use. It has a user-friendly drag and drop interface. I'm not a fan of the java platform it resides on.
    Incentivized
    Read full review
    Performance
    CData Software
    No answers on this topic
    Denodo
    Denodo is a tool to rapidly mash data sources together and create meaningful datasets. It does have its downfalls though. When you create larger, more complex datasets, you will most likely need to cache your datasets, regardless of how proper your joins are set up. Since DV takes data from multiple environments, you are taxing the corporate network, so you need to be conscious of how much data you are sending through the network and truly understand how and when to join datasets due to this.
    Incentivized
    Read full review
    Alternatives Considered
    CData Software
    Tableau is another similar software tool, unlike CData Sync, rather transforms data into actionable insights. While CData Sync works with automation, Tableau uses a drag box on its AVA, which in turn slows the work speed on the syncing of data. Over the years, I enjoyed the friendly and customizable option of CData Sync over Tableau's.
    Incentivized
    Read full review
    Denodo
    Denodo is simple and easy to use. Highly recommended unless you have huge volumes of data
    Incentivized
    Read full review
    Return on Investment
    CData Software
    • Positive: Easy way to bring data for our DWH
    • Negative: Frequent issue in CData Sync Server
    Incentivized
    Read full review
    Denodo
    • It is a huge advantage that we can connect to many different databases to provide data rapidly and accurately.
    • It has proven to be a valuable environment for deploying data virtualization solutions, and its user community is active in finding and fixing issues.
    Incentivized
    Read full review
    ScreenShots