We use Fivetran to build data engineering pipelines. It helps us do a lot of data transformation and data extraction.
Fivetran Data Movement Platform
FivetranExternal reviews
External reviews are not included in the AWS star rating for the product.
Helps to build data pipelines and save time but pricing is expensive
What is our primary use case?
How has it helped my organization?
Fivetran helps us save time and be more efficient because we do things with no-code/low-code.
What is most valuable?
The most important feature of the solution is its ability to build data pipelines in less time.
What needs improvement?
We experience cost issues because Fivetran is charged on a usage basis. When you reach a certain level, the tool should focus on reducing the costs. The solution is expensive when you are moving gigabytes and petabytes of data.
It should also focus more on REST APIs and webhooks.
For how long have I used the solution?
I have been using the solution for two years.
What do I think about the stability of the solution?
The solution is very stable and reliable.
What do I think about the scalability of the solution?
The product's scalability is high.
How are customer service and support?
Fivetran's technical support is average and can take weeks to respond.
How was the initial setup?
Fivetran's deployment is simple.
What other advice do I have?
I rate the solution a seven out of ten.
Fast and Easy integration from various Business tool to Data Lake/Warehouse
Row-based pricing.
Lots of integrations and destinations.
Might not be Fivetran fault, but more about the source of data.
Yet the sudden spikes for e.g. Hubspot monthly is kinda a bad surprise sometimes.
Very happy despite a rocky start
Fivetran - Expensive but Excellent
Fivetran Review
It is necessary for our service infrastructure
Even though it is difficult to analyze the perfomance of the product, when Fivetran synced, I can analyze a lot of values via Big Query.
Lots of connectors and easy to use
Fivetran makes things simple
An easy-to-set-up solution that can be used for bidirectional data synchronizations between systems
What is our primary use case?
We use Fivetran for bidirectional data synchronizations between systems.
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.