We performed a comparison between SAP Replication Server, SSIS, 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."We can customize any workflow and we also like the business domain modeling that can be done."
"SAP is renovating different things. We are using external tools to connect as of now. It is going well, and now the new generation integration platforms are going to be pretty easy."
"SAP Replication Server is an application that I consider to be a robust system. It has proven to be highly reliable in my experience."
"It speeds up the performance in terms of how fast you are able to access the data, look at it, get it reported to you, and send it to somebody. It also reduces the amount of storage."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The solution is stable."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The setup is straightforward. It's very easy to install."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The product's deployment phase is easy."
"I found the initial setup very easy."
"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."
"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."
"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."
"Data transformations and rollups are easy to accomplish."
"I would like to see it become mobile-friendly."
"Improvement is a never ending story, and HANA is doing some improvements. We are able to adopt that, and we have to do it by integration with HANA. They are very major changes that we need to see."
"The private solution is expensive. If you're in a situation where you're paying IBM or AWS or somebody just to host you specifically, you're paying people to run it and you're taking care of all the upgrades."
"There is room for improvement in terms of pricing and faster support."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"It needs more integration tools, so you can connect to different sources."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"It's a legacy tool, that is nearing the end of its useful life."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"We have issues with SSIS connectors while extracting data from Excel sources."
"At one point, we did have to purchase an add-on."
"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."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Improve the object renaming ability (it works, but it could be more automated)."
"Customization could be better."
Earn 20 points