CData Sync vs Dataflowz

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.

Dataflowz is a reverse ETL platform that sends warehouse data to business tools. It connects to Snowflake, BigQuery, Redshift, Databricks, PostgreSQL, MySQL and custom SQL databases through JDBC or ODBC. Listed destinations include Salesforce, HubSpot, Zendesk, Intercom, Marketo, Braze, Amplitude, Mixpanel, Google Ads, Facebook Ads, Slack and Microsoft Teams, with 100+ more integrations via REST API. Syncs can be scheduled, started through the API or run through change data capture for real-time updates. A visual mapping interface supports field mapping, transformations, filters and test syncs; transformations can also use SQL or Python. Free Starter includes one warehouse connection, three destination connections, 10K synced rows per month and daily syncs. Professional costs $299 a month and includes 1M rows per month, hourly syncs, version control, collaboration and API access. Row-limit overages incur plan-based fees. Dataflowz lists TLS 1.3 in transit, AES-256 at rest, SOC 2 Type II, GDPR and CCPA compliance; ISO 27001 is in progress and HIPAA is available.