Try our new research platform with insights from 80,000+ expert users
Principal Data Engineer at a tech services company with 11-50 employees
Real User
Top 5Leaderboard
Simplified data tracing with reduced maintenance and more automation
Pros and Cons
  • "The simplicity and scalability are the strongest features of Fivetran."
  • "The biggest area for improvement is in customization, particularly in how Fivetran socializes its tools."

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.

Buyer's Guide
Fivetran
November 2024
Learn what your peers think about Fivetran. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
814,763 professionals have used our research since 2012.

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Integrated Support and Planning & Project Management Specialist at a transportation company with 10,001+ employees
Real User
Has one central interface that manages everything and is easy and quick to set up
Pros and Cons
  • "The ease of usability is the most valuable feature. It's very easy and quick to set up. It also has a central hub as opposed to GoldenGate which is one direct interface. For GoldenGate I would have needed three interfaces whereas with HVR I have a central interface that manages everything."
  • "I would like for them to incorporate additional transformations. A valuable aspect of the product is that it does inflight transformations and that could be expanded."

What is our primary use case?

We are currently using the private model of this solution. It is CDC and we take data from an OLTP system to populate a data warehouse and to populate a reporting system. 

What is most valuable?

The ease of usability is the most valuable feature. It's very easy and quick to set up. It also has a central hub as opposed to GoldenGate which is one direct interface. For GoldenGate I would have needed three interfaces whereas with HVR I have a central interface that manages everything. 

What needs improvement?

We have a number of connections to heterogeneous databases and that could be expanded on. One of the databases is an additional database that should be coming online but there is some difficulty with it. Other than this, in comparison to other products it's competing with, including Oracle, it beats them hands down for everything, including the price.

I would like for them to incorporate additional transformations. A valuable aspect of the product is that it does inflight transformations and that could be expanded. 

For how long have I used the solution?

We are in the process of going live with this solution. We're testing it now.

How are customer service and technical support?

Their technical support is excellent, better than Oracle. The online support is very good but equally, their support is immediate and willing. Up until now, they have taken our suggestions and considered incorporating them into the next version. 

How was the initial setup?

The initial setup was straightforward. 

What's my experience with pricing, setup cost, and licensing?

The pricing is considerably less than its competitor, GoldenGate. One of the things that we liked about it and that sold us on it, is that we only licensed production and it then enabled us to install the product on any other non-production. Whereas with Oracle, it's in every environment. In the three environments that I have HVR, I only need to license production. Whereas with Oracle I would've had to license all three environments. 

What other advice do I have?

I would suggest not to discount it because of its low price and small company. Most of the technicians are ex-Oracle employees and they have a passion for data transformations and data support. They are very proactive which is a breath of fresh air when you compare it with Oracle support. 

I would rate it 8.5 out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Fivetran
November 2024
Learn what your peers think about Fivetran. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
814,763 professionals have used our research since 2012.
John Parker - PeerSpot reviewer
VP of Data Science and Strategy at Innive Inc
Real User
Top 20
Helps to build data pipelines and save time but pricing is expensive
Pros and Cons
  • "The most important feature of the solution is its ability to build data pipelines in less time."
  • "We experience cost issues because Fivetran is charged on a usage basis. When you reach a certain level, the tool should focus on reducing the costs. The solution is expensive when you are moving gigabytes and petabytes of data. It should also focus more on REST APIs and webhooks."

What is our primary use case?

We use Fivetran to build data engineering pipelines. It helps us do a lot of data transformation and data extraction. 

How has it helped my organization?

Fivetran helps us save time and be more efficient because we do things with no-code/low-code. 

What is most valuable?

The most important feature of the solution is its ability to build data pipelines in less time. 

What needs improvement?

We experience cost issues because Fivetran is charged on a usage basis. When you reach a certain level, the tool should focus on reducing the costs. The solution is expensive when you are moving gigabytes and petabytes of data. 

It should also focus more on REST APIs and webhooks. 

For how long have I used the solution?

I have been using the solution for two years. 

What do I think about the stability of the solution?

The solution is very stable and reliable. 

What do I think about the scalability of the solution?

The product's scalability is high. 

How are customer service and support?

Fivetran's technical support is average and can take weeks to respond. 

How was the initial setup?

Fivetran's deployment is simple. 

What other advice do I have?

