Fivetran Data Movement Platform
FivetranExternal reviews
458 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Great ETL tool
What do you like best about the product?
Fivetran is very easy to set up and get going. I've used it to try out new data sources and do one off data pulls. It's generally reliable, emailing the admin team when there are issues. Overall, it's the best ETL tool I've used to get data into my warehouse.
What do you dislike about the product?
We have a complicated advertising MCC that links up to Fivetran. Since the data in that MCC is often bad, it tends to delay the sync sometimes. That's the only issue I've had with the tool.
What problems is the product solving and how is that benefiting you?
As someone who works in Business Intelligence, but isn't a data engineer, Fivetran has helped me easily get access to the data I need to create reporting. I've been able to test new sources of data and run sample analysis in a very short period of time. It makes my overall process easier and faster.
One of the best cloud data integration/pipeline tools
What do you like best about the product?
Quick data replication with minimal lag. Very straight forward and easy to follow setup. Automated notifications if data is out of sync. Saved lot time integrating data from various sources in our environment to our data warehouse (Snowflake). Fivetran's incremental syncs work seamlessly and uses lower overhead and provides consistent replication of data. Fivetran works on the product improvement very rapidly and keeps us updated on the new features and improvements. Overall, a great product!
What do you dislike about the product?
Occasional delays happen with our connectors due to some changes done by Fivetran developers, without our knowledge and full resync times take really longer (1-2 days) for some connectors. Customer/technical support can do better job. Expensive in terms of cost when compared to other ETL/data pipelines available in the market.
What problems is the product solving and how is that benefiting you?
We saved lot time integrating data from various sources in our environment to our data warehouse (Snowflake). We can manage data syncs/ETLs without having to write/keep the code/jobs. Very quick setup process and is fully managed 24*7. Documentation on the connectors is also good...along with troubleshooting steps in case of any failures. we use different connectors that Fivetran offers and makes it easy for our reporting data preparation. Connectors which we use include...Oracle/SQL server/MongoDB/S3/Salesforce/Google analytics etc.
Recommendations to others considering the product:
If you are looking for a reliable product and value for the money, Fivetran is the product for data pipeline/ETL solution.We saved lot time integrating data from various sources in our environment to our data warehouse (Snowflake). We can manage data syncs/ETLs without having to write/keep the code/jobs. Very quick setup process and is fully managed 24*7. Documentation on the connectors is also good...along with troubleshooting steps in case of any failures. we use different connectors that Fivetran offers and makes it easy for our reporting data preparation. Connectors which we use include...Oracle/SQL server/MongoDB/S3/Salesforce/Google analytics etc. Quick data replication with minimal lag. Very straight forward and easy to follow setup. Automated notifications if data is out of sync. Saved lot time integrating data from various sources in our environment to our data warehouse (Snowflake). Fivetran's incremental syncs work seamlessly and uses lower overhead and provides consistent replication of data. Fivetran works on the product improvement very rapidly and keeps us updated on the new features and improvements. Overall, a great product!The solution is HIPAA compliant and provides connectors to pull data from multiple sources. The solution is able to track operations through logs, replicate data from the cloud to the warehouse and more.Fivetran is the smartest way to replicate data into your warehouse.
This tool became a game changer for our company
What do you like best about the product?
The simplicity of connecting the data sources and the transparent pricing model
What do you dislike about the product?
Previously one had to pay per connector, but now this problem is solved
What problems is the product solving and how is that benefiting you?
Replication of data from the various systems (production database, LinkedIn, Google Analytics) to Snowflake
Easy ETL
What do you like best about the product?
- Fivetran offers a strong selection of data sources. During our time using Fivetran, we haven't encountered a time in which a data source that we needed wasn't already being offered as a connector.
- There is a great interface for fine-grain selection of which tables within a schema to sync. It is easy to see which tables have been selected, and for some connectors, individual columns can be selected to be synced with the warehouse.
- The health of each pipeline is visualised clearly and it is easy to set up alerts/manually trigger updates. Monitoring is an important element of any ETL tool, and so far we've found it easy to stay on top of it with Fivetran. The UI itself is very easy to read and understand, whilst the automated alerts let you know of any issues that the pipelines are encountering.
- The customer service team have become far more responsive than when we initially joined, and the service has now become a big plus. A few months ago, one of our connectors ran into an issue - during this time Fivetran were incredibly helpful in keeping us up-to-date with the progress being made to fix it.
- There is a great interface for fine-grain selection of which tables within a schema to sync. It is easy to see which tables have been selected, and for some connectors, individual columns can be selected to be synced with the warehouse.
- The health of each pipeline is visualised clearly and it is easy to set up alerts/manually trigger updates. Monitoring is an important element of any ETL tool, and so far we've found it easy to stay on top of it with Fivetran. The UI itself is very easy to read and understand, whilst the automated alerts let you know of any issues that the pipelines are encountering.
- The customer service team have become far more responsive than when we initially joined, and the service has now become a big plus. A few months ago, one of our connectors ran into an issue - during this time Fivetran were incredibly helpful in keeping us up-to-date with the progress being made to fix it.
What do you dislike about the product?
Previously I would have said the response time for any queries, but this has improved drastically during our time as a Fivetran customer.
What problems is the product solving and how is that benefiting you?
Fivetran allows us to pull data from a number of different sources into our data warehouse efficiently. The transformation layer allows to perform additional data cleaning before exposing it to the end users.
Recommendations to others considering the product:
It's a strong option for handling the ETL process.
Fivetran helps us stay focused
What do you like best about the product?
We don't have to spend much time thinking about Fivetran and that's a great sign it's doing what we need it to do. Hooking up new connectors is typically quick and straightforward to do with solid documentation, then beyond that it's usually hands off from there. When we need to go in to check something, the dashboard is simple, yet provides all the information you really need.
It's handy that they take care of the modeling side in the data warehouse, which they then provide well-maintained and nicely detailed schema diagrams for. We've also gotten solid response times from support and they've helped push through some connector changes for us with reasonable turnaround.
It's handy that they take care of the modeling side in the data warehouse, which they then provide well-maintained and nicely detailed schema diagrams for. We've also gotten solid response times from support and they've helped push through some connector changes for us with reasonable turnaround.
What do you dislike about the product?
The recent change to usage based pricing has added an additional aspect we have to consider and watch, although they've done a pretty good job keeping it transparent (i.e. fivetran_log connector). However, I do wish we always had granular control of what data we want to pull in from every connector (currently only available to some) as that can play big part in costs.
Generally positive experience with all the connectors we've tried, but as you can imagine, some are more mature or stable than others. It's probably a good idea to thoroughly test them out first especially if you're going to be highly reliant on one or two of them.
Generally positive experience with all the connectors we've tried, but as you can imagine, some are more mature or stable than others. It's probably a good idea to thoroughly test them out first especially if you're going to be highly reliant on one or two of them.
What problems is the product solving and how is that benefiting you?
We use Fivetran to help us pull in data from other vendors into Snowflake...so our engineers don't have to. This means we don't have to worry about API integrations, deprecations, changes, or outages that can come up anytime. Ultimately, Fivetran helps us adapt to changes when it comes to vendor data. Whether those are changes vendors make to their API or new business requirements that brings in a new vendor, they're often able to take care of it for us so our team doesn't have to be distracted.
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
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.
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.
showing 201 - 210