Fivetran Reviews

We use Fivetran for bidirectional data synchronizations between systems.

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.

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.

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.

I have been using Fivetran for a month.

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.

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.

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.

We use this solution for integration with different data sources to push data to our data warehouse, BigQuery and regularly updating the data.

We have four people using this solution in our business. 

Making the decision to implement Fivetran was supported by the fact that they have better connectors than other competitors. 

There was a random change to our contract in a unilateral manner after the first year. The overall cost of using Fivetran was then unclear and this is the reason I would not recommend this solution. 

One of the main selling points during the first implementation was the ability to carry over credits from one year to the next. This option was later removed and impacted their credibility as a service provider. 

I have used this solution for two years. 

This is a stable solution. 

I would rate the technical support for this solution a nine out of ten. 

Fivetrans has specific connectors that provides information we need for our processors and the other companies didn't have them at that point in time. 

The initial setup was not that simple because our database sources had a very old configuration, which in some cases could not be changed.

Our ROI using this solution is limited due to the high cost of the solution. 

In the first year, we were given a very good discount. It was approximately 20,000 Euros per year. In the third year, we purchased credit for two years and the price was 33,000 Euros per year.

I would advise others to get a contract for five years to begin with. I would rate this solution a five out of ten. I would rate the product and technical support a nine out of ten but there are other solutions on the market that offer similar performance and are more reliable. 

We are ingesting data from various SaaS tools.

The general data ingestion is valuable. It's used for a lot of data. It provides about 90% of the data we use in our data warehouse without needing data engineering.

Fivetran is very expensive for data sources with a lot of rows, such as email data. I would like to see cheaper pricing for data sources like that.

I have been using this solution for three years.

Some connectors are more stable than others. It seems it depends on which API they're connecting to.

It's scalable. We have six users who are using this solution. In terms of our plans to increase its usage, if we start using additional SaaS tools, we will add them to Fivetran.

I would rate them a four out of five.

Positive

We didn't use any other solution previously.

It was straightforward.

It was implemented in-house. It requires less than one person for deployment and maintenance.

We have seen an ROI.

I can't give exact amounts because that's based on usage, but it's more expensive than some of its competitors.

We evaluated other options.

It's excellent for any eCommerce data and advertising data, but consider another solution for the data that uses a lot of rows.

I would rate it an eight out of ten.

We are doing a proof of concept, and we are still building the operating model. We are using it for moving data from one source to another. We will be using HVR with Snowflake.

It is not like a traditional ETL, but it gives quite a lot of flexibility. 

It should have a few more monitoring functionalities. It should also support integration with more data sources. Currently, it supports Snowflake, AWS, and Google Cloud, but it can also support SAP integration. They can make it more flexible.

I have been using this solution for around six months.

It seems to be stable, but we have not yet used it in production. It is still in development. 

We are a large enterprise, but it also seems suitable for small and medium enterprises.

We have not contacted their support.

We did not do any deployment at all. We started around six months back, and we are just in the early stages of doing a proof of concept. 

We didn't evaluate other options.

Based on our experience so far, I would rate it an eight out of ten. We will get to know more about how it is in a couple of months.

I'm responsible for replicating the data from one source to another. It is constantly running, and we do nothing other than looking at monitoring reports. Once it is established, it is pretty much hands-off.

We are not using its latest version. We are slow to migrate to the new version. We wait until there is a need to upgrade, and we are generally one or two versions behind.

It has improved the way our organization functions.

The compare feature is the most valuable piece of it.

The documentation can be laid out better to make it easier to find things, and I really wish there was built-in support for changing passwords.

Some features don't work as advertised for the platform/repository database, and HVR is not always the fastest at getting results.

I have been using this solution for three years.

We like its stability.

We like its scalability.

They are adequate.

I have used GoldenGate replication previously.

Installing the software is really straightforward. Getting your replication stream working is a little bit more complicated, but it is not overly complicated.

Its deployment was done in-house. It took weeks. 

There are two people to manage it and make sure that it is working. They are part of the data team or the infrastructure team making sure that we're building our analytic pipeline.

I don't have the exact information, but I know it is high, and it is on a yearly basis. There is no additional cost for what we're doing.

We're always open to doing things cheaper, so we might potentially implement a different solution.

