Item: Fivetran
Rating: 9
Author: Uddipan Mukherjee

Use Cases and Deployment Scope

Fivetran is used as a near real-time data replication solution between several source systems and organization-wide databases. Sources include traditional RDBMS, APIs, SAP Hana, etc. Fivetran is a reliable, and available service that did not result in any performance or data issues during its tenure with the data platform. It also supports some data transformations which are helpful to some use cases.

Pros and Cons

Near real time Data replication
Basic standardization
Availability of a wide variety of ingestion plugins

View based ingestion from RDBMS
Detailed Logging
API support

Most Important Features

Near realtime, available and reliable data replication
High quality ingestion with no data loss
Cost monitoring features

Return on Investment

Historical refresh cost
Absence of view to detailed progress logs

Alternatives Considered

Fivetran is a powerful data replication tool that supported use cases for organization-wide data platforms.

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

Matillion, dbt (data build tool), from Fishtown Analytics

Likelihood to Recommend

Fivetran is very well suited for any near real-time ingestion requirements for available plugins. Do not use it for complex data standardization as it only supports some features with that respect. Fivetran provides the required information on data volume, cost applicable, which is helpful to plan future ingestions. Sometimes historical refresh cost goes very high, but users also can be trained to save cost with appropriate measures.

Fivetran - next generation data replication

Overall Satisfaction with Fivetran