We performed a comparison between SAP Data Services 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 fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth."
"You can always manipulate a lot of things as long as you have the skill level."
"The feature of SAP Data Services has enhanced our company's business processes because we are able to run around 800 jobs in areas like data extraction and transaction objects."
"Data Services' table comparison mechanism is very powerful. It's pretty hard to find a similar feature in other solutions."
"The most valuable features of SAP Data Services lie in its ability to effectively observe and interpret the information within data related to people or facts, stands out."
"The product's most valuable features are data validation and rules."
"I have worked with Data Services for a long time, and currently, I find the dashboarding and reporting part to be the most valuable function."
"The solution offers very good integration capabilities."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Data transformations and rollups are easy to accomplish."
"The tool supports multiple target update methods."
"Naturally produces a way to easily debug your DW data solutions."
"The most valuable feature is the metadata generated code."
"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."
"I found the initial setup very easy."
"Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity."
"At the integration level, there could be certain set of improvement to connect to various other systems."
"It will work fine only in an SAP environment. It could be said that the integration with other vendors could be better."
"The interface is not quite user-friendly and is in need of improvement."
"The description of error messages isn't extensive, although they point to the problem. With other solutions, like Talend, I was able to use the debugger to get directly to the problem, but with SAP Data Services the debugger is not working. I'm not sure if it's a problem with the version specifically, but I'm using it in an enterprise environment and I can't do an upgrade."
"The initial setup is complex."
"Some of the jobs that are built within Data Services require local files, and during initial deployment, those local files cannot be transported between machines simply because of security issues."
"We would like the different tools offered within this solution to be available as standalone entities, rather than having to purchase the entire package when we only require a few features."
"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."
"No support for change data capture or delta detection - that must be custom coded ."
"Customization could be better."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"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
SAP Data Services is ranked 10th in Data Integration with 45 reviews while WhereScape RED is ranked 48th in Data Integration. SAP Data Services is rated 8.0, while WhereScape RED is rated 8.2. The top reviewer of SAP Data Services writes "Responsive support, scalable, and beneficial integration". On the other hand, the top reviewer of WhereScape RED writes "Quick to set up, flexible, and stable". SAP Data Services is most compared with Azure Data Factory, Syniti Data Quality, Informatica PowerCenter, SAP Process Orchestration and Palantir Foundry, whereas WhereScape RED is most compared with Azure Data Factory, Informatica PowerCenter, SSIS, Matillion ETL and Ab Initio Co>Operating System.
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.