Azure Data Factory vs WhereScape RED comparison

Microsoft and WhereScape are both solutions in the Data Integration category. Microsoft is ranked #1 with an average rating of 8.1, while WhereScape is ranked #46. Microsoft holds a 11.0% mindshare in DI, compared to WhereScape’s 1.1% mindshare. Additionally, 92% of Microsoft users are willing to recommend the solution, compared to 95% of WhereScape users who would recommend it.

Azure Data Factory

Read 86 Azure Data Factory reviews

21,615 Views
17,232 Comparison Views

92% willing to recommend

WhereScape RED

Read 15 WhereScape RED reviews

1,879 Views
1,283 Comparison Views

95% willing to recommend

Azure Data Factory

WhereScape RED

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

WhereScape RED and Azure Data Factory compete in data management solutions. WhereScape RED seems to have the upper hand due to its cost-effective pricing and substantial ROI.

Features: WhereScape RED offers a metadata-driven approach, efficient development processes, and automation of repetitive tasks which lead to significant time savings. Azure Data Factory provides seamless integration capabilities, a flexible drag-and-drop interface, and over 100 built-in connectors for various data sources.

Room for Improvement: WhereScape RED could enhance its scheduling capabilities and support for more cloud platforms. Azure Data Factory's pricing model could be simplified, and it may improve on providing clearer cost predictions and better support for smaller organizations.

Ease of Deployment and Customer Service: WhereScape RED is noted for its easy deployment and effective management of database objects, while Azure Data Factory offers a user-friendly interface and quick deployment with great integration with the Azure ecosystem.

Pricing and ROI: WhereScape RED utilizes a developer seat-based pricing model, leading to considerable ROI by reducing project budgets by up to 50%. Azure Data Factory employs a pay-as-you-go pricing structure, which can be difficult for some users to predict but offers competitive pricing and flexibility when compared to AWS, although specific ROI is not outlined.

To learn more, read our detailed Azure Data Factory vs. WhereScape RED Report (Updated: December 2024).

Buyer's Guide

Azure Data Factory vs. WhereScape RED

December 2024

Download the complete report

Helped 824,053 peers since 2012

Categories and Ranking

Azure Data Factory

Ranking in Data Integration

1st

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Cloud Data Warehouse (3rd)

WhereScape RED

Ranking in Data Integration

46th

Average Rating

8.2

Reviews Sentiment

7.2

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of December 2024, in the Data Integration category, the mindshare of Azure Data Factory is 11.0%, down from 13.3% compared to the previous year. The mindshare of WhereScape RED is 1.1%, up from 1.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

Thulani David Mngadi

Data architect at Old Mutual

Data flow feature is valuable for data transformation tasks

The workflow automation features in GitLab, particularly its low code/no code approach, are highly beneficial for accelerating development speed. This feature allows for quick creation of pipelines and offers customization options for integration needs, making it versatile for various use cases. GitLab supports a wide range of connectors, catering to a majority of integration needs. Azure Data Factory's virtual enterprise and monitoring capabilities, the visual interface of GitLab makes it user-friendly and easy to teach, facilitating adoption within teams. While the monitoring capabilities are sufficient out of the box, they may not be as comprehensive as dedicated enterprise monitoring tools. GitLab's monitoring features are manageable for production use, with the option to integrate log analytics or create custom dashboards if needed. The data flow feature in Azure Data Factory within GitLab is valuable for data transformation tasks, especially for those who may not have expertise in writing complex code. It simplifies the process of data manipulation and is particularly useful for individuals unfamiliar with Spark coding. While there could be improvements for more flexibility, overall, the data flow feature effectively accomplishes its purpose within GitLab's ecosystem.

Read full review

reviewer1618884

BI Analyst DW Architect at a mining and metals company with 10,001+ employees

Quick to set up, flexible, and stable

The scheduling part I don't like due to the fact that it allows you to schedule as a parent and child and other things, however, the error trackability has to be a little more user-friendly. It's also not user-friendly in the sense that it loads all the jobs and there are not enough filters so that it doesn't need to load everything. If the job fails, you don't get any type of alert or email. It would be ideal if there was some sort of automated alert message. Technical support isn't the best. It would be ideal if we understood how to do it in a card exception regarding exclusion, where the card is captured separately rather than filling the whole process on the data inbound side. Certain workloads like this are organized in such a way where you seem to be doubling the work as opposed to streamlining the process.

Read full review

Quotes from Members

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

Pros

"The data copy template is a valuable feature."

"One of the most valuable features of Azure Data Factory is the drag-and-drop interface. This helps with workflow management because we can just drag any tables or data sources we need. Because of how easy it is to drag and drop, we can deliver things very quickly. It's more customizable through visual effect."

