Gets data from Point A to Point B
January 28, 2019

Gets data from Point A to Point B

Scott Laronge | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Fivetran

We use it to sync a MySQL instance to a redshift cluster so we can run analytics against a non-prod environment.

Pros

  • Quick replication of data with minimal lag.
  • Automated reporting if data is out of date.
  • The customer support team is relatively good.

Cons

  • A full schema refresh takes us two-three days and knocks us offline from monitoring up-to-date business KPIs, running updated analyses, etc. This is likely due to us having massive amounts of data (from a count(1) perspective, not size of tables perspective).
  • There's little to no progress estimate on the front end UI to see how long this refresh might take and you need to enable back end logging in Amazon to see where it's at in the sync process and derive rough estimates of completion time.
  • I don't think about ETL (Extract, Transform and Load).
  • I don't process any ETL, it's set it and forget it.
Honestly, we haven't done much investigation in a while, it just works 360 days of the year. The other five days there may be a hiccup that will throw us a day off of data, but it gets caught up in the end.
It runs pretty well and gets our data from point A to point cluster quickly enough. Honestly, it's not something I think about unless it breaks and that's pretty rare.
Just need to input connection info.
Fivetran works well when you have a lot of data in different places and want to get it all in one spot. I don't think it's as necessary if you have one cluster that needs to be replicated against and the data could wait a day. In this instance, there are other tools.

Comments

More Reviews of Fivetran

  1. Home
  2. Data Integration Tools
  3. Fivetran Reviews
  4. User Review of Fivetran