We performed a comparison between SAP Replication Server and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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 Replication Server is an application that I consider to be a robust system. It has proven to be highly reliable in my experience."
"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 is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It is easy to set up the solution."
"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."
"SSIS' most valuable feature is its reporting services."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The initial setup was easy."
"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."
"I would like to see it become mobile-friendly."
"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."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"This solution needs full support for real-time processing."
"The security could be improved, as it is more important in our context."
"Generic processes should be used instead of custom code for each table."
"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."
"The creation of the measure in the DAC's model could be improved."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
SAP Replication Server is ranked 27th in Data Integration with 6 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. SAP Replication Server is rated 8.2, while SSIS is rated 7.6. The top reviewer of SAP Replication Server writes "Eliminates replication and allows you to use only one database, speeding up performance and reducing amount of storage". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". SAP Replication Server is most compared with Qlik Replicate, Oracle GoldenGate, Fivetran, Azure Data Factory and SAP Data Services, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our SAP Replication Server vs. SSIS report.
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.