Fivetran - next generation data replication
Rating: 9 out of 10
IncentivizedUse 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
- Near real time Data replication
- Basic standardization
- Availability of a wide variety of ingestion plugins
Cons
- View based ingestion from RDBMS
- Detailed Logging
- API support
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.
UM
Uddipan Mukherjee
Big Data Specialist in Engineering at Autodesk (Computer Software, 10,001+ employees)
Vetted Review
2 years of experience