CData Sync vs Google Cloud Datastream

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.

Google Cloud Datastream is a serverless change data capture and replication service for synchronizing data. Streams can capture ongoing updates and backfill historical records, while the service scales automatically without resources for users to provision or manage. Supported destinations include BigQuery, Cloud Storage, and Apache Iceberg tables. Documented sources include Oracle, MySQL, PostgreSQL, AlloyDB, SQL Server, MongoDB, Spanner, Salesforce, ServiceNow, Workday, and Microsoft Dataverse; some sources are marked as preview. Datastream can work with Dataflow templates to load data from Cloud Storage into destinations including BigQuery, Cloud SQL, and Spanner. Connectivity options include IP allowlisting, a forward SSH tunnel, and private connectivity over VPC peering. Processing is charged, idle streams incur no cost, and other Google Cloud resources are billed separately. The free tier includes 100 GiB of eligible CDC data per month per billing account. Events are delivered at least once, but ordering is not guaranteed. Datastream is administered through the Google Cloud console, CLI, or REST API.