Centralize your transactional database data.
For integrating your OLTP data into your OLAP workloads, you need connectors that are easy to use, connect securely, and automatically read updates through logs to ensure data integrity.
Reliable database replication
Log-based incremental updates
Your database replication tool should run with minimal impact on your production database. Log-based replication ensures transactional integrity, doesn’t require full table scans to determine updates, and eliminates the need to script a process to add timestamps.
Automatic Schema Mapping and Schema Drift Handling
Fivetran is tuned for each destination to map the appropriate schema relations and data types from every database source. Our pipeline automatically adjusts for new tables and columns added in the source by adding them to the destination with no manual interference needed.
Secure Encrypted Connections
In addition to encrypted direct connections, we offer connectivity through SSH, Reverse SSH, and VPN tunnels. We will always verify your database certificate with you during initial authentication.
ADDITIONAL DETAILS
Crafted with production systems in mind
We’re constantly refining our sync strategy. See what optimizations we’ve made in our release notes!
- Micro-batched queries
Automated queries to pull all existing data from your database are optimized for each source to minimize production impact.
- Idempotent syncs
Fivetran stores a record of successful sync states and compares this to the destination schema to ensure we never lose our place in a sync.
- Efficient destination loading
You want to minimize loading overhead on your destination, so Fivetran pre-processes changed data to create a neat merge file with an optimized sync strategy for every destination.
DATA SOURCE CONNECTOR DIRECTORY
Connectors for every data source.
Request Connector
Don’t see a data source you need? We add new connectors based on customer requests.
View Articles from our Blog
Stay up to date with new connectors and features as they become available.
Start analyzing your data in minutes, not months
Launch any Fivetran connector instantly.