Fivetran Data Movement Platform

What do you like best about the product?

It’s easy to use and straightforward—simple enough for a marketer to pick up and use without much effort.

What do you dislike about the product?

It occasionally breaks down and requires me to relink it.

What problems is the product solving and how is that benefiting you?

Faster business analytics deliver real-time data that helps inform my marketing decisions.

What do you like best about the product?

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.

What do you dislike about the product?

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 :(

What problems is the product solving and how is that benefiting you?

ETL!!! For like 1gb of data.

What do you like best about the product?

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.

What do you dislike about the product?

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.

What problems is the product solving and how is that benefiting you?

I use Fivetran to create pipelines from our Sharepoint site and ERP system. It makes setting up connectors straightforward with great documentation, ensuring security with Microsoft Entra, and provides reliable notifications for pipeline issues.

What do you like best about the product?

It's a reliable piece of infrastructure that I can have faith it is well engineered and supported.

What do you dislike about the product?

Pricing often seems unfair. Especially when it comes time for annual renewals, it always feels like we're playing a game where Fivetran is our opponent and is constantly making new rules.

What problems is the product solving and how is that benefiting you?

Free-tier connectors that I would pay more for elsewhere.

What do you like best about the product?

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.

What do you dislike about the product?

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.

What problems is the product solving and how is that benefiting you?

Fivetran lets us access clients' CRM data directly, avoiding AWS S3 uploads, and refresh data throughout the day. Its grace period for schema changes helped us explore data flows without billing worries.

What do you like best about the product?

Seamless connectivity and quick support. We haven’t had many incidents or much downtime, which has been great. The alerts and monitoring are solid and help us stay on top of things.

What do you dislike about the product?

The costs have increased significantly. Also, the Shopify connector doesn’t let me select or deselect columns, which is a major limitation.

What problems is the product solving and how is that benefiting you?

It lets us connect to multiple data sources and bring everything into an ingestible format for our data warehouse, without having to build new connectors ourselves.

What do you like best about the product?

Easy to set it up for several data sources and mostly reliable functionality

What do you dislike about the product?

In few data sources CDC setup, data loss could occur and it takes lot of time to debug the root cause. for ex: at purpose financial, i had bad experiecne with Fivetran

What problems is the product solving and how is that benefiting you?

CDC replicating jira primarily. Team said they had several issues with salesforces setup hence switched to databricks pysparkk jobs

What do you like best about the product?

I found it easy to learn how to set up pushing important data into our CRM

What do you dislike about the product?

Honestly for me, the downside is the interface, I sometimes find it hard to look up and find things based on certain fields, etc

What problems is the product solving and how is that benefiting you?

It hasn't necessarily solved anything but helped a lot with our data pushes

What do you like best about the product?

Three things -

#1 is the wide availability of connectors across very different platforms. It just so easier to link everything via fivetran and setup ingestion process
#2 - Very easy to navigate across different features for business users
#3 - Fivetran support is very responsisve and always available to help

What do you dislike about the product?

Performance can be better - especially on ingesting very large tables in incremental mode.

What problems is the product solving and how is that benefiting you?

- Collecting files/data from clients in standard formats automatically been a pain for us for long term - especially for smaller clients who may not have data layers beyond their data warehouse. Fivetran integrations helped us to setup efficient pipelines rather than dumping everything to us and build ETL to clearn up

What do you like best about the product?

I like how it transforms data from multiple databases into a single, resolvable, SQL-like dataset, including data coming from NoSQL databases.

What do you dislike about the product?

By default, it should allow sync intervals of less than 15 minutes and offer more granularity in how data is synced. The current three options (only new columns, new data, etc.) aren’t very helpful. We should also have the ability to periodically run a full data sync.

What problems is the product solving and how is that benefiting you?

We have a lot of data spread across multiple databases that needs to be consolidated and prepared so we can run analytics on it.