Compare Azure Data Factory vs. WhereScape RED

Azure Data Factory is ranked 6th in Data Integration Tools with 10 reviews while WhereScape RED is ranked 11th in Data Integration Tools with 4 reviews. Azure Data Factory is rated 8.2, while WhereScape RED is rated 8.8. The top reviewer of Azure Data Factory writes "Straightforward and scalable but could be more intuitive". On the other hand, the top reviewer of WhereScape RED writes "Automation tool - spend less time writing code". Azure Data Factory is most compared with Talend Open Studio, Informatica PowerCenter and Informatica Enterprise Data Catalog, whereas WhereScape RED is most compared with SSIS, Informatica PowerCenter and Matillion ETL. See our Azure Data Factory vs. WhereScape RED report.
Cancel
You must select at least 2 products to compare!
Azure Data Factory Logo
7,322 views|5,739 comparisons
WhereScape RED Logo
13,629 views|4,566 comparisons
Most Helpful Review
Find out what your peers are saying about Azure Data Factory vs. WhereScape RED and other solutions. Updated: March 2020.
405,734 professionals have used our research since 2012.
Quotes From Members

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

Pros
It is easy to deploy workflows and schedule jobs.From my experience so far, the best feature is the ability to copy data to any environment. We have 100 connects and we can connect them to the system and copy the data from its respective system to any environment. That is the best feature.It is a complete ETL Solution.Powerful but easy-to-use and intuitive.The most valuable features are data transformations.Data Factory itself is great. It's pretty straightforward. You can easily add sources, join and lookup information, etc. The ease of use is pretty good.From what we have seen so far, the solution seems very stable.The user interface is very good. It makes me feel very comfortable when I am using the tool.

Read more »

The most valuable feature is the metadata generated code.I found the initial setup very easy.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.WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing.Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied.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.RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation.

Read more »

Cons
The setup and configuration process could be simplified.The user interface could use improvement. It's not a major issue but it's something that can be improved.The Microsoft documentation is too complicated.The product could provide more ways to import and export data.The speed and performance need to be improved.On the UI side, they could make it a little more intuitive in terms of how to add the radius components. Somebody who has been working with tools like Informatica or DataStage gets very used to how the UI looks and feels.The solution needs to integrate more with other providers and should have a closer integration with Oracle BI.The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way.

Read more »

Project-based searching of data objects in the data warehouse browser needs to be improved.The solution can be a little more user-friendly on enterprise-level where people use it.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.Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment.

Read more »

Pricing and Cost Advice
This is a cost-effective solution.Our licensing fees are approximately 15,000 ($150 USD) per month.In terms of licensing costs, we pay somewhere around S14,000 USD per month. There are some additional costs. For example, we would have to subscribe to some additional computing and for elasticity, but they are minimal.

Read more »

Information Not Available
report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
405,734 professionals have used our research since 2012.
Ranking
6th
Views
7,322
Comparisons
5,739
Reviews
10
Average Words per Review
456
Avg. Rating
8.1
11th
Views
13,629
Comparisons
4,566
Reviews
4
Average Words per Review
399
Avg. Rating
8.8
Top Comparisons
Compared 29% of the time.
Compared 9% of the time.
Learn
Microsoft
WhereScape
Video Not Available
Overview

Create, schedule, and manage your data integration at scale with Azure Data Factory - a hybrid data integration (ETL) service. Work with data wherever it lives, in the cloud or on-premises, with enterprise-grade security.

WhereScape RED is data warehouse software to help build data warehouses faster. But it is more than that. It also helps you to build data warehouses that are easy to support, change and extend. It is an integrated development environment, or IDE, especially designed to build great data warehouses faster in SQL Server, Teradata, DB2 and Oracle.
Offer
Learn more about Azure Data Factory
Learn more about WhereScape RED
Sample Customers
Milliman, Pier 1 Imports, Rockwell Automation, Ziosk, Real Madrid Jersey Electricity, Man Group Plc, Learning Care Group, First Data, Hunter Douglas, The City of Shoreline, ASB
Top Industries
VISITORS READING REVIEWS
Software R&D Company53%
Comms Service Provider9%
Retailer4%
Insurance Company4%
REVIEWERS
University30%
Healthcare Company30%
Non Profit10%
Manufacturing Company10%
VISITORS READING REVIEWS
Software R&D Company27%
Insurance Company12%
Financial Services Firm9%
Real Estate/Law Firm7%
Company Size
REVIEWERS
Small Business19%
Midsize Enterprise25%
Large Enterprise56%
REVIEWERS
Small Business24%
Midsize Enterprise24%
Large Enterprise53%
VISITORS READING REVIEWS
Small Business24%
Midsize Enterprise39%
Large Enterprise37%
Find out what your peers are saying about Azure Data Factory vs. WhereScape RED and other solutions. Updated: March 2020.
405,734 professionals have used our research since 2012.
We monitor all Data Integration Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.