EDIT: I spoke with their product success team post-review and they genuinely did try to solve my problem, but they confirmed we were using the product correctly.

For event based systems like ours at Potions (we're an email product, kind of like Mailchimp on auto-pilot) we emit a lot of "small" event data like opens/clicks, and that tends to eat up MARs pretty fast. Better to build the solution in-house in these cases. Fivetran is probably better for lower volume/larger row data.

Their pricing hits an interesting "logarithmic curve" that we seemed to be nearing the peak of. I'd imagine folks with more volume & revenue than us might be fine using it, so I'm bumping my review to a 4. Review collected by and hosted on G2.com.

I still think small company pricing should be a lottttt more generous at our data volume; this has gotta be a rounding error of volume for you guys :( Review collected by and hosted on G2.com.

What I appreciate most about Fivetran is that it's a no-code platform. During setup, there's no need to write custom logic for incremental loads, schema drift handling, or ingestion tuning — these are all pre-built and handled out of the box. Post-configuration, the platform is largely self-monitoring: silent failures are eliminated since you're automatically alerted when a source system goes down, and most of the pipeline runs without manual intervention. It also offers ready-made connectors for the majority of widely-used software tools, which significantly reduces integration overhead. Review collected by and hosted on G2.com.

Pricing can become a significant concern, especially for high-volume source systems like Oracle, since Fivetran's consumption-based model (tied to monthly active rows) scales quickly as record counts grow — costs can feel disproportionate for large, transaction-heavy databases. Review collected by and hosted on G2.com.

I use Fivetran regularly to manage our data integrations, especially connecting Google Sheets with our warehouse. One major issue we had was operations staff deleting sheet rows; Fivetran solved this instantly by automatically providing the _fivetran_deleted boolean column, giving us full historical visibility.

The UI/UX is intuitive and clean, making setup completely no-code. In terms of performance, syncs are fast, reliable, and handle automatic schema changes effortlessly. The support and onboarding experience was smooth with clear documentation. Overall, the ROI is massive because it saves our engineering team hours of manual pipeline work each week, and the automated metadata scheduling almost feels like having built-in intelligence monitoring our data integrity! Review collected by and hosted on G2.com.

One thing I dislike is how Fivetran handles column ordering during syncs, particularly with Google Sheets connectors. It doesn't preserve the original column order from the source sheet, often reorganizing them alphabetically or dynamically in the destination table. While it doesn't break the data itself, it makes quick manual checks and SQL queries slightly annoying when you expect columns in the same layout as the source. Additionally, the pricing can scale up quickly if you have high-volume tables with frequent updates. Review collected by and hosted on G2.com.

What I like most about Fivetran is how easy it is to use and how little maintenance it needs. The UI is straightforward, and setting up integrations with tools like Salesforce and Marketo is pretty simple. The syncs are generally reliable and perform well, even with large amounts of data. It saves our team a lot of time compared with building and maintaining pipelines ourselves, so the ROI is clear. The documentation and support have also been helpful whenever we run into an issue. I haven’t used many of the AI features yet, but the automated schema handling and monitoring already reduce a lot of manual work. Review collected by and hosted on G2.com.

The biggest downside is the pricing, which can be hard to predict when data volume grows. Most connectors work well, but when a sync fails, the error message is sometimes too technical or not specific enough, so troubleshooting can take longer than expected. Support is helpful, although response times can vary. I’d also like to see smarter monitoring that flags unusual sync behavior and explains the likely cause before it becomes a bigger issue. Review collected by and hosted on G2.com.

I like Fivetran for its ease of use, security, and robustness. Setting up Fivetran connectors is straightforward with good documentation, which makes it very easy to use. I really appreciate the enterprise-level security with Microsoft Entra and OData integration, as it gives us confidence that our data is safe. Additionally, Fivetran connectors have been very reliable, and I find it very helpful that we are instantly notified if there are any pipeline issues. The cost, ease of use, and better audit trails were significant factors for us switching from Openflow to Fivetran. Review collected by and hosted on G2.com.

On the email connector, I wish there was support for HTML or JSON body rather than just attachments. Also, I'd like to see support for custom tables on the Acumatica connector. Review collected by and hosted on G2.com.

The 2 best things that I appreciate with Fivetran - Ease of set up through an easy to use UI and robust extraction. We have some data sources that are incredibly large and fivetran was able to replicate the data in our warehouse. No other integrations have been able to handle the work loads Review collected by and hosted on G2.com.

the only downside has been price. The tool is significantly more expensive than any other competitor. Review collected by and hosted on G2.com.

I use Fivetran for ingesting data from our source systems to our data warehouse, mainly for Salesforce, Jira, and Netsuite. I like that it's pretty easy to use, and we rarely experience downtime. I can count on one hand the number of times Fivetran tables did not match our source system, and a simple historical resync resolved this. It's rarely down as a service, and the interface is easy to use, making setting up a new connector a synch. The initial setup of Fivetran was easy. Review collected by and hosted on G2.com.

The cost structure is extremely confusing. MAR is a difficult concept to get in your head. Cost should be easier for the customer to understand. How about you charge based on the number of syncs or something simpler to explain to your Finance team. It is also not the cheapest ETL tool on the market--it may be the most expensive. Review collected by and hosted on G2.com.

I like that for the first 14 days, Fivetran offers a grace period where I can change the schema as much as needed, which really helped us in scoping out our requirements without being billed for just trying to understand the data. This feature allowed us to explore how the entire data flow would look like in the future. It's also great that instead of manually dumping data into our AWS S3, Fivetran handles that for us, which feels like a Quality of Life upgrade. Additionally, I found the initial setup to be extremely easy. Overall, it's one of the smoother tools I've used recently. Review collected by and hosted on G2.com.

Initially, I had a complaint that it does not allow us to send data back to the client's CRM, but they have solved that recently. No other major complaints. Maybe one more thing - I'm not sure if this is already there - but having an API that can be integrated with other applications like Slack or Databricks, so we can trigger system syncs without opening the system. Review collected by and hosted on G2.com.

I like the overall dashboard with its capabilities that let me explore different connectors and the extensive area of native connectors, which means I don't have to write my own custom logic all the time. It’s great that, while I don't always have to worry about custom logic, Fivetran still provides the flexibility I need to write custom logic and fetch data from various sources. The ease with which I can set up connectors using just credentials, and the fact that the data flows into my destination, is great. The setup process for multiple connectors, whether native or custom, has mostly been flawless with the existing documentation and CLI tooling. Review collected by and hosted on G2.com.

So some of the things that I feel, Fivetran needs improvement on are like the odd start time or the cold start time that it generally takes, where if things had been on a much more active system, they would have been much faster than how it takes right now. I also feel that some requirements like the ability to publish custom connectors, even though it's something that has been actively worked on by the product management team, could be improved. Additionally, there are issues with the absurd and some RDS destinations that could be resolved to make things better. Review collected by and hosted on G2.com.

I think Fivetran is very easy to set up. You just need to share your API key and the connections, and then choose the data tables that you want. What I really like is that the data gets ingested into Snowflake without any code. It's quite straightforward, and I don't see any problems with the process. Review collected by and hosted on G2.com.

The only problem I have is with the cost. Also, recently I observed that Fivetran introduced some options where it adds transformed tables by itself without us asking for them, which initially caused us a bit of struggle in figuring out how to stop it. My recommendation would be to give notice of any changes and not to add those tables by default. Instead, provide an option for us to choose them. Review collected by and hosted on G2.com.