We looked at Informatica, but one of the sources that we had was only supported with HVR. That's why we went with HVR.

I would rate HVR an eight out of ten.

For this project, we are using both Fivetran and HVR; however, HVR has a limited number of connections, with only around 30 sources, whereas Fivetran has around 200 source connections. Therefore, if we are unable to connect with HVR, we are connecting with Fivetran.

Fivetran is a SaaS solution, so it is always on a public cloud.

Fivetran is remarkably easy to use; I haven't encountered any other data integration tool that is as user-friendly.

Fivetran has a lot of connectors and can currently connect to more than 200 sources. However, occasionally we come across a source that Fivetran does not currently connect to. We can request them to make a connector, but this can take some time. In the meantime, if we want to read through that API or add a custom connection, we cannot do it on Fivetran itself. We must use AWS Lambda and integrate it with our Fivetran account, and this must be done through the public cloud. The number of connectors has room for improvement.

I would like Fivetran to implement additional resource monitoring and restriction policies. I don't want to spend more than 100 or 1000 credits per week or have restrictions based on data sources. If a data source suddenly produces a large amount of data, I could manually pause the credits, but it would be very helpful if I could set policies like this.

I have been using the solution for almost one and a half years.

The solution is stable and I have not encountered any issues.

Fivetran is a scalable product that operates on a pay-as-you-go model, so we must be mindful of the potential for building a connector to it. I have not encountered this issue personally, but I am aware of people in my organization whose clients have experienced similar problems due to its scalability. Currently, we are migrating around 1000 rows per week. If someone were to run a full day, we might migrate 10,000 rows, which could consume up to 5000 credits for Fivetran in a week. I am uncertain of the dollar value of these credits, but it was estimated that they would last two months, yet they were used up in a week. Additionally, Fivetran does not have a resource monitoring feature, so we can monitor how much it has charged us, but we cannot set a limit, such as $2,000, to stop the usage.

We have contacted the Fivetran team for HVR support since HVR is supported by Fivetran, and they have been very responsive.

The initial setup is the easiest of all the data integration solutions. We don't need to do much; I have only done it with Snowflake and Databricks. We just need to set up a target or destination or protocol destination, which is really easy. On the left side, we have all the information we need to provide to Fivetran. On the right side, they have step-by-step documentation or procedures on how to find this or how to do that, even for connecting to data sources. Fivetran always gives us step-by-step instructions on how to do this, and Fivetran usually has fewer than 15 steps.

The implementation was completed in-house.

I give the solution a nine out of ten.

Fivetran is the most user-friendly data integration tool I have encountered. I have not needed any assistance from the Fivetran team, nor do I know anyone who has.

If we have data coming from multiple sources that need to be connected, such as our CRM, Salesforce, ERP, and SAP systems, it would take a lot of time to write programs for each one. To save time and allow our data engineers to focus on more useful tasks, it is better to use Fivetran. However, we should be mindful of the cost, as Fivetran uses a pay-as-you-go model. It is best to connect with the Fivetran team rather than setting up the connection directly. They may offer free data migration for a source for up to two weeks, depending on our negotiations. This can be very useful for the initial sync and can save a lot of costs.

I primarily use Fivetran to reduce the operational cost time of data engineering.

Fivetran's most valuable feature is replication.

Fivetran would be improved by adding the ability to integrate the data from third-party APIs. Its logs could also be more informative, and its real-time streaming data processing speed could be faster.

Fivetran is reliable.

Fivetran's technical support is really good, and if you're on their enterprise plan, they usually respond within an hour and keep you continuously updated on progress. However, it can sometimes take a couple of days for the problem to be fixed.

Neutral

Fivetran is very expensive, and its database-driven pricing model is outdated.

I would rate Fivetran seven out of ten.

We use the solution to replicate data from our ERP.

The product is very easy to use and very easy to configure. We can do an end-to-end configuration in a few minutes.

The connections with SAP must be improved. The environment has some limitations.

I have been using the solution since January 2023.

The product’s stability is very good.

The tool’s scalability is very good.

The initial setup is very easy. It is not that complex. I was part of the deployment process. It is still ongoing. We are not running production for now.

We need two or three IT employees to maintain the solution.

The solution has good pricing. I rate the pricing a six out of ten.

It's a good integration tool. It is easy to use. Overall, I rate the solution a nine out of ten.