Fivetran for fast data replication
December 03, 2021
Fivetran for fast data replication
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Fivetran
We use Fivetran at my organization to securely replicate data from our production databases to our data warehouses in Snowflake, syncing production data at regular intervals on a daily schedule. This allows us to efficiently move data without impacting our production systems and allows us to keep more historically complete records of the life of data that exists in our production databases.
- Allows triggering of transformations using basic SQL transformations performed when new data is loaded or synced over
- Supporting data sync without affecting production databases availability or increasing load on production databases
- Providing out-of-the-box connectors for quick and easy connection to a variety of commonly used databases
- Supporting a variety of data sources (not only databases but also files like JSON or CSV files with exported data
- Doesn't include support for a Kinesis stream as a data source so couldn't be used for some use cases under consideration
- Doesn't support the use of "BEFORE DELETE" triggers
- No support for serverless Aurora
- Secure connection
- Intuitive, easy-to-use interface
- Speed
- Time savings due to the ease of setup and maintenance
Do you think Fivetran delivers good value for the price?
Yes
Are you happy with Fivetran's feature set?
Yes
Did Fivetran live up to sales and marketing promises?
I wasn't involved with the selection/purchase process
Did implementation of Fivetran go as expected?
I wasn't involved with the implementation phase
Would you buy Fivetran again?
Yes