The usual use cases for Fivetran that I work with involve real-time replication from Oracle Fusion, Oracle DB, and some of the APIs. I also work with replication from S3.
Fivetran Data Movement Platform
FivetranReviews from AWS customer
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
454 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Real-time data replication and integration streamline processes and enhance productivity
What is our primary use case?
What is most valuable?
The most valuable feature of Fivetran so far is the data replication. The real-time data replication is what I see best in the market where it reduces the overhead of customers needing to maintain the pipeline. Even when an error occurs, it automatically tries to solve the issue without manual interaction needed.
The effectiveness of Fivetran's pre-built connectors in enhancing my customer's productivity is significant because everything is easily configurable. The documentation is very clear, so there's no difficulty in finding the necessary steps. Everything is pre-documented. The pre-built connectors that are available are excellent. Most functionalities are covered, and in most cases, it works according to expectations.
What needs improvement?
If Fivetran can build in more transformations, that would be really helpful in my opinion.
For how long have I used the solution?
I have been using Fivetran collectively based on project requirements. I work with AWS, GCP, Snowflake, and Fivetran as part of my experience. My experience with Fivetran specifically extends to about two to three years, depending on project requirements.
What was my experience with deployment of the solution?
I have not experienced any challenges with deployment.
What do I think about the stability of the solution?
From my experience, Fivetran is very reliable. They have 99.9% accuracy on the data load and they maintain transparency. When the data is loaded, they clear it from their storage, keeping only metadata for MAR calculation and pricing purposes.
How are customer service and support?
I often communicate with the technical support of Fivetran whenever we encounter issues. I would rate them a seven. If they could provide support more quickly, that would be great.
How would you rate customer service and support?
Positive
How was the initial setup?
I usually participate in the initial setup and deployment of Fivetran. I handle the solutioning from start to end.
What other advice do I have?
I don't use Fivetran's automated ETL feature, but after loading, we use dbt for the transformation.
I have not used Fivetran's Schema Drift Management feature.
The integration with data warehouses such as Snowflake and BigQuery has been successful. Fivetran has clear documentation on configuration for both warehouses.
Regarding pricing, Fivetran uses MAR pricing, which I would consider moderate. The pricing consideration ultimately depends on the project budget since the client is responsible for payment while I implement the solution.
On a scale of 1-10, I rate Fivetran a 9.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Google
Great set-it-and-forget-it solution for ELT workloads
What do you like best about the product?
Huge connector library and "it just works".
What do you dislike about the product?
You have to be careful about how many rows you are loading, given the Monthly Active Rows pricing model, which can get expensive quickly for large data sources.
What problems is the product solving and how is that benefiting you?
Allowing me to load my data sources into the warehouse so I can focus on building data models from raw data, rather than on building pipelines that load raw data. Allows me to skip having to build the extract and load step of ELT myself.
Good for large datasets - limited in terms of controls
What do you like best about the product?
It does effectively pull large data sets.
Integrations with various platforms
Integrations with various platforms
What do you dislike about the product?
Inability to schedule pulls, has to be every 24h. (Not necessarily for weekly / monthly reports so it seems excessive).
For CM360 it is difficult to pull 'Seat' or 'Network' as a dimension.
For CM360 it is difficult to pull 'Seat' or 'Network' as a dimension.
What problems is the product solving and how is that benefiting you?
It supports me in reporting in bulk - ultimately extracting large datasets and improving efficiency by saving time
Fivetran is Awesome.
What do you like best about the product?
Fivetran is super easy to setup and use. Mostly set and forget especially for known / existing connectors.
What do you dislike about the product?
Some connector doesn't fail as elegantly such as showing existing credentials that isn't working.
What problems is the product solving and how is that benefiting you?
I do not need a dedicated data engineer to babysit the processes because we have FiveTran.
Fivetran Is An Excellent Data Syncing Software
What do you like best about the product?
1. Great extended support for google sheets , even on cell group level. It is easier to manage scd metadata with this feature.
2. Timely sync of data with less failures acroos various connections.
3. Support for almost every other software that are used by various enterprises.This gives freedom to be in one integrator and sync data from all softwares.
2. Timely sync of data with less failures acroos various connections.
3. Support for almost every other software that are used by various enterprises.This gives freedom to be in one integrator and sync data from all softwares.
What do you dislike about the product?
The Schema section in connection is a bit slow but that is understandable.It would be good if the schema is pre fetched and stored runtime so it will be easier while editing setups.
What problems is the product solving and how is that benefiting you?
We have around 50 different places company wide from where we need to sync data into warehouse on an hourly basis.Fivetran does a great job by timely syncing without delay.
The setup for any connection is very quick and easy which helps whole team to seamlessly create connections and sync various data.The Incremental/historical data sync feature is great.
The setup for any connection is very quick and easy which helps whole team to seamlessly create connections and sync various data.The Incremental/historical data sync feature is great.
Good Product -- Slow to pivot
What do you like best about the product?
We have a wide variety of source systems we need to extract data from. For 90+% of these FiveTran does the trick. Setup is easy and there isn't much to manage once set up.
What do you dislike about the product?
There is a known issue with Business Central connectors. We have been working with them for months trying to get it fixed or even get a timeline and we continue to be flying blind. This is pretty critical to our business and I'm sure with others using Microsoft Business Central so I wish they would be more communicative about this.
What problems is the product solving and how is that benefiting you?
We use this to pull in data from many sources and load them into one consolidated warehouse.
Enhance your ingestion process by more than 10x
What do you like best about the product?
- The speed and pace of the tool
- The overall deployment and implementation is extremely easy
- The number of available integrations is huge and it will cover most of your ingestion needs
- How well-organized their schemas are
- Usage and pricing is straightforward
- The Fivetran account reps and support are so well versed with their tool and they are always so supportive to help
- The overall deployment and implementation is extremely easy
- The number of available integrations is huge and it will cover most of your ingestion needs
- How well-organized their schemas are
- Usage and pricing is straightforward
- The Fivetran account reps and support are so well versed with their tool and they are always so supportive to help
What do you dislike about the product?
- Contracting can be a bit tricky
- It can become costly if you turn SCD Type 2 on but its not really on Fivetran
- It can become costly if you turn SCD Type 2 on but its not really on Fivetran
What problems is the product solving and how is that benefiting you?
The overall speed of building ingestion pipelines is extremely high and their documentation on schemas brings excellent clarity for all stakeholders.
An amazing no-code out of the box data integration solution
What do you like best about the product?
I have been using Fivetran for over a year now and I love how easy it is to simply plug and play when it comes to connecting to almost any external SaaS platforms out there, saving us precious business time and resources.
I heavily rely on Fivertran to collect data from offline spreadsheets scattered across the business into one place by using the out of the box Sharepoint connector. Once set up, there is zero effort from the user to automate the entire data pipeline and easily channel the data into one place for analysis, saving me hours of VB coding!
Also love the fact that Fivetran guys are constantly adding newer connectors that I keep an eye on to try these out (business case depending) .
Overall, an extremely no-code solution for anyone who wants to automate their data pipeline with minimum effort.
I heavily rely on Fivertran to collect data from offline spreadsheets scattered across the business into one place by using the out of the box Sharepoint connector. Once set up, there is zero effort from the user to automate the entire data pipeline and easily channel the data into one place for analysis, saving me hours of VB coding!
Also love the fact that Fivetran guys are constantly adding newer connectors that I keep an eye on to try these out (business case depending) .
Overall, an extremely no-code solution for anyone who wants to automate their data pipeline with minimum effort.
What do you dislike about the product?
Nothing to dislike apart from the wait to have newer connectors added to their existing collection.
What problems is the product solving and how is that benefiting you?
Fivetran is saving me hours of VB coding when extracting data from excel and google spreadsheets from SharePoint sites across the business. The SharePoint connector is allowing me to spend more time analyzing the data and delivering the insights to the end users rather than to wrestle with the spreadsheets and get that data into one place.
More so I have started using a few other out of the box connectors recently such as Google Ads, Reddit and Wrike, which is amazing as its giving me data that otherwise would be very difficult to API into.
More so I have started using a few other out of the box connectors recently such as Google Ads, Reddit and Wrike, which is amazing as its giving me data that otherwise would be very difficult to API into.
Fivetran enables those who are not data engineers to access data they need
What do you like best about the product?
I can connect data from online marketing channels within a few clicks.
What do you dislike about the product?
Whenever I've experienced connection issues, the instructions to resolve this were not very clear.
What problems is the product solving and how is that benefiting you?
As an online marketer, I've always struggled with connected performance marketing channel data to one singular source. Fivetran now allows me to do this within a few clicks for the top performance marketing channels.
Really easy to use and fantastic customer support
What do you like best about the product?
Customer support and ease to set up connectors.
What do you dislike about the product?
The pricing can change and cause significant increases. I.e. DBT transformations which were suddenly charged.
What problems is the product solving and how is that benefiting you?
Easy data engineering pipeline for some of our key databases.
showing 1 - 10