We use Fivetran for bidirectional data synchronizations between systems.
Fivetran Data Movement Platform
FivetranExternal reviews
External reviews are not included in the AWS star rating for the product.
Data management made easy
Very easy to use and the team is super nice!
An easy-to-set-up solution that can be used for bidirectional data synchronizations between systems
What is our primary use case?
How has it helped my organization?
I didn't set up any transformation in Fivetran. I wanted Fivetran to take care of the log sequence number comparison between source and destination systems so that it would pick up only the data that needed to be synchronized, and it did it beautifully.
What is most valuable?
The most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized. You need to capture the in-source updates and digits from the source; this is the only information you want. You don't want to download the whole thing each time. Fivetran does this just beautifully.
What needs improvement?
Fivetran should add more connectors because its competitors, like Airbyte, have more connectors. All of these systems have a problem, namely that they are pure cloud player solutions. I often work in hybrid solutions where customers have on-prem things mixed with cloud things.
Pure cloud player solutions never provide a good solution for what is on-prem, which leads to a gap. When you look at systems such as ActiveBatch, they have a very, very strong on-prem platform. They are also looking at the web and cloud things, but they are not that good at the cloud things. So there is nothing that is equally good for both on-prem and cloud.
Fivetran should add a feature to connect to the SQL server on-prem.
For how long have I used the solution?
I have been using Fivetran for a month.
What do I think about the stability of the solution?
Fivetran is a very stable solution. After you set it up, you can forget about it. I rate Fivetran a nine out of ten for stability.
What was our ROI?
Fivetran saved me a lot of work. I could have hired a bunch of engineers to write Python's code for me, but Fivetran was already built. So, it was easier for me to focus on my line of business and purchase a commercial product without trying to replicate this myself in Python. That's not a return on investment; that is savings.
What other advice do I have?
I am using the latest version of Fivetran.
Fivetran is easy to set up. It took me one or two hours to set up my flow, and then I forgot about it. So for me, it's perfect because it doesn't take a lot of time. It's not like some other solutions where you need two weeks of engineering to get them to work.
I would advise users to try Fivetran before they commit to it.
When I compare Fivetran with Airbyte, I like Airbyte better than Fivetran.
Overall, I rate Fivetran an eight out of ten.
Breaks too often, unhelpful support, expensive
It takes days for support to respond to urgent issues
Some API methods have ridiculous designs, e.g. updating the schema: you have to perform 7 API calls in a row to achieve a single change in the config.
There's no API versioning; requests and responses just get updated.
Pricing is extreme. Self-hosted solutions, for example, Airbyte, are identical in terns of setup and maintenance efforts, but you only pay for hosting.
Last, but not least, it's not fast at all.
Very good experience
Better targeting
Good integrations and easy to navigate
Census makes transferring data to our tools very easy and transparent
A stable and scalable solution that needs improvement with pricing
What is our primary use case?
Real-time streaming and SAP are the primary use cases of the solution.
What is most valuable?
The simplicity of the solution is its valuable feature.
What needs improvement?
The solution is very expensive. I would like to have a better integration of the solution with Azure.
For how long have I used the solution?
I have been using the solution for one year.
What do I think about the stability of the solution?
It is a stable solution.
What do I think about the scalability of the solution?
It is a scalable solution that is recommended for only enterprise companies because small and medium companies do not have the expertise and money to run Fivetran.
How are customer service and support?
The technical support is good.
Which solution did I use previously and why did I switch?
How was the initial setup?
The solution is not easy to setup for a startup and SME but if an enterprise wants to do everything hands-on, it's okay for them. The deployment takes a couple of weeks to complete. Two people are needed for implementation.
What's my experience with pricing, setup cost, and licensing?
The licensing costs are extremely high for the usage of somebody who has one GB or two GB of usage per day for real-time traffic. There are many other players in the market which are similarly priced or competitively priced. On average per month, it used to come around 12,000-15,000 USD, which is very high.
What other advice do I have?
I rate the overall solution a seven out of ten.
Great App for us!
- It also gives your end-users the ability to go in and create their own filters on your core datasets, instead of created customized syncs/jobs for each person
- Finally, I also like that it means we can just sync relevant data to 3rd party apps, versus updating all users every day.
- With all the changes, things have been a little unstable lately, which is not ideal.
- It also gives your end-users the ability to go in and create their own filters on your core datasets, instead of created customized syncs/jobs for each person
- Finally, I also like that it means we can just sync relevant data to 3rd party apps, versus updating all users every day.