What is Integrate.io ELT & CDC
Integrate.io ELT & CDC is a managed data replication platform that moves data from transactional databases and SaaS applications to cloud data warehouses and storage. It uses change data capture (CDC) to replicate data in near real-time, keeping your analytics warehouse in sync with your source systems without manual ETL scripting.How it works
ELT & CDC connects to your source databases and applications, performs an initial full sync of your selected tables, then continuously captures changes (inserts, updates, and deletes) as they happen. Data flows through a staging layer and lands in your destination in a query-ready format. The pipeline handles schema changes automatically. When columns are added or modified at the source, those changes propagate to the destination without manual intervention. See How Integrate.io ELT & CDC Handles Schema Changes for details.Supported sources
ELT & CDC supports two categories of sources: Database sources with log-based CDC — PostgreSQL, MySQL, Microsoft SQL Server, and Oracle. These use native database replication logs (WAL for PostgreSQL, binlog for MySQL, transaction log for SQL Server) to capture changes with minimal impact on the source database. Supported across AWS RDS, Aurora, Azure, Google Cloud SQL, and self-hosted deployments. SaaS and API sources — 40+ connectors including Salesforce, Shopify, HubSpot, Stripe, Google Ads, Facebook Ads, and more. These use API-based polling to sync data on a scheduled basis. See the full list in Sources.Supported destinations
Replicated data can be loaded to:- Amazon Redshift — with optional custom S3 staging bucket
- Snowflake — with key-pair or password authentication
- Google BigQuery — direct load
- Amazon S3 — Avro file output
Key features
| Feature | Description |
|---|---|
| Initial sync | Full historical load with parallel chunking for large tables |
| Continuous sync | Near real-time change capture after initial sync completes |
| History mode | SCD Type 2 tracking that preserves previous record versions. See History Mode |
| Auto sync new tables | Automatically detects and syncs newly created tables at the source. See Auto Sync |
| Schema change handling | Propagates column additions and type changes to the destination |
| Custom primary keys | Override default primary keys for tables without them. See Custom Primary Key |
| Data observability | Built-in monitoring with replication delay metrics and alerts. See Data Observability |
| SSH tunnels | Connect to databases behind firewalls. See SSH Tunnel |
| PrivateLink | AWS PrivateLink support for MySQL and PostgreSQL |