Fivetran for fast data replication
December 03, 2021

Fivetran for fast data replication

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

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

Fivetran is a good choice if you want to get started quickly with replicating production transactional database tables to Snowflake with minimal impact on production. Setup is fast and Fivetran provides a user-friendly interface that can be used to resync individual tables if necessary. It's a good solution for a mature database schema where certain tables hold a very large amount of data, which when replicated into a system like Snowflake allows users to execute queries against the dataset that would otherwise be very slow and not perform well directly against the production database.

Fivetran Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
9
Complex transformations
7
Data model creation
Not Rated
Metadata management
Not Rated
Business rules and workflow
Not Rated
Collaboration
9
Testing and debugging
Not Rated
feature 1
Not Rated
Integration with data quality tools
9
Integration with MDM tools
Not Rated