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 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 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."
"SSIS' most valuable feature is its reporting services."
"The initial setup of this solution is very straightforward."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"SSIS' best feature is SFTP connectivity."
"It is easy to set up the product."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It is easy to set up. The deployment is also very quick."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"I would like to see it become mobile-friendly."
"There is room for improvement in terms of pricing and faster support."
"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."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"Performance could be better."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"We'd like more integration capabilities."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"Options for scaling could be improved."
"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."
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, SAP Data Services and Azure Data Factory, 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.