Fivetran Data Movement Platform
FivetranExternal reviews
806 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Simple self-serve no code data integration
What do you like best about the product?
As a SaaS platform, Fivetran eliminates the need for costly replication infrastructure and maintenance. There are many connectors for source and target systems which allows a whole range of possible integration scenarios. Getting up and running takes as little as 10 minutes with easy source (Connector) and target (Destination) configuration. The user interface is clean and informative. Historical loads transition seamlessly into incremental loads. Schema evolution between source and target schemas is handled by the sync automatically. There is also strong integration with dbt for post-load ELT transformations. Syncs can be configured to run as frequently as every 5 minutes, and data pipelines do not compete for resources, unlike some competitors. Security concerns are well-considered, with strong encryption in transit and at rest and a range of regulatory compliance. Documentation is also well written and comprehensive. The Monthly Active Record (MAR) pricing model bills for each primary key seen by Fivetran in a given month, allowing for unlimited record updates without additional cost in that month.
What do you dislike about the product?
Fivetran promote an ELT approach to data integration, which can limit your options for landing data into your target. In our case, we needed to be able to identify the source database within the landed data itself. Without pre-load transformation, we had to work around this by using database/schema naming conventions and extracting the source information in post load transformations.
What problems is the product solving and how is that benefiting you?
We aggregate data from 100s of SQL Server source databases into a Snowflake data warehouse for data analytics and machine learning.
Recommendations to others considering the product:
With Fivetran you can move your data around and get the data analytics and insights you need to make critical business decisions in a matter of minutes. Outsourcing the ongoing maintenance of infrastructure, code and connectors allows businesses to focus on what they do best, leaving these data integration concerns to the experts like Fivetran.
Best tool for extracting and loading data into data warehouses
What do you like best about the product?
Fivetran gives new users sufficient time to trial the product. There is a very thorough collection of built connectors, with option to request new ones. The documentation is one of the best I have seen. And, the team was very responsive and easy to do business with. I was notified by email of all errors and downtimes.
What do you dislike about the product?
A tool this good does come with a price tag. It is certainly not cheap. The pricing model is based on MAR, which is a different concept to wrap your head around with, but not too difficult to make sense.
What problems is the product solving and how is that benefiting you?
We use Fivetran to solve the data silo and reporting silo problems. With minimal effort, we were able to make data from multiple sources available in our selected destinations, ready for transformation. It's also a great relief to know that Fivetran does minimal necessary transformation with the data.
Recommendations to others considering the product:
Fivetran is the best fit for our use case, based on engineering capacity, budget, usage and etc. It is important to understand the pricing model before you sign the contract. Contact your Fivetran rep and ask as many questions as you need. From my experience, they are very responsive and helpful.
Fivetran great for QuickBooks Online data!
What do you like best about the product?
It's very easy to get started and also offers the ability to connect with custom API scripts.
What do you dislike about the product?
Only wish there were more native connectors for low-code apps like Airtable.
What problems is the product solving and how is that benefiting you?
We are using it to push QuickBooks Online data to a Google BigQuery data warehouse because you actually can't export all the QBO data there is with the CSV exports they expose in the web application. Because we're able to move QBO data into a data warehouse, we're now able to do incredible business intelligence platform visualizations.
Easy to use, very well documented data transferring solution
What do you like best about the product?
For their specific functionality, the documentation is excellent. Once the setup is completed, it simply works.
What do you dislike about the product?
So far, I haven't had any issues. Our only concern was about sending our data through a third party, but their security standards seemed ok
What problems is the product solving and how is that benefiting you?
Data migration into Snowflake
Recommendations to others considering the product:
Don't be afraid to contact technical support. They're friendly and very knowledgeable.
Modern way to do ELT!
What do you like best about the product?
Very easy connectivity to cloud systems!
What do you dislike about the product?
Better overall reporting of all ELT jobs
What problems is the product solving and how is that benefiting you?
There is no need for Integration engineers to do APIs between our many cloud systems.
Recommendations to others considering the product:
If you have many cloud databases to connect the FiveTran tool is amazing. Setup connections in under 30 minutes and start ingesting data. In the old days this took a month and a team!! This tool has made my small BI team really look great as we can ingest new data and get it into Looker FAST and accurately!
Fivetran has multiple integrations that saved our team ton of time
What do you like best about the product?
The ability to control the synchronization updates.
What do you dislike about the product?
Admin UI is a bit too simple. Fivetran is missing a more complex permissions system.
What problems is the product solving and how is that benefiting you?
Pulling data from FB and google analytics. Fivetran allows you to reduce the cost of ETL maintance.
VFM ETL Tool
What do you like best about the product?
Credit based system, instead of fixed monthly charges in major advantage. On successive sync, they charge only for delta, that is a huge plus, considering successive sync have less data as compared to first sync.
Other thing, they have a variety of connectors to fetch data from different sources.
Other thing, they have a variety of connectors to fetch data from different sources.
What do you dislike about the product?
Sometimes there were issues with connector data fetching
What problems is the product solving and how is that benefiting you?
We were trying to build eCommerce specific data analytics system. Instead of building our connectors and data pipeline. Fivetran offered that complex part to build our MVP, we can focus on the analytics part only.
Makes my job easy
What do you like best about the product?
Fivetran is intuitive and easy to use. Our data pipelines are reliable.
What do you dislike about the product?
Sometimes I need to resync tables. We hit volume limits in our saleforce sync and sometimes those loads fail.
What problems is the product solving and how is that benefiting you?
We don't need to spend our resources writing ETL pipelines
Fivetran does what it needs to do - extract and load data periodically - without much work
What do you like best about the product?
The onboarding was super quick. The UI is intuitive. The documentation is simple and accessible.
There is a wide variety of connectors. And for internal APIs or obscure SaaS apps, you can always write a custom connector through Cloud Functions hosted on AWS, GCP, or Azure.
Staff support has always been prompt.
There is a wide variety of connectors. And for internal APIs or obscure SaaS apps, you can always write a custom connector through Cloud Functions hosted on AWS, GCP, or Azure.
Staff support has always been prompt.
What do you dislike about the product?
It can be pricey. The pricing structure around MARs can be challenging to comprehend.
What problems is the product solving and how is that benefiting you?
We have automated the loading of data from various data sources into our warehouse daily and reliably. This lets us focus on building models instead of on having to build systems to extract data.
Fivetran Review
What do you like best about the product?
The simplicity of creating automated pipelines and the ability to integrate external data easily
What do you dislike about the product?
Unavailability of Google Drive as a data source
What problems is the product solving and how is that benefiting you?
Automate and save time on ETL/ELT, looked into database replication as well
Recommendations to others considering the product:
Fivetran is revolutionizing the ETL/ELT space. I look upon it as a gamechanger when it comes to the modern data stack.
showing 241 - 250