I rate the solution a  seven out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Principal Data Engineer at a tech services company with 11-50 employees
Real User
Top 5Leaderboard
Empower data management with enhanced simplicity and customization options
Pros and Cons
  • "It is easy for users to get accustomed to the tool due to its gentle learning curve and clear error transparency."
  • "Fivetran could improve in the area of customization, especially in how they socialize their tools."

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.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Data Solutions Architect at Jet2.com
Real User
Top 20
Has a great SysTrack load feature, but the real-time data needs improvement
Pros and Cons
  • "SysTrack load is the best feature."
  • "This solution needs to improve its real-time data and transformation availability."

What is most valuable?

SysTrack load is the best feature. 

What needs improvement?

This solution needs to improve its real-time data and transformation availability. You have to extract a load before you can do any transformation. 

Another improvement that can be made is with load extraction. This functionality should be implemented with obligating data and data masking.

For how long have I used the solution?

I have been using Fivetran for a couple of months. 

What do I think about the stability of the solution?

The stability is an eight out of ten. 

What's my experience with pricing, setup cost, and licensing?

I rate the pricing a six out of ten.

What other advice do I have?

Overall, I rate the solution a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Lead Infrastructure Engineer at a tech vendor with 10,001+ employees
Real User
User-friendly solution that can handle heavy traffic
Pros and Cons
  • "Its arrays are powerful enough to handle migrations even when the replication is happening in the background, without causing any trouble with the ongoing traffic."
  • "HVR Software's technical support could be improved. Whenever we log a case, the response that we get from the support is a bit delayed."

What is our primary use case?

I mainly use HVR Software for replication and migration.

How has it helped my organization?

HVR Software is an asynchronous replication solution. Its arrays are powerful enough to handle migrations even when the replication is happening in the background, without causing any trouble with the ongoing traffic.

What is most valuable?

HVR Software's most valuable features are that it's simple to use and allows us to use the command line to quickly complete the entire universal replicative setup.

What needs improvement?

In the next release, I'd like to see an automated version of HVR with a script that can be run on a management server where we can provide all the information within the script, or the script can prompt the user to enter the storage area and volume details so that with just a few clicks, the solution will be deployed automatically in the background.

For how long have I used the solution?

I've been using HVR Software for fourteen months.

What do I think about the stability of the solution?

HVR Software is stable.

What do I think about the scalability of the solution?

HVR Software is scalable.

How are customer service and support?

HVR Software's technical support could be improved. Whenever we log a case, the response that we get from the support is a bit delayed.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup was straightforward because we had all the required documentation.

What about the implementation team?

We used an in-house team.

What's my experience with pricing, setup cost, and licensing?

I've heard that the license for HVR is a bit costly compared to its competitors, but since it's reliable and efficient, I think the customer shouldn't be bothered about the cost.

What other advice do I have?

I would rate HVR Software as ten out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Principal Data Engineer at a tech services company with 11-50 employees
Real User
Top 5Leaderboard
Easy to learn, so you can quickly manage ETL pipelines, but it could have more customization options
Pros and Cons
  • "You can manage all of your connectors individually, which gives you a very good ability to trace which one of your ETL processes is running and when."
  • "The customization could improve because Fivetran gives more thought to people who don't want to manage analytics workflows rather than engineers who want to be able to customize pipelines more thoroughly."

What is our primary use case?

We mainly use Fivetran for ETL.

What is most valuable?

There's a very good layer that allows you to connect different data sources and establish a very good ETL workflow. You can manage all of your connectors individually, which gives you a very good ability to trace which one of your ETL processes is running and when. The solution also allows you to schedule each of those runs with different cadences, depending on which plan you are on. At the same time, for those runs, you have the ability to hash, unhash, or map any data that might be sensitive or personally identifiable, and that's pretty robust. It's a feature in the standard plan, so you don't need the enterprise plan for that. One very powerful and cool feature is how you can integrate the solution with other transformation tools, such as dbt, or run the transformations within Fivetran itself to create a transformation layer on top of your ETL layer. That allows you to manage the entire ETL workflow end to end from within the platform without the need for any additional tool.

When it comes to managing ETL pipelines, these features are valuable.

What needs improvement?

Given that Fivetran is a fully managed third-party solution, the customization could improve because Fivetran gives more thought to people who don't want to manage analytics workflows rather than engineers who want to be able to customize pipelines more thoroughly.

