We use Fivetran for bidirectional data synchronizations between systems.
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.
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.
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.
I have been using Fivetran for a month.
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.
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.
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.