Automating the data extraction and loading part with ease
October 31, 2024

Automating the data extraction and loading part with ease

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

Overall Satisfaction with Fivetran

We want to load data from various operational systems into our central data warehouse. Fivetran supports this task with minimal setup and maintenance effort on our side. This allows us to focus on the value adding tasks instead of on moving data between systems. We use Fivetran to sync data from CRM, Marketing Automation, ERP, HR, Subscription Management and Billing, and Support systems.

Pros

  • Small initial setup effort
  • Fivetran automatically takes care to fix loading issues
  • Has connectors to many different systems

Cons

  • Very difficult to get connectors enhanced if a specific needed object is not supported by them
  • Depending on the edition needed and the data volumes, can get quite expensive
  • Saved a lot of manual development days (unable to quantify)
  • Accelerated the time to add a new source to the data warehouse a lot
Very easy and intuitive to setup and maintain as there usually are not that many options. Very well documented (e.g. how to setup each connector, how the schema looks like, any specific features of this connector etc.). Also the operation is intuitive, e.g. you have status pages, log pages, configuration pages etc. for each connector.
Matillion requires a lot more initial setup effort and the resulting schemas are also much more "raw" data than the nicely cleaned schemas which Fivetran provides. Therefore it would also require more (manual) post-processing efforts compared to Fivetran. So the savings on time and internal resources are not as big. Stitch did not have as many supported source systems based on our specific requirements and also was more expensive for our case.

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?

Yes

Did implementation of Fivetran go as expected?

Yes

Would you buy Fivetran again?

Yes

If your source systems have a supported connector and the provided schemas from Fivetran work for you, then I consider it well suited. Also make sure based on your volume estimations if the costs work out for you. If you want to focus your data engineers on more value adding tasks and outsource the "moving data from A to B" part, then Fivetran is a great match. If you want to custom-develop all the data integrations and have a sufficiently large workforce to do so, then you might not need it.

Fivetran Feature Ratings

10.0
Connect to traditional data sources
10
Connecto to Big Data and NoSQL
10
8.0
Simple transformations
8
Complex transformations
8
8.3
Business rules and workflow
8
Collaboration
8
Testing and debugging
9
8.0
Integration with data quality tools
8
Integration with MDM tools
8

Comments

More Reviews of Fivetran

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