"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."

"The most valuable feature is the copy activity."

"It's extremely consistent."

"The data flows were beneficial, allowing us to perform multiple transformations."

"It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory."

"The initial setup is very quick and easy."

More Azure Data Factory pros

"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."

"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."

"It has a built-in automatic scheduling environment."

"The most valuable feature is the metadata generated code."

"Data transformations and rollups are easy to accomplish."

"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."

"Naturally produces a way to easily debug your DW data solutions."

More WhereScape RED pros

Cons

"When we initiated the cluster, it took some time to start the process."

"We have experienced some issues with the integration. This is an area that needs improvement."

"The pricing scheme is very complex and difficult to understand."

"Data Factory could be improved in terms of data transformations by adding more metadata extractions."

"The Microsoft documentation is too complicated."

"Data Factory's cost is too high."

"The product's technical support has certain shortcomings, making it an area where improvements are required."

"One area for improvement is documentation. At present, there isn't enough documentation on how to use Azure Data Factory in certain conditions. It would be good to have documentation on the various use cases."

More Azure Data Factory cons

"No support for change data capture or delta detection - that must be custom coded ."

"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."

"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."

"Technical support isn't the best."

"Improve the object renaming ability (it works, but it could be more automated)."

"Customization could be better."

"The solution can be a little more user-friendly on enterprise-level where people use it."

"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."

More WhereScape RED cons

Pricing and Cost Advice

"I rate the product price as six on a scale of one to ten, where one is low price and ten is high price."

"I am aware of the pricing of Azure Data Factory, but I prefer not to disclose specific details."

"The pricing model is based on usage and is not cheap."

"There's no licensing for Azure Data Factory, they have a consumption payment model. How often you are running the service and how long that service takes to run. The price can be approximately $500 to $1,000 per month but depends on the scaling."

"Pricing is comparable, it's somewhere in the middle."

"The licensing model for Azure Data Factory is good because you won't have to overpay. Pricing-wise, the solution is a five out of ten. It was not expensive, and it was not cheap."

"The pricing is a bit on the higher end."

"The cost is based on the amount of data sets that we are ingesting."

More Azure Data Factory pricing and cost advice

"Speed to market of a warehouse solution at a relatively inexpensive price point."

"ROI is at least 10 times."

"Factor in the price of specialized consulting who know this product. They're hard to find and expensive."

"Our company purchased a corporate unlimited license."

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

824,053 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

13%

Computer Software Company

12%

Manufacturing Company

Healthcare Company

Financial Services Firm

19%

Insurance Company

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

How do you select the right cloud ETL tool?

AWS Glue and Azure Data factory for ELT best performance cloud services.

See all answers

How does Azure Data Factory compare with Informatica PowerCenter?

Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...

See all answers

How does Azure Data Factory compare with Informatica Cloud Data Integration?

Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...

See all answers

Ask a question

Earn 20 points

Comparisons

Informatica PowerCenter vs Azure Data Factory

Compared 13% of the time

Snowflake vs Azure Data Factory

Compared 10% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Azure Data Factory

Compared 8% of the time

Alteryx Designer vs Azure Data Factory

Compared 7% of the time

IBM InfoSphere DataStage vs Azure Data Factory

Compared 4% of the time

More Azure Data Factory Competitors

Informatica PowerCenter vs WhereScape RED

Compared 21% of the time

SSIS vs WhereScape RED

Compared 10% of the time

Matillion ETL vs WhereScape RED

Compared 9% of the time

Denodo vs WhereScape RED

Compared 6% of the time

Talend Open Studio vs WhereScape RED

Compared 6% of the time

More WhereScape RED Competitors

Product Reports

Buyer's Guide

Azure Data Factory

December 2024

Download Azure Data Factory product report

Buyer's Guide

WhereScape RED

November 2024

Download WhereScape RED product report

Learn More

Microsoft

Video not available

WhereScape

Overview

Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.

WhereScape is data warehouse software that automates the Data Warehouse lifecycle. From implementation to maintenance, WhereScape will ensure your data warehouse projects are completed up to 5x faster than manual coding.

Sample Customers

1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa

British American Tobacco, Cornell University, Allianz Benelux, Finnair, Solarwinds and many more.

Buyer's Guide

Azure Data Factory vs. WhereScape RED

December 2024

Free Report: Azure Data Factory vs. WhereScape RED

Find out what your peers are saying about Azure Data Factory vs. WhereScape RED and other solutions. Updated: December 2024.

DOWNLOAD NOW

824,053 professionals have used our research since 2012.

See our Azure Data Factory vs. WhereScape RED report.

See our list of best Data Integration vendors.

We monitor all Data Integration 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.