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.
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.
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.
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
We’re constantly refining our sync strategy. See what optimizations we’ve made in our release notes!
Automated queries to pull all existing data from your database are optimized for each source to minimize production impact.
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.
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
Don’t see a data source you need? We add new connectors based on customer requests.
Stay up to date with new connectors and features as they become available.
Launch any Fivetran connector instantly.