At our company, we are using Fivetran for change data capture and to sync between two different databases using the high volume replication feature.
Fivetran Data Movement Platform
FivetranExternal reviews
External reviews are not included in the AWS star rating for the product.
Excellent product & support!
Fivetran
Offers native connectivity and real-time syncing but lacks an in-line data quality checking feature
What is our primary use case?
What is most valuable?
Fivetran offers native connectivity with Sybase, which is highly valuable. The solution also allows real-time syncing and especially between Sybase and Snowflake, which is the solution's use case in our organization. Fivetran provides seamless integration without any data loss, and data changes are reflected in real time. Due to the change data capture capability, Fivetran allows the seamless data flow from one way to another.
What needs improvement?
Fivetran has multiple offerings and I have majorly worked with the high volume replication feature. An in-line data quality checking capability is missing in the solution. Whatever data gets synced or converted from one format to another as part of an ETL task using Fivetran, a data quality check cannot be performed.
As part of the data observation, when the data flows from the source to the target, there isn't a single interface provided by Fivetran to observe the data flow process, check for issues, and implement a comparison with historical transformation. The data observability could also be better in the product in terms of the gaps present.
For how long have I used the solution?
I have been using Fivetran for nearly two years.
What do I think about the stability of the solution?
The solution offers satisfying stability.
What do I think about the scalability of the solution?
Fivetran is reasonably scalable and easy to use and I haven't faced any challenges with scaling.
How are customer service and support?
The customer support from Fivetran is satisfying. I would rate customer support an eight out of ten.
How would you rate customer service and support?
Positive
How was the initial setup?
The on-prem deployment of Fivetran is a little bit complex, but the on-cloud deployment through the vendor's SaaS offering is comparatively easier and simpler. Just a couple of professionals are required to deploy Fivetran.
What's my experience with pricing, setup cost, and licensing?
I would rate the pricing a seven out of ten. The product is reasonably expensive.
What other advice do I have?
The solution provides a satisfying user experience by utilizing its automation capabilities. I would rate the product a seven out of ten.
Its easy to setup connectors
Very help iPaaS out of the box with no code set up
I also think Fivetran supports a very comprehensive set of connectors and sources and destinations.
Support is sometimes subpar because of offshoring to India, I have to wait 24 hours before getting a reply.
One stop shop for ETL
Has a great SysTrack load feature, but the real-time data needs improvement
What is most valuable?
SysTrack load is the best feature.
What needs improvement?
This solution needs to improve its real-time data and transformation availability. You have to extract a load before you can do any transformation.
Another improvement that can be made is with load extraction. This functionality should be implemented with obligating data and data masking.
For how long have I used the solution?
I have been using Fivetran for a couple of months.
What do I think about the stability of the solution?
The stability is an eight out of ten.
What's my experience with pricing, setup cost, and licensing?
I rate the pricing a six out of ten.
What other advice do I have?
Overall, I rate the solution a seven out of ten.
Plug and play solution that is budget friendly
Easy ETL!
Effortless ETL and Transforming Data Integration
Real time data sync up ensuring the data is synchronised and centralised warehouse is upto date.
It provides tools for managing and monitoring data integration which helps in optimising and track performance for better efficiency.