Item: Fivetran
Rating: 9
Author: Verified User

Use Cases and Deployment Scope

Fivetran is used by our reporting and analytics team to ingest data from multiple SaaS, Ad platform, and internal data sources. Fivetran supports our ELT approach using delivered connectors for most of our data sources.

Pros and Cons

Easily connects to source data using delivered connectors
Transforms data into standard models and schemas
Has very good documentation to help quickly setup connectors

Alerting and notification could be enhanced and be more timely in some cases
The error messages when there are connector setup issues could be more clear

Return on Investment

Fivetran has allowed us to dramatically improve our time to insight
It allows us to focus on business value as opposed to engineering
Reduced the amount of engineering resources we need to make data available

Alternatives Considered

Stitch, a Talend company, Azure Data Factory and Pentaho

Fivetran is more intuitive and easier to use than code-based ETL/ELT tools. The data modelling Fivetran performs makes the data more usable more quickly. Fivetran's dbt support and integration is unique.

Key Insights

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

Other Software Used

Snowflake, dbt (data build tool), from Fishtown Analytics, Sigma Computing

Likelihood to Recommend

[Fivetran is] very well suited when you are using popular and common data sources, such as the major ad platforms, and SaaS platforms such as Salesforce.
If the majority of your data sources are custom internal applications or databases, may be less value as you aren't leveraging the delivered connectors.

Fivetran makes ELT quick and easy

Overall Satisfaction with Fivetran