In my current project, the specific use case of Fivetran is bridging the gap between siloed data, allowing me to extract and have it in the same data warehouse. Fivetran works with its seamless connections to sources and destinations, helping to avoid reinventing extraction logic from scratch. Fivetran already has data models, so it pulls in data quickly, providing it all in the same data warehouse.
Fivetran Data Movement Platform
FivetranExternal reviews
456 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Has accelerated data integration workflows and supports seamless development of custom connectors
What is our primary use case?
What is most valuable?
I've worked extensively with Fivetran, mainly used for extraction purposes, and I've worked with the transformation element in it as well. Fivetran not only has built-in connectors but also provides SDK connectors, allowing us to develop our own connectors in an easy manner. I don't have to write raw Python scripts or dumping scripts; it offers straightforward examples and guidelines, making it much simpler to develop custom connectors inside Fivetran. We've been able to develop many custom connectors as well, which is unique and beneficial for having everything centralized instead of having those connectors located elsewhere.
One of the best features by Fivetran is its clean, simple, and intuitive UI. It includes a transformation section where I can deploy my DBT queries and scripts. It also supplies good tracking capabilities for billing estimates and user permissions, allowing for customization to the desired level. The number of connectors it has remains a standout feature, and within connectors, the options available are very helpful. Although it sometimes appears static due to its built-in nature, it offers good flexibility for data transformation and caching, which I appreciate because it saves us extensive script-writing time.
What needs improvement?
The experience of using SDK connectors can be improved, as it lacks computational power, which is an area that needs enhancement. Additionally, for some connections, I want more flexibility during ingestion, specifically for transformations needed beforehand. When we tried to use a built-in Oracle connector, it didn't allow for the tweaks we needed, which led us to the SDK connector route and caused delays in development.
For how long have I used the solution?
I've been working for almost four years in this field, and it has been a really great learning and challenging opportunity, allowing me to work on various different stacks and to learn and grow extensively.
What do I think about the stability of the solution?
In my experience, Fivetran is stable with very few instances of downtime or reliability issues, and overall, I am very happy with it.
What do I think about the scalability of the solution?
Fivetran's scalability has been tested effectively, and it has been working well for our organization's growing data needs. However, the performance with SDK connectors could be improved, as it took around 10 to 12 days to conduct historic ingestion for just two years, which I find unsatisfactory.
How are customer service and support?
Customer support from Fivetran is quite good; it's really nice and responsive. I am very happy with my experiences in reaching out to them.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
Before Fivetran, we used Skyvia, which is a no-code ETL tool. I also considered Data Factory as an alternative. However, I found Skyvia lacking in maturity and Data Factory better suited for enterprise solutions but limited in connectors. Scripting solutions demanded more work and included additional costs, which led to my decision to switch to Fivetran.
How was the initial setup?
My experience with pricing, setup costs, and licensing has been satisfactory; however, I notice that as row numbers increase significantly, it can get a bit more expensive. Overall, it's fairly reasonable.
What about the implementation team?
We see fewer employees needed due to Fivetran's efficiency, which translates to money saved, as employee wages are much higher compared to the costs associated with the software itself.
What was our ROI?
Fivetran provides time savings, cost reductions, and improvements in data quality. For example, in working with Shopify, we faced numerous errors and challenges with in-house complicated connectors. The time directly correlates to cost; when the time investment decreases, fewer developers are needed, which means significant savings. Generally, we have seen very few instances of data quality issues since implementing Fivetran.
Which other solutions did I evaluate?
What other advice do I have?
My advice for those looking to use Fivetran is to rely on its documentation, which is very straightforward and accurate. Avoid depending too much on AI for Fivetran issues; the dedicated documentation suffices for most inquiries. If problems arise, Fivetran's support team is quick to assist. I rate Fivetran 9 out of 10.
Fivetran data connectors helps in my daily work to pull data from different source and updates data
What do you like best about the product?
They are easy to use
It makes data implementation and integration easier
Maintenance of the data is easier
Saves time and efforts
They are multiple pre-built connectors
there is a community for the customer support
It makes data implementation and integration easier
Maintenance of the data is easier
Saves time and efforts
They are multiple pre-built connectors
there is a community for the customer support
What do you dislike about the product?
It maybe costly for the startup companies and small business.
The software delays due to frequency of use of huge amount of datas
Syncing of data fails on large data`s
The software delays due to frequency of use of huge amount of datas
Syncing of data fails on large data`s
What problems is the product solving and how is that benefiting you?
Fivetran makes moving and syncing data super easy. It handles updates and changes automatically, saves engineers time, and works well with custom connectors and dbt. Costs can go up with lots of data, but overall it’s a reliable, hassle-free solution
Reliable Data Sync with a Pricey Tag
What do you like best about the product?
I appreciate Fivetran's ease of setup and usage, which made integrating our systems straightforward. Its reliability and secure platform ensure smooth data synchronization across multiple databases. I value its robust networking capabilities and the helpful services it provides for SaaS applications. Additionally, it simplifies schema management with its flexible features and supports enhanced data delivery and performance.
What do you dislike about the product?
I find Fivetran's pricing to be quite expensive. If the cost could be reduced or there were more flexible pricing options available, it would be more accessible to a larger group of users.
What problems is the product solving and how is that benefiting you?
I use Fivetran to sync data across multiple databases effortlessly with a reliable and secure platform. It simplifies ETL processes, supports easy schema changes, and offers fast data delivery, enhancing my data management experience.
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?
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.
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.
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.
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.
Generous with intro, easy to use
What do you like best about the product?
The ease of use. Their supported connectors are a cinch to set up and it's nearly effortless to maintain
What do you dislike about the product?
Some services we use don't have supported connectors. I hope they continuously look at those using their custom SDK and consider creating official connectors for these use cases.
What problems is the product solving and how is that benefiting you?
Setting up syncs between our disparate data sources and our data lakehouse.
Saving time/money/effort rather than custom data engineers and pipelines
What do you like best about the product?
The trial component and working out how to scale, start moving some sources over and growing.
Option of terraform and APIs is great.
Option of terraform and APIs is great.
What do you dislike about the product?
Can't think of any, except that it is perhaps more pricey than other tools, but it is way more mature and easier to use, so can't fault it there.
What problems is the product solving and how is that benefiting you?
We do not have a data engineering team, and recently started our data journey, was blown away how quick and easy to get data into desired target (GCP in our case)
showing 1 - 10