We use Fivetran for bidirectional data synchronizations between systems.
Fivetran Data Movement Platform
FivetranExternal reviews
458 reviews
from
and
External reviews are not included in the AWS star rating for the product.
An easy-to-set-up solution that can be used for bidirectional data synchronizations between systems
What is our primary use case?
How has it helped my organization?
I didn't set up any transformation in Fivetran. I wanted Fivetran to take care of the log sequence number comparison between source and destination systems so that it would pick up only the data that needed to be synchronized, and it did it beautifully.
What is most valuable?
The most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized. You need to capture the in-source updates and digits from the source; this is the only information you want. You don't want to download the whole thing each time. Fivetran does this just beautifully.
What needs improvement?
Fivetran should add more connectors because its competitors, like Airbyte, have more connectors. All of these systems have a problem, namely that they are pure cloud player solutions. I often work in hybrid solutions where customers have on-prem things mixed with cloud things.
Pure cloud player solutions never provide a good solution for what is on-prem, which leads to a gap. When you look at systems such as ActiveBatch, they have a very, very strong on-prem platform. They are also looking at the web and cloud things, but they are not that good at the cloud things. So there is nothing that is equally good for both on-prem and cloud.
Fivetran should add a feature to connect to the SQL server on-prem.
For how long have I used the solution?
I have been using Fivetran for a month.
What do I think about the stability of the solution?
Fivetran is a very stable solution. After you set it up, you can forget about it. I rate Fivetran a nine out of ten for stability.
What was our ROI?
Fivetran saved me a lot of work. I could have hired a bunch of engineers to write Python's code for me, but Fivetran was already built. So, it was easier for me to focus on my line of business and purchase a commercial product without trying to replicate this myself in Python. That's not a return on investment; that is savings.
What other advice do I have?
I am using the latest version of Fivetran.
Fivetran is easy to set up. It took me one or two hours to set up my flow, and then I forgot about it. So for me, it's perfect because it doesn't take a lot of time. It's not like some other solutions where you need two weeks of engineering to get them to work.
I would advise users to try Fivetran before they commit to it.
When I compare Fivetran with Airbyte, I like Airbyte better than Fivetran.
Overall, I rate Fivetran an eight out of ten.
Breaks too often, unhelpful support, expensive
What do you like best about the product?
It usually works, nothing much to add here.
What do you dislike about the product?
Providers break very often. It takes weeks for support to resolve such issues.
It takes days for support to respond to urgent issues
Some API methods have ridiculous designs, e.g. updating the schema: you have to perform 7 API calls in a row to achieve a single change in the config.
There's no API versioning; requests and responses just get updated.
Pricing is extreme. Self-hosted solutions, for example, Airbyte, are identical in terns of setup and maintenance efforts, but you only pay for hosting.
Last, but not least, it's not fast at all.
It takes days for support to respond to urgent issues
Some API methods have ridiculous designs, e.g. updating the schema: you have to perform 7 API calls in a row to achieve a single change in the config.
There's no API versioning; requests and responses just get updated.
Pricing is extreme. Self-hosted solutions, for example, Airbyte, are identical in terns of setup and maintenance efforts, but you only pay for hosting.
Last, but not least, it's not fast at all.
What problems is the product solving and how is that benefiting you?
Data syncs from external providers
A stable and scalable solution that needs improvement with pricing
What is our primary use case?
Real-time streaming and SAP are the primary use cases of the solution.
What is most valuable?
The simplicity of the solution is its valuable feature.
What needs improvement?
The solution is very expensive. I would like to have a better integration of the solution with Azure.
For how long have I used the solution?
I have been using the solution for one year.
What do I think about the stability of the solution?
It is a stable solution.
What do I think about the scalability of the solution?
It is a scalable solution that is recommended for only enterprise companies because small and medium companies do not have the expertise and money to run Fivetran.
How are customer service and support?
The technical support is good.
Which solution did I use previously and why did I switch?
Previously, we used ADA tester and the solution is easy to implement with Azure Cloud. It is easier than Fivetran. Fivetran on the other hand is good for real time.
How was the initial setup?
The solution is not easy to setup for a startup and SME but if an enterprise wants to do everything hands-on, it's okay for them. The deployment takes a couple of weeks to complete. Two people are needed for implementation.
What's my experience with pricing, setup cost, and licensing?
The licensing costs are extremely high for the usage of somebody who has one GB or two GB of usage per day for real-time traffic. There are many other players in the market which are similarly priced or competitively priced. On average per month, it used to come around 12,000-15,000 USD, which is very high.
What other advice do I have?
I rate the overall solution a seven out of ten.
Fivetran review
What do you like best about the product?
Its use is easy to understand with a modern structure that has provided solutions for data movement for better analysis, its attention is as desired in times and responses.
What do you dislike about the product?
It can be a bit expensive due to its high price plans that not everyone can afford this amount of money.
What problems is the product solving and how is that benefiting you?
Out-of-the-box data integration and data collection makes data analysis more detailed
Definately a good option to collect data in batch mode from multiple sources, good product support
What do you like best about the product?
I used FiveTran for POC to integrate and pull data from AWS S3 and Spool Directory of the Unix server , it helped us to extract data from various sources, transform it, and load it into a destination database. It supports multiple sources, including databases, cloud applications, and APIs, and integrates with various cloud-based data warehouses such as Snowflake, Amazon Redshift, and Google BigQuery. It provides pre-built connectors for many popular data sources and automates the data pipeline, making it easier for our business to consolidate data and gain insights.
What do you dislike about the product?
Lack of real time streaming or processing data. It does not support real-time ingestion of data. It has a configurable sync schedule that can run as frequently as every five minutes for some data sources. There are some time issue faced with schedular as well during our POC.
What problems is the product solving and how is that benefiting you?
We had to pull data from different sources and push it to Database, we were exploring option during POC, first we had only batch mode data processing as requirement , so we consider it . Its easy to configure the source due to pre-built connectors , supporting quick integration and different data formats solved our problem.
The data can be loaded into the destination database relatively quickly after it is added or updated in the source system. However, it is not a real-time ingestion solution, and there may be a delay between the time when data is changed in the source system and when it is available in the destination database.
The data can be loaded into the destination database relatively quickly after it is added or updated in the source system. However, it is not a real-time ingestion solution, and there may be a delay between the time when data is changed in the source system and when it is available in the destination database.
Solid ELT solution, meets our data Integration needs.
What do you like best about the product?
The ability to transform data within the platform without requiring external tools or scripts. Fivetran has a large number of pre-built connectors, they cover a wide range of data sources, making it easy to integrate with different systems. Regardless of where our data is coming from, Fivetran has made the extraction process seamless and reliable, providing us with clean and structured data that we can use for our analytics needs.
What do you dislike about the product?
We've had scenarios when the sync process failed to complete successfully, causing some delays in our data pipeline. The process of troubleshooting the sync errors can be time-consuming and requires technical expertise, which could be a challenge for some organizations without dedicated data engineering resources.
What problems is the product solving and how is that benefiting you?
Fivetran streamlines the way we access and use data by providing a reliable ELT solution that reduces the need for manual intervention. Helps us focus on analyzing data and drawing insights that drive business decisions rather than spending time on manual data integration processes.
Very opaque pricing / billing practices, unhelpful support
What do you like best about the product?
Easy to spin up ETLs from various data sources straight into data warehouses. It works really well for low-volume data sources such as Google Sheets etc. effectively cutting the engineer in the loop from these data sources.
It is easy to spin up sources from high-volume data sources like Google Analytics, Meta Ads etc. but be extremely aware that this is very cost ineffective usage of the platform.
It is easy to spin up sources from high-volume data sources like Google Analytics, Meta Ads etc. but be extremely aware that this is very cost ineffective usage of the platform.
What do you dislike about the product?
Extremely opaque billing practices. Our bill shot up about 5x month over month with no notice because of very loose usage of "free historical syncs."
The initial trial period for connectors obfuscates billing for connectors and the platform does not provide any control over your spending (such as maximum spend limits or accurate spend forecasts). In conjunction with how the usage is calculated - effectively, you will get charged 80% of the usage for the month on the first day and the rest throughout the month; this means that you do not have any control over your spending throughout the month.
On top of this, the support for billing is extremely thin and our experience is that Client Success team has a very limited understanding of billing and usage and even less agency over it.They will hop on a call when you want and they will act emphathic etc. but in our experience, they never follow-up on their action items. Extremely unhelpful and patronizing attitude in general.
The initial trial period for connectors obfuscates billing for connectors and the platform does not provide any control over your spending (such as maximum spend limits or accurate spend forecasts). In conjunction with how the usage is calculated - effectively, you will get charged 80% of the usage for the month on the first day and the rest throughout the month; this means that you do not have any control over your spending throughout the month.
On top of this, the support for billing is extremely thin and our experience is that Client Success team has a very limited understanding of billing and usage and even less agency over it.They will hop on a call when you want and they will act emphathic etc. but in our experience, they never follow-up on their action items. Extremely unhelpful and patronizing attitude in general.
What problems is the product solving and how is that benefiting you?
We used fivetran to extract data from various sources and sink it in our data warehouse. It does this job relatively okay but the billing practices make the tool effectively a very low ROI investment, I'd recommend just going the traditional ETL route.
Amazing integrations
What do you like best about the product?
Ease of connector use and variety of connector ecosystem. A lot of their connectors have really good schema which naturally fits the use case. Also whenever in doubt the documentation is very good, I refer to it
What do you dislike about the product?
The pricing is pretty confusing and its a bummer that their logging feature is only available in a paid plan. They should really give solid examples on their website.
What problems is the product solving and how is that benefiting you?
Google Ads, Bing, Yahoo Search data. Also GSC Data is super useful.
Great Product, but Beware the Cost
What do you like best about the product?
Fivetran is almost unbelievably easy to configure and use. The free initial sync is an incredible feature, and MAR is pretty transparent and easy to work with. Fivetran support is also terrific.
What do you dislike about the product?
Cost can be prohibitive, and new users really need to pay attention to what they're planning to ingest. Expense can get out of hand quickly, which means you may end up supporting multiple pipeline tools anyway.
What problems is the product solving and how is that benefiting you?
Extremely easy to use--basically replaces half an FTE for us.
No-code, low fuss Extract Tool
What do you like best about the product?
- It is very easy to get started and ingest data. There is no infrastructure or code to manage
- There is a huge catalogue of connectors available which covers the requirements of most of the enterprise customers
- Fully managed service - that means you can set it and forget it without much maintainence
- There is a huge catalogue of connectors available which covers the requirements of most of the enterprise customers
- Fully managed service - that means you can set it and forget it without much maintainence
What do you dislike about the product?
- The pricing model is not very good. Pricing based on the monthly active rows is confusing and difficult to forecast the pricing
- Enterprise customers with a large amount of data might not find the pricing model very attractive.
- Enterprise customers with a large amount of data might not find the pricing model very attractive.
What problems is the product solving and how is that benefiting you?
- Fivetran replaces inhouse data extraction python scripts and provides enterprise grade data, managed connectors that can pull data from a variety of sources.
- WIth this data engineers can focus more on delivering insights and data to business than spending hours writing customer extraction scripts and maintaining infra needed to run them
- WIth this data engineers can focus more on delivering insights and data to business than spending hours writing customer extraction scripts and maintaining infra needed to run them
showing 111 - 120