CData Sync vs SQL Server Integration Services
CData Sync
cdata.comSQL Server Integration Services
learn.microsoft.comSide by side
| Figure | CData Sync | SQL Server Integration Services |
|---|---|---|
| Price from | $666.58/mo | — |
| Free plan | — | — |
| Free trial | Yes | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | Yes | Yes |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 4 | 0 |
| Spec score · ETL and ELT Tools | 8.6 (#5) | 7.2 (#9) |
| Deployment | Sync can be deployed on premises, in cloud environments, or through CData-hosted Sync Cloud. | SSIS deployment tools can move packages to another computer and manage dependencies such as configurations and files. |
| Purpose | CData Sync replicates data from sources such as databases, SaaS applications, and APIs to databases, data lakes, and data warehouses. | SSIS is a platform for building enterprise-level data integration and data transformation solutions, including copying files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data. |
| Support | CData lists technical support hours as Monday through Friday, 9 a.m. to 6 p.m. Eastern Time. | The SSIS documentation directs users to the SSIS forum, Stack Overflow, the SSIS team blog, and issue and feature reporting. |
Plans
CData Sync
- ProfessionalPriced on request
- EnterprisePriced on request
- Standard$7,999 a year
- BYOLPriced on request
In their own words
CData Sync
CData Sync replicates data from databases, SaaS applications and APIs to databases, data lakes and data warehouses. CData says it supports over 250 sources and offers a catalog of cloud and on-premises destinations. Pipelines can use incremental loading and, for supported sources, real-time Change Data Capture. ETL and ELT transformations are available through SQL or dbt Core and Cloud. Users can schedule pipelines and receive email, Slack or Teams notifications when workflows finish or fail. Sync can run on premises, in cloud environments or through CData-hosted Sync Cloud, and is listed for Linux, Windows, web, API and self-hosted use. Its APIs and scripting can manage connections and jobs, inspect status and history, download logs, and run custom behavior around jobs. It can adjust destination schemas when source schemas change; its overview says it does not delete destination columns or reduce their size. CData documents TLS/SSL encryption and encrypted sensitive configuration values and reports third-party SOC 2 Type II and ISO/IEC 27001:2022 audits. A 14-day trial is available; there is no free plan.
SQL Server Integration Services
SQL Server Integration Services has no write-up on Specifiction yet; its figures are above.