We performed a comparison between Azure Data Factory and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."ADF is another ETL tool similar to Informatica that can transform data or copy it from on-prem to the cloud or vice versa. Once we have the data, we can apply various transformations to it and schedule our pipeline according to our business needs. ADF integrates with Databricks. We can call our Databricks notebooks and schedule them via ADF."
"On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
"An excellent tool for pipeline orchestration."
"Data Factory's best features are connectivity with different tools and focusing data ingestion using pipeline copy data."
"The solution can scale very easily."
"I can do everything I want with SSIS and Azure Data Factory."
"The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."
"The data copy template is a valuable feature."
"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."
"Naturally produces a way to easily debug your DW data solutions."
"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."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"I like the data vault implementations."
"The tool supports multiple target update methods."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Data Factory could be improved by eliminating the need for a physical data area. We have to extract data using Data Factory, then create a staging database for it with Azure SQL, which is very, very expensive. Another improvement would be lowering the licensing cost."
"In the next release, it's important that some sort of scheduler for running tasks is added."
"Some of the optimization techniques are not scalable."
"My only problem is the seamless connectivity with various other databases, for example, SAP."
"Data Factory's cost is too high."
"It would be better if it had machine learning capabilities."
"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 product could provide more ways to import and export data."
"Customization could be better."
"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."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Improve the object renaming ability (it works, but it could be more automated)."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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."
Earn 20 points
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while WhereScape RED is ranked 48th in Data Integration. Azure Data Factory is rated 8.0, while WhereScape RED is rated 8.2. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, the top reviewer of WhereScape RED writes "Quick to set up, flexible, and stable". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics, whereas WhereScape RED is most compared with SSIS, Informatica PowerCenter, Matillion ETL, Denodo and Talend Open Studio.
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.