Fivetran is used as an ingestion tool to move data between different sources and destinations. It orchestrates a series of pipelines that can be easily set up manually without any technical experience. These pipelines can run daily according to a specific schedule, depending on the licensing level. Fivetran addresses schema changes and updates destination tables unless there's a major difference, which is helpful in integrating systems from third parties.
Fivetran Data Movement Platform
FivetranExternal reviews
External reviews are not included in the AWS star rating for the product.
Simplified data tracing with reduced maintenance and more automation
What is our primary use case?
How has it helped my organization?
Before using Fivetran, most integrations were done manually, leading to a lead time of four to eight weeks for a new connection. Now, I can set up new connections in anywhere from a day to a week and a half, reducing data ingestion lead times by sixty to eighty percent.
There is a lot less maintenance to do on the pipelines, which has freed up development hours by about twenty percent. Overall, there's a big gain in development hours and less time maintaining data.
What is most valuable?
The simplicity and scalability are the strongest features of Fivetran. The learning curve is not steep, making it easy to get accustomed to. It's transparent in understanding when something fails, and the logging is detailed, which helps in auditing and accessing information rapidly.
For scalability, Fivetran charges less per row the more you use it, allowing you to move more data economically as you set up additional data pipelines.
What needs improvement?
The biggest area for improvement is in customization, particularly in how Fivetran socializes its tools. Many features like deploying Fivetran on-premises for security purposes or using connectors specific to systems like SAP are not well communicated. New users might not be aware of these features due to the lack of socialization when there are new releases or updates.
For how long have I used the solution?
I have been using the solution for about four years.
What do I think about the stability of the solution?
I would rate the stability a nine out of ten. I have never had an issue with downtime at all, though I have encountered technical issues using the API in a more advanced fashion for custom setups.
What do I think about the scalability of the solution?
I rate the scalability as a solid nine. All you have to do is plug in a new data source, which contributes to your quota for different plans. Fivetran also provides flexibility in managing data ingestion costs through different plans.
How are customer service and support?
The customer service is very good and thorough, however, it can be slow, usually taking about three to five business days for a response. Generally, I would rate it a seven out of ten because of this lead time.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
Before Fivetran, everything was developed by hand using Python. This switch to Fivetran was a big improvement.
How was the initial setup?
The initial setup for the standard cloud licenses is straightforward and simple. It's a matter of connecting data sources to destinations, which Fivetran's platform largely automates once you input the correct information.
What about the implementation team?
I handled the initial deployment myself.
What was our ROI?
Fivetran has drastically reduced the lead time for setting up new connections to one day to one and a half weeks, down from four to eight weeks. It has also decreased the time required for pipeline maintenance, resulting in a gain of sixty to seventy percent more development hours.
What's my experience with pricing, setup cost, and licensing?
The pricing is based on how much data is ingested, not on the number of rows. The tool's features expand with higher licensing tiers, such as enterprise or business critical, which provide more secure options. The pricing is reasonable, allowing small companies to operate at a cost below forty thousand a year while larger companies experience diminishing costs per data unit as usage increases, projected not to exceed one hundred thousand per month.
Which other solutions did I evaluate?
We evaluated Airbyte, Snowflake, and Databricks. Fivetran was ultimately chosen due to its simplicity in setup and configuration.
Snowflake and Databricks set up pipelines in a more complex way, and Databricks' orchestration workflow incurred heavier monthly costs.
What other advice do I have?
Fivetran is a very good tool for simplifying data management and ingestion. It is particularly useful for tracing data lineage, ensuring data flows correctly, and is beneficial if managing multiple data tools requires minimizing complexity.
I'd rate the solution eight out of ten.
Empower data management with enhanced simplicity and customization options
What is our primary use case?
Fivetran is an ingestion tool used to move data between different sources and destinations. It helps orchestrate pipelines that can be set up manually without technical experience. It facilitates daily pipeline runs based on a specific schedule determined by the licensing level.
How has it helped my organization?
Fivetran has significantly reduced data ingestion lead times by about sixty to eighty percent. It requires less maintenance on pipelines, freeing up development hours by approximately twenty percent. Additionally, the platform allows for faster setup of new connections, reducing lead time from four to eight weeks to one or a week and a half for complex integrations.
What is most valuable?
The simplicity and scalability stand out as the most valuable features of Fivetran. It is easy for users to get accustomed to the tool due to its gentle learning curve and clear error transparency. The platform offers transparent logging for detailed auditing. Moreover, scalability is emphasized as Fivetran charges less per row as you use the service more.
What needs improvement?
Fivetran could improve in the area of customization, especially in how they socialize their tools. The feature of being able to deploy Fivetran on-premises for enhanced security should be highlighted more during discussions with executives.
For how long have I used the solution?
I have used Fivetran for about four years now.
What do I think about the stability of the solution?
I rate the stability of Fivetran as nine out of ten. We have never experienced downtime issues.
What do I think about the scalability of the solution?
I rate the scalability of Fivetran as nine out of ten. It offers a flexible cost structure that benefits those who use it more extensively.
How are customer service and support?
Customer service is thorough but could be faster, rated as seven out of ten. They usually take about three to five business days to respond.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
Previously, everything was developed by hand using Python before moving to Fivetran. Fivetran was a significant improvement.
How was the initial setup?
The standard cloud licenses are very easy to set up. However, more complex deployments like self-hosted can be more technical.
What about the implementation team?
I managed the setup alone. In all the last two companies I've worked at, it has been a solo effort.
What was our ROI?
Fivetran has drastically improved our operations. We've reduced lead times for data ingestion by sixty to eighty percent and have fewer maintenance requirements, leading to a twenty percent increase in development hours. The system has simplified manual integration processes, leading to quicker setup times for new connections.
What's my experience with pricing, setup cost, and licensing?
The pricing is sensible and depends on the data ingestion quotas. The standard enterprise allows for advanced development, while the free tier offers a limited feature set. High security options require a business-critical license.
Which other solutions did I evaluate?
We evaluated Airbyte, Snowflake, and Databricks before choosing Fivetran. Snowflake and Databricks were less competitive due to their complexity and higher resource costs.
What other advice do I have?
Fivetran is a great tool for organizations needing to simplify data management and ingestion processes. It's ideal for those without a large team to handle multiple data tools.
I'd rate the solution eight out of ten.
Fivetran Review
Support could be so much more better and No slack integration for alerts
The Best Ingestion Tool
Fivetran supports near real-time data syncing, which is crucial for making timely decisions based on the most current data.
It can handle large volumes of data and scale as your data needs grow. This scalability ensures that performance remains consistent even as data complexity and volume increase.
Focus on your data, not how to move it
if you are in data engineering, you gotta love this software
Making ETL code Zero!
Really good product, saving time with trust
Expensive but reliable ingestion tool
Fivetran help us to extract all these sources and store them in our datawarehouse.