CData Sync vs dataloader.io

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.

dataloader.io is a cloud service for importing, exporting and deleting Salesforce data. Users sign in with existing Salesforce credentials through OAuth 2.0. Automatic field mapping, keyboard shortcuts and search filters support data handling, and related objects can be exported in one pull. The service exchanges files with Box, Dropbox, FTP and SFTP repositories; SFTP is listed for Enterprise. Import, export and delete jobs can be scheduled hourly, daily, weekly or monthly. Professional and Enterprise add controls for organization and object access, plus a Salesforce Canvas interface installable as a managed package. The Free plan allows 10,000 records per month and one scheduled task, with tasks expiring after 30 days. Professional costs $99 per user per month, and Enterprise costs $299 per user per month. Enterprise has a 30-day free trial. The license limits use to a customer's internal business operations and bulk transfers from that customer's Salesforce account.