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."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."
"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."
"We can customize any workflow and we also like the business domain modeling that can be done."
"It's a competent product."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"It is easy to set up. The deployment is also very quick."
"The interface is very user-friendly."
"SSIS' most valuable feature is its reporting services."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"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."
"The most valuable feature is the metadata generated code."
"Naturally produces a way to easily debug your DW data solutions."
"Support is absolutely excellent, efficient, and timely."
"I found the initial setup very easy."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"The tool supports multiple target update methods."
"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."
"There is room for improvement in terms of pricing and faster support."
"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."
"Tuning using this solution requires extensive expertise to improve performance."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"Improvement as per customer requirements."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"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."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Customization could be better."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
Earn 20 points