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."The solution has a good interface and the integration with GitHub is very useful."
"This solution has provided us with an easier, and more efficient way to carry out data migration tasks."
"Azure Data Factory's most valuable features are the packages and the data transformation that it allows us to do, which is more drag and drop, or a visual interface. So, that eases the entire process."
"The data mapping and the ability to systematically derive data are nice features. It worked really well for the solution we had. It is visual, and it did the transformation as we wanted."
"It is beneficial that the solution is written with Spark as the back end."
"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."
"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."
"The data factory agent is quite good and programming or defining the value of jobs, processes, and activities is easy."
"Data transformations and rollups are easy to accomplish."
"Support is absolutely excellent, efficient, and timely."
"Naturally produces a way to easily debug your DW data solutions."
"I like the data vault implementations."
"The most valuable feature is the metadata generated code."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"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."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
"I would like to be informed about the changes ahead of time, so we are aware of what's coming."
"Data Factory's cost is too high."
"There are limitations when processing more than one GD file."
"Data Factory has so many features that it can be a little difficult or confusing to find some settings and configurations. I'm sure there's a way to make it a little easier to navigate."
"The speed and performance need to be improved."
"Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful."
"Lacks a decent UI that would give us a view of the kinds of requests that come in."
"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."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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 solution can be a little more user-friendly on enterprise-level where people use it."
"Customization could be better."
"No support for change data capture or delta detection - that must be custom coded ."
"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."
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 Informatica PowerCenter, SSIS, Matillion ETL, Talend Open Studio and Denodo.
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.
