Fast and Easy integration from various Business tool to Data Lake/Warehouse
What do you like best about the product?
Super easy setup-and-forget system.
Row-based pricing.
Lots of integrations and destinations.
What do you dislike about the product?
Some bad surprises sometimes on number of rows synced.
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.
What problems is the product solving and how is that benefiting you?
Making all of our tools' (SFDC, Sheets, etc.) data queryable in a single place (Snowflake)
Very happy despite a rocky start
What do you like best about the product?
I found the Shopify connector to be the best of all the solutions I evaluated, and has worked really efficiently and smoothly since the implementation.The product notifications are also relevant, inisghtful and timeous while the portal interface is also clean, simple and easy to use. Overall, a really solid product at a great pricepoint for what I need.
What do you dislike about the product?
We had a bumpy start where the support provided during the trial phase was really not what I would have expected from a global company, however once the issues were resolved the solution has worked flawlessly.
What problems is the product solving and how is that benefiting you?
Creating customised reporting and analysis out of a platform like Shopify is not easy, which is something that Fivetran has allowed us to do in an efficient way. Simple, easy to use connection to move the data to an environment in which we have more control and flexibility is exactly what we wanted, and got!
Fivetran - Expensive but Excellent
What do you like best about the product?
Fivetran makes it incredibly easy to get started with replicating data from various source systems into data warehouse. I couldn't believe how quick and easy it was to select the tables and columns I wanted and then with a few clicks get the data replicating.
What do you dislike about the product?
Sometimes it's a bit glitchy, but usually they work things out -- even having a technical support technician jump into the account (after being granted access) and troubleshooting. There were a couple times we had to do a full re-sync or set things back up, but overall it has been easy and straightforward.
What problems is the product solving and how is that benefiting you?
Fivetran helps us solve the problem of replicating data from our source systems (primarily MySQL RDS on AWS) into our data warehouse (AWS Redshift). They helped us avoid bringing a data engineer on board to handle this, at a significant cost savings.
Fivetran Review
What do you like best about the product?
Very easy to setup connections and get up and running. The connectors are stable and the documentation is comprehensive and kept up to date.
What do you dislike about the product?
Managing spend takes some getting used to. You can easily end up spending more than you need to.
What problems is the product solving and how is that benefiting you?
Fivetran has allowed me to centalise my data into a data warehouse for reporting.
It is necessary for our service infrastructure
What do you like best about the product?
It is very helpful that I can integrate multiple product with my Big Query.
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.
What do you dislike about the product?
It is a little bit annoying that a lot of data would be synced and the cost would be so high depend of the service to sync. So, it is required to tune the table.
What problems is the product solving and how is that benefiting you?
Fivetran resolving the problem with data extraction of the service I use. Without Fivetran, it is needed to create API request by myself just for exporting data.
Lots of connectors and easy to use
What do you like best about the product?
Our criteria were the availability of SaaS connectors and ease of use, because we only wanted one extraction tool for everything to keep complexity low. Fivetran had a few connectors that nobody else had and the setup was simple with UI and programmatic options.
What do you dislike about the product?
Nothing of note. Back in the day, the pricing was steep with heavy use, but that has gotten better since.
What problems is the product solving and how is that benefiting you?
Syncing data from SaaS tools that our teams use to the data warehouse and analyse it together for richer insights not possible in those tools alone.
Fivetran makes things simple
What do you like best about the product?
Frees up engineering time on automated tasks
What do you dislike about the product?
Inconsistent pricing can be an issues sometimes
What problems is the product solving and how is that benefiting you?
Speed to delivery and data engineering time tired up on boring tasks
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.
Fivetran review
What do you like best about the product?
Its use is easy to understand with a modern structure that has provided solutions for data movement for better analysis, its attention is as desired in times and responses.
What do you dislike about the product?
It can be a bit expensive due to its high price plans that not everyone can afford this amount of money.
What problems is the product solving and how is that benefiting you?
Out-of-the-box data integration and data collection makes data analysis more detailed
Solid ELT solution, meets our data Integration needs.
What do you like best about the product?
The ability to transform data within the platform without requiring external tools or scripts. Fivetran has a large number of pre-built connectors, they cover a wide range of data sources, making it easy to integrate with different systems. Regardless of where our data is coming from, Fivetran has made the extraction process seamless and reliable, providing us with clean and structured data that we can use for our analytics needs.
What do you dislike about the product?
We've had scenarios when the sync process failed to complete successfully, causing some delays in our data pipeline. The process of troubleshooting the sync errors can be time-consuming and requires technical expertise, which could be a challenge for some organizations without dedicated data engineering resources.
What problems is the product solving and how is that benefiting you?
Fivetran streamlines the way we access and use data by providing a reliable ELT solution that reduces the need for manual intervention. Helps us focus on analyzing data and drawing insights that drive business decisions rather than spending time on manual data integration processes.