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."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."
"We can customize any workflow and we also like the business domain modeling that can be done."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The UI is very user-friendly."
"The initial setup was easy."
"The solution is stable."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The interface is very user-friendly."
"The performance and stability are good."
"Overall, it's a good product."
"There is room for improvement in terms of pricing and faster support."
"I would like to see it become mobile-friendly."
"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."
"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."
"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."
"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 would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"The security could be improved, as it is more important in our context."
"Future releases should improve the data lineage, as it currently is not good."
"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."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
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.