Try our new research platform with insights from 80,000+ expert users

Fivetran vs WhereScape RED comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Fivetran
Ranking in Data Integration
12th
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
25
Ranking in other categories
Data Replication (3rd), Cloud Data Integration (8th)
WhereScape RED
Ranking in Data Integration
49th
Average Rating
8.2
Reviews Sentiment
7.2
Number of Reviews
15
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of March 2025, in the Data Integration category, the mindshare of Fivetran is 2.1%, up from 1.9% compared to the previous year. The mindshare of WhereScape RED is 1.0%, up from 0.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Erik Jones - PeerSpot reviewer
Solution reduces time-to-value; high ROI
Fivetran has room for improvement in data pipeline observability. The Fivetran logs are fairly basic, compared to, for example, the insight Fivetran gives into helping users understanding the performance of data pipelines. So I think their observability into the pipeline itself could be improved. In addition, Fivetran is in the very early stages of allowing other companies to access its metadata API, but that's something that could use improvement, and I know that they're working on right now. We use a separate tool for "reverse ETL", which is the opposite of what Fivetran does; it pushes data from your data warehouse back out to business applications. If Fivetran pulls data from those same applications, they should also enable users to push it back. I would love to do both ETL and reverse ETL in the same tool. It would be nice if Fivetran offered both their regular offering plus the reverse ETL option as well.
it_user584544 - PeerSpot reviewer
The ​architecture is based on metadata and documentation is automated.
I would love to see a GUI interface for defining dependencies between build processes. RED provides a spreadsheet like interface for defining the dependencies between builds. Once the dependencies are defined, RED can produce a nice dependency diagram to give a visualization of the dependency tree. It would be easier to define complex dependency relationships if the dependency diagram were interactive. Our legacy ETL tool provided this GUI dependency definition via a drag and drop diagram which was very useful. The solution provided by WhereScape does work, and the dependency diagrams generated are helpful. It would just be nice to have the ability to define dependencies via a diagram, since dependencies relationships are much easier to understand via a diagram.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"For us, Fivetran has been able to scale both in terms of the data we bring into our warehouse and the amount of data that we use as well."
"The product has some seamless connectors, which are readily available."
"The user interface is mostly UI-based, eliminating the need for a lot of coding."
"The product is very easy to use and very easy to configure."
"Making the decision to implement Fivetran was supported by the fact that they have better connectors than other competitors."
"It is not like a traditional ETL, but it gives quite a lot of flexibility."
"The ease of setting up the connectors and transformations is highly valuable."
"Fivetran is remarkably easy to use; I haven't encountered any other data integration tool that is as user-friendly."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Support is absolutely excellent, efficient, and timely."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"The most valuable feature is the metadata generated code."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Naturally produces a way to easily debug your DW data solutions."
 

Cons

"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."
"Some of the pain points we're looking at are trying to integrate some of the items in the Microsoft stack, so SharePoint and Excel, and then some of the newer Azure services."
"The connections with SAP must be improved."
"This solution needs to improve its real-time data and transformation availability."
"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."
"There is not a lot of options to customize the pipeline, and the cost is high."
"We use a separate tool for "reverse ETL", which is the opposite of what Fivetran does; it pushes data from your data warehouse back out to business applications. If Fivetran pulls data from those same applications, they should also enable users to push it back. I would love to do both ETL and reverse ETL in the same tool."
"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."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Customization could be better."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
 

Pricing and Cost Advice

"Fivetran is very expensive, and its database-driven pricing model is outdated."
"The solution is affordable."
"The product is reasonably expensive"
"When you have a lot of workflows and complex use cases, pricing goes down as you use it more."
"I can't give exact amounts because that's based on usage, but it's more expensive than some of its competitors."
"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 rate the pricing a six out of ten."
"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."
"Our company purchased a corporate unlimited license."
"Factor in the price of specialized consulting who know this product. They're hard to find and expensive."
"Speed to market of a warehouse solution at a relatively inexpensive price point."
"ROI is at least 10 times."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
842,466 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
27%
Computer Software Company
12%
Financial Services Firm
11%
Manufacturing Company
8%
Financial Services Firm
19%
Computer Software Company
9%
Insurance Company
8%
Healthcare Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What's the deal with the HVR software acquisition?
As a user of HVR Software I followed this deal closely. Fivetran is apparently trying to establish more in its sector and by buying an already established data replication software, they become som...
Does HVR Software provide reliable insights?
I honestly can't think of another data replication software that can give you better statistics and insight than HVR Software. There's the feature for topology and statistics and both of them can ...
How much traffic can HVR Software handle?
As someone who works at a company where a high volume of information is replicated and has tried several data replication softwares, I can tell you that you're looking at the right one. HVR Softwar...
Ask a question
Earn 20 points
 

Comparisons

 

Overview

 

Sample Customers

Autodesk, Condé Nast, JetBlue, Morgan Stanley, OpenAI, LVMH, Pfizer, Verizon, SpotifyNational Australia Bank, Saks, Cemex, Okta, Dropbox, Pitney Bowes, World Fuel Services,Lufthansa, AutoZone, ASICS, ASOS, Coupa, Databricks, Hermes, New Relic, Intercom,Canva, Honeywell, Square, DocuSign, Nandos, Oldcastle Infrastructure
British American Tobacco, Cornell University, Allianz Benelux, Finnair, Solarwinds and many more.
Find out what your peers are saying about Fivetran vs. WhereScape RED and other solutions. Updated: February 2025.
842,466 professionals have used our research since 2012.