We have implemented Fivetran at client sites to connect to various platforms like Dynamics 365 and SharePoint. My objective was to determine which solution was better for handling geospatial data.
Fivetran Data Movement Platform
FivetranExternal reviews
External reviews are not included in the AWS star rating for the product.
Reliable Data Integration with Fivetran
Great Managed Solution with Room for Improvement
Seamless connector setup with good data readiness and room for filtering improvements
What is our primary use case?
How has it helped my organization?
It has been beneficial in quickly getting data ready for AI or machine learning projects due to its easy connectors, which expedite data availability.
What is most valuable?
The ease of setting up the connectors and transformations is highly valuable. We used the SaaS version of Fivetran to connect to Dynamics 365, and it was great and easy, although we couldn't filter data on it.
What needs improvement?
I would like to see an improvement in the support offered by Fivetran. Their support is very limited, and even when they respond, they often can't help. The ability to handle geospatial data types would also be beneficial, as well as the ability to filter data in the connectors.
For how long have I used the solution?
I have used it for about a year across different sites and for various purposes, using different connectors.
What do I think about the stability of the solution?
Fivetran's automatic schema migrations have been perfect, without any issues.
How are customer service and support?
Their support is limited. When you do get a hold of someone, they often cannot provide much assistance.
How would you rate customer service and support?
Positive
What's my experience with pricing, setup cost, and licensing?
The pricing for small corporations, particularly when using connectors such as those for SharePoint, is not affordable. For large corporations doing change data capture, it is very affordable.
Which other solutions did I evaluate?
For geospatial data, I would recommend using other solutions like FME. A simple Azure Data Factory setup can handle filtering, which some connectors don’t facilitate.
What other advice do I have?
I would recommend Fivetran based on specific use cases. Its ease of use and minimal setup requirements make it one of the easiest solutions, although it might not be suitable for all cases.
I'd rate the solution seven out of ten.
A really easy out of the box tool
Now we primarily use Fivetran to ingest data from external tools
Easy setup
Simplified data tracing with reduced maintenance and more automation
What is our primary use case?
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.
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.
Very easy to use, extremely robust and reliablr
Success rate in integration
Alerting when sth fails