For how long have I used the solution?

I've had experience with Fivetran for about two-and-a-half to three years.

What do I think about the scalability of the solution?

The scalability will directly relate to the plan you're on. It will be very important to see that the provisioning in compute and the provisioning you have to run workflows and jobs will also be directly related to your use case. Managing scalability in that way is a bit complex, but you get a lot of support from Fivetran.

How are customer service and support?

From a customer support standpoint, Fivetran does an amazing job in establishing and helping you customize while ensuring you have the right plan for your data needs. I have full contact with our account executive, and she's super nice and walks us through many of these use cases that will be important in the future and many of the estimations we might need for the workflow we plan on integrating.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

I have used Splunk before, and it's more technical. Splunk allows you to version things and have a good engineering process around your ETL pipeline. It also has very good logging and documentation tools. But now that Fivetran has a better exposed API, it is much more flexible. But Splunk beats Fivetran regarding things like customization, for example. We switched to Fivetran because we reduced the engineering team. We had fewer people to manage all the different ETL processes, so we had to leverage more automated third-party tools, and Fivetran made onboarding new engineers a lot easier.

How was the initial setup?

Fivetran is very easy to set up. It's a matter of having the connection information of each one of the endpoints you want the ETL through. The solution is very comprehensive and easy to set up. It even gives you assistance on where to find the information that you might need, depending on the data source. It has pre-built connectors for the most common data sources, so it also helps you expedite that process if you are not super tech-savvy.

What's my experience with pricing, setup cost, and licensing?

Fivetran has a pricing model that scales the more data sources you add. When you have a lot of workflows and complex use cases, pricing goes down as you use it more. That's a very good feature of its pricing. Fivetran might be a bit pricey for a very limited or small number of data sources that might be easily collected in other forms. The pricing gets better the bigger you are.

Which other solutions did I evaluate?

Comparing Fivetran to other tools such as dbt, AWS Glue, or Azure Data Factory, the other tools are more robust and allow us to run custom transformations.

What other advice do I have?

To anyone who uses the product, I say monitor. You have a dashboard to monitor your MAR, which is a row-level metric Fivetran uses to gauge how much you are consuming. If you can monitor your MAR closely, you can get a very good understanding of how much data you're moving, and it will allow you to adjust the cadences you might need to get a better bang for your buck. Watch your numbers and try to plug in as many data sources as you need because that will help you with pricing.

I rate Fivetran a seven or a seven-point five out of ten. It's solid and offers a very simple UI and way to get set up. It might fall short for people who want more advanced use cases or people who have knowledge and tools that they can integrate, and that's where things get a bit more technical. But I feel the leap from just getting started with it to getting very technical with it is very large. There's no middle ground.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user1005216 - PeerSpot reviewer
Program Manager at a manufacturing company with 10,001+ employees
Real User
A good stable solution for data logs and refreshes
Pros and Cons
  • "The solution is stable. We've never faced any stability issues."
  • "The interface needs to be more user-friendly."

What is our primary use case?

We primarily use the solution for business intelligence.

What is most valuable?

We use it for data publishing, data logs, and data refreshes These services are all very good.

What needs improvement?

The interface needs to be more user-friendly.

Data security should be improved in the next release.

For how long have I used the solution?

I've been using the solution about three years.

What do I think about the stability of the solution?

The solution is stable. We've never faced any stability issues.

What do I think about the scalability of the solution?

The way we are using it, I think the solution's level of scalability is sufficient for us. We didn't really need anything bigger. For us, it's been fine so far. We have about 30-40 users. There's no need for us to increase usage at this point.

How are customer service and technical support?

We've never really used technical support, so I can't speak to the level of quality.

How was the initial setup?

The initial setup was complex. We had quite a few data sources, so the database replication was quite in-depth and we had quite a few environments that needed to be refreshed. 

What's my experience with pricing, setup cost, and licensing?

Right now, we have a corporate license. I'm not sure of the term of the license or the cost.

What other advice do I have?

We use the on-premises deployment model.

I would rate the solution eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Fivetran Report and get advice and tips from experienced pros sharing their opinions.
Updated: November 2024
Buyer's Guide
Download our free Fivetran Report and get advice and tips from experienced pros sharing their opinions.