Fivetran Data Movement Platform
FivetranExternal reviews
803 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Fivetran is magic--transports what you want, all the time, with very little effort
What do you like best about the product?
Works with everything I want to bring data from, delivers it consistently (to BigQuery for me), and just works.
What do you dislike about the product?
It's not the simplest thing to write your own functions to integrate from APIs that aren't natively supported, but at least it's an option, and it works well.
What problems is the product solving and how is that benefiting you?
We funnel all of the data we need (from SFTP sites, from Google Sheets, from DynamoDB, from Cognito, from Zendesk, from Five9, etc etc) to one place to query. It's the magical data lake transportation engine that you need.
Most Reliable Managed ETL Service
What do you like best about the product?
Probably the most reliable ETL as a service. Support is quick when there are issues with the data, or when we have general questions.
What do you dislike about the product?
"Opaque" box-ish. Problems need to be resolved through Fivetran Support.
What problems is the product solving and how is that benefiting you?
Quick ETL pipelines. Especially when we aren't doing anything crazy to the data coming in, or for data sets that are low impact / high effort.
Recommendations to others considering the product:
Great for quick pipelines. If you do a lot of in database transformations, and don't have heavy security needs (encrypting pii, etc), it's a great tool. Or if you need data in a db quickly and cheaply, they are definitely the way to go
Fivetran Makes Loading Data Easy
What do you like best about the product?
There are multiple existing connectors that make it easy to connect different systems and load data into our warehouse.
The connectors are easy to configure and you can get up and running really quickly.
Alerts show when there are issues with your connectors that need your attention.
You also get email notifications when a connector is delayed and when it resumes, so you can always be on top of things.
When there is an issue, support is there to help you to try to find a solution.
The connectors are easy to configure and you can get up and running really quickly.
Alerts show when there are issues with your connectors that need your attention.
You also get email notifications when a connector is delayed and when it resumes, so you can always be on top of things.
When there is an issue, support is there to help you to try to find a solution.
What do you dislike about the product?
When you run into an issue, it is not always easy to understand what is causing the error. When it works, it just works. But, when it doesn't, it can be difficult to understand the issue without trial and error.
Sometimes, it is just easier to ask support to help you troubleshoot, even though it can take a bit more time to get a solution to your problem.
Sometimes, it is just easier to ask support to help you troubleshoot, even though it can take a bit more time to get a solution to your problem.
What problems is the product solving and how is that benefiting you?
Connecting multiple systems and some Google Sheets to load all our data into our data warehouse.
Fivetran works as our loader in our ELT BI stack.
We use it to load our data from many systems, including our custom-built professional services management tool using the SQL Server connector, Jira, Hubspot and many others. The data is loaded straight into our Snowflake database and it's easy to query for new data with the timestamps that Fivetran adds to each row.
Fivetran works as our loader in our ELT BI stack.
We use it to load our data from many systems, including our custom-built professional services management tool using the SQL Server connector, Jira, Hubspot and many others. The data is loaded straight into our Snowflake database and it's easy to query for new data with the timestamps that Fivetran adds to each row.
Recommendations to others considering the product:
It is great at what it does.
Easy
What do you like best about the product?
An Integration with multiple sub-systems
What do you dislike about the product?
I think the user interface could be improved
What problems is the product solving and how is that benefiting you?
Great integration to centralize our business information from CRM, Jira, production data and some Google sheets
Resilient and capable pipelining tool
What do you like best about the product?
Wide variety of connectors, config vs. code, a new compelling pricing model, excellent support. Also a high bar for security has been met for our usage given the architecture.
What do you dislike about the product?
So far there has been little to dislike, support cases have been rare and well attended to. Pricing under the older connector based model was starting to look prohibitive but the consumption model has eliminated that concern. Commercial processes are somewhat immature.
What problems is the product solving and how is that benefiting you?
Quick, secure and easy pipelining of SaaS and DB sources to our Snowflake instances. Very positive cost benefit by displacing labour and license costs for other data integraton tools
Recommendations to others considering the product:
Evaluate through a trial, consider architecture in context of security
Fivetran for Data Replication
What do you like best about the product?
It was quick and easy to get started with Fivetran and concentrate on just what I needed to know when working with our data pipelines. Fivetran sends helpful notifications about data syncs when they fail or get delayed. I've also had positive experiences with their support team as well; I got quick, helpful responses when I've needed to contact them with questions or concerns in the past.
What do you dislike about the product?
Fivetran is unable to capture certain functions, like cascading deletes, which led to some issues using it for replication as we've relied heavily on cascade deletes in the past and updating our entire application to not use them would take significant amounts work. You can use a post-load transformation to mitigate this and mark certain records as deleted as a workaround. We also discovered an issue where duplicate rows with entirely identical information weren't getting synced over properly--only the first row would get replicated and the others were being ignored as duplicates of it. This caused some table row counts to not match up when we audited the replicated data against the source database. Including primary keys on your tables prevents this, but it can be a problem for older tables that were not set up properly.
What problems is the product solving and how is that benefiting you?
We are using Fivetran to replicate our transactional databases and allow our data science team to perform more intensive operations without affecting production environments than we could otherwise. It's also allowed us to leverage more powerful tools like Snowflake for generating data insights which helps with performance constraints or lack of historical data.
Recommendations to others considering the product:
Be sure to read about which functions aren't supported when considering your Fivetran needs so you don't run into a few of the small pains we discovered later.
Simple setup and good UI
What do you like best about the product?
FiveTran is a good solution for our needs. It was easy to connect to our various data sources and start getting the data into Snowflake. We connected to 10 different sources in one weekend to get started.
What do you dislike about the product?
At times the error messages were helpful in figuring out the issue.
What problems is the product solving and how is that benefiting you?
Getting all data from various data sources into our Data Warehouse. It was simple to set up and their UI is good. The updates and alerts are helpful too.
Recommendations to others considering the product:
It is a great solution to connect with your data warehouse.
On the Train
What do you like best about the product?
It's easy to use and support is always there for you if you need it. It also integrated with other systems that we use for data.
What do you dislike about the product?
I don't have any problems so far with it. I wish it has SCIM provisioning though
What problems is the product solving and how is that benefiting you?
I don't have any problems so far with it. Can't complain.
Go to product for Data Replication and ELT
What do you like best about the product?
Variety of Connectors available and Ease of setup
Fully Managed Pipeline
DBT Package Support
14-day free trial
Fully Managed Pipeline
DBT Package Support
14-day free trial
What do you dislike about the product?
The Load component of ELT is very well handled by Fivetran but more features need to be added on T that is transformation. Recently, DBT Transformations are supported which is a big value add.
What problems is the product solving and how is that benefiting you?
Fivetran makes it easy to load data quickly in data warehouse with little to no maintenance required.
Benefits:
Ease of replication
Availability of a variety of connectors
Good customer support
Fully managed Pipeline
Benefits:
Ease of replication
Availability of a variety of connectors
Good customer support
Fully managed Pipeline
Recommendations to others considering the product:
Fivetran makes it easy to load data without requiring an army of technical resources.
Ease of use and setup makes it a go-to product for data replication for any company.
Ease of use and setup makes it a go-to product for data replication for any company.
Best Replication Tool
What do you like best about the product?
1. Wide range of connectors
2. Dynamic column creation in Target if source add some column
3. SQL DB CDC option
2. Dynamic column creation in Target if source add some column
3. SQL DB CDC option
What do you dislike about the product?
1. Errors are not user friendly.
2. Transformation option only available for SQL DB
2. Transformation option only available for SQL DB
What problems is the product solving and how is that benefiting you?
Migrated our Tradition ETL system to ELT. Fivetran helped us in migrationg from ETL to ELT.
Raw data into datalake (Snowfalke) by just few just few clicks
Raw data into datalake (Snowfalke) by just few just few clicks
showing 751 - 760