Sign Up For Our Second Low-Key Data Conference15 speakers. 4 hours. Virtual event. No frills. Join us on 7/12/23 from 1-5pm EST - Click here to sign up!.
Not all ELT tools are created equal - but if you're in the market for one, chances are you've come across CData software.
Rather than a single application, CData is a platform with a suite of tools for various types of data tasks, including ELT, ETL, and Reverse ETL.
But CData isn’t perfect. Support for long-tail ETL connectors can be challenging, and building a complete data pipeline can be complex since each component is sold separately.
There are several worthwhile CData alternatives to consider before choosing the right ETL tool. Today we’ll look at CData’s top 10 competitors.
CData is one of the most complete data integration platforms on the market. Its suite includes tools for data visualization, data connectivity, cloud connectivity, ELT, ETL, Reverse ETL, and more.
Because it’s all bundled in the same suite, you can reduce the total number of tools in your tech stack to be more efficient.
CData software tools work with APIs and SaaS tools (including Salesforce, Oracle, HubSpot, SAP, and AWS) as well as NoSQL and big data sources using the most popular types of data connectors (including ODBC, JDBC, Python, and ADO.NET).
CData supports major cloud data warehouses including Snowflake, Amazon Redshift, Google BigQuery, and Microsoft Azure Synapse.
CData also has a unique offer that you won’t find with most competitors: the company will create all the custom integrations you need in 90 days.
For teams without the resources to develop their own data connectors, this is the next-best option after a plug-and-play platform.
However, CData’s pricing can be complex, since each tool is included separately.
It can be hard to find the community support and documentation you need.
For those who opt for the 90-day custom integration offer, there aren’t details on how CData will maintain those connectors when their underlying APIs inevitably change.
Each additional tool has separate pricing and plans.
Portable builds and mantains the long-tail connectors you won’t find on CData or anywhere else.
Portable connects to 250+ data sources to Snowflake, RedShift, BigQuery, Postgresql and provides ongoing maintenance for bespoke integrations.
Portable also works fast, turning around new connectors within days or sometimes even hours—a significant difference compared to CData’s 90-day custom connector option.
Portable has 250 pre-built connectors ready to go. These focus on long-tail connectors, as opposed to the major data sources you’ll find with major competitors like CData.
Portable’s strength is creating and maintaining custom connectors. Just request new data sources and the Portable team will develop an integration at no extra cost. And Portable does ongoing maintenance as well, so your team won’t be responsible for updates if the existing API changes.
Portable provides 24/7 customer support.
Portable is best for teams that need support for one or more long-tail data sources but don’t have the internal resources to create (and maintain) those connectors.
Matillion is an established data pipeline company that focuses on enterprise customers. It’s a close CData Sync alternative because of its plans—Matillion offers SaaS cloud-based and on-premise deployment options as well.
Matillion includes 110+ connectors. Matillion’s two products—Data Loader and ETL—don’t support the same set of data sources.
Matillion doesn’t support long-tail data sources. Customers can use the GUI to build simple API integrations, but will be responsible for ongoing maintenance.
Matillion offers a support portal for clients. Like CData, Matillion can require less maintenance since it’s all built into the same tech stack.
Matillion is a good choice for enterprises that appreciate CData features like a suite of tools and on-premise deployment but need a low-code or no-code option.
Rivery is a cloud-based SaaS ELT solution that uses no-code ELT scripts called “rivers.” In addition to a code-free GUI, users can also create connectors using the native Python integration.
Rivery provides 200+ pre-built connectors, all of which are included across all plans.
The Rivery Custom API feature lets you import data from any source. Rivery can also create custom data connectors upon request, though it’s unclear how long this takes or how requests are prioritized.
Rivery provides global 24/7 support, and a dedicated customer support agent for higher-tier plans. Rivery is praised for its customer support, earning an 9.8/10 score on G2 (the industry average is 8.5).
Rivery is ideal for teams with a lack of technical knowledge that need to get started quickly.
Hevo is a no-code bidirectional data platform built to eliminate data silos. Like CData, Hevo supports ELT, ETL, and Reverse ETL workflows. Hevo has built-in transformations through its native Python integration.
Hevo offers 150+ data connectors (only 50+ are available in the free plan).
You’ll need to develop connectors to any long-tail data sources yourself, using Hevo’s Webhooks data source or REST API. You’ll be responsible for ongoing maintenance.
Hevo offers round-the-clock support that’s been praised by customers.
Smaller businesses that make use of the most well-known data sources and need an easy-to-use ETL (or ELT) tool.
Airbyte is an open-source data integration tool and a relative newcomer founded in 2020. Airbyte offers a paid SaaS plan as well as its free open-source option for companies that host the software themselves.
Airbyte currently has more than 170 connectors available on its open-source platform. Not all are currently available on the cloud service but likely will be added in the near future.
You can request custom connectors through the Airbyte website, however they’ll likely prioritize those with the most use cases. To code new connectors yourself you’ll need to master the Airbyte protocols and build and maintain the integration yourself.
Airbyte has a community that’s 12,000 users strong. For customers of its paid SaaS plan, Airbyte offers in-app chat support with a one-hour response time.
Airbyte is best for teams that have the technical knowledge and capacity to create and maintain new connectors using Airbyte’s CDK.
Meltano is an open-source data platform that’s built with a code-first mindset. It’s reliant on the Singer protocol and has its own team that maintains the most popular connectors.
At the moment, Meltano only offers an open-source version of its platform. However, Meltano is in the process of developing a SaaS solution with a projected launch date in 2023.
Meltano has 300+ connectors that are ready to use out of the box.
You’ll need to develop and maintain your own custom connectors. Meltano offers an SDK and integrates with the Singer protocol, which can speed up development.
Meltano currently doesn’t offer paid support, but probably will once it launches its SaaS product. There is a small-but-growing community you can go to for help with Meltano.
Meltano is best for teams with technical expertise looking for a platform that’s built with programmers in mind.
Stitch is a BI tool owned by Talend. Stitch seeks to streamline data management with features like automated alerts and monitoring. It supports data transformations using Java, SQL, Python, the Stitch user interface, or a third-party engine.
Stitch includes 130+ data sources. Not all are available for all plans—some are considered “Enterprise” sources and are only available on the Premium and Advanced plans.
Stitch has its own REST API and integrates with Singer for open-source data connections. This makes development more flexible, but your team will still be responsible for creating and maintaining long-tail connectors.
Stitch provides email and chat support to all customers during normal business hours. Some customers may be eligible for phone support as well as a dedicated Customer Success Manager.
Stitch is best for teams already using tools in the Talend ecosystem, or that are familiar with Singer or the Stitch API for developing custom connectors.
Segment is a platform for customer data. Unlike CData and the other competitors on this list, Segment is exclusively focused on customer data, giving it some unique strengths but also limited use cases.
Segment includes 300+ built-in connectors which are included on all plans, including the free plan.
Segment includes a Functions tool that lets users integrate custom data sources.
Segment offers three levels of support across its plans: Standard, Advanced, and Premium, with enhanced support available as an add-on for Business plan members.
Segment is best for teams who only work with customer data.
Fivetran is one of the oldest ELT tools, having been on the market since 2012. It offers a premium service for larger enterprise clients and has focused on the most widely used data sources.
Fivetran connects to 160+ data sources, which represent the most popular enterprise platforms.
You can request custom data connectors through Fivetran, but there’s no insight into how requests are prioritized or how long they take. You can design your own connectors, but REST API access is not available on all plans.
Fivetran provides 24/7 support for all customers. Higher tier plans are provided with SLAs.
Fivetran is best for large enterprises with a sizable budget looking to work with popular data sources.
Precog takes an innovative approach to ELT using artificial intelligence. The platform uses an AI engine to create connectors, offering a no-code platform that can integrate with new data sources quickly.
You’ll need to request a demo or free trial to find pricing for Precog. The price is based on the number of data sources you need.
Precog provides over 10,000 data sources—thousands more than CData and every other competitor on this list.
According to Precog, you can build new data connectors in minutes using its AI engine. You can also request new connectors from Precog, and they’ll deliver within 48 hours.
Precog’s support plans are customized to your team’s specific needs.
Precog is best for teams looking for a code-free solution that works with a huge number of data sources.
CData is a popular choice with a large number of connectors, a done-for-you service, and a comprehensive suite of ELT, ETL, and Reverse ETL tools.
But CData isn’t the best fit for every team. It uses proprietary field names that lock you into the software. Creating a full data ecosystem in CData can be complex. And the 90-day setup offer is relatively slow, likely costly, and probably won’t cover ongoing maintenance.
There are other options that offer more tailored support to set up and maintain new data connectors.