No more typing reviews! Try our Samantha, our new voice AI agent.

SAP Replication Server vs SSIS comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

SAP Replication Server
Ranking in Data Integration
56th
Average Rating
8.0
Reviews Sentiment
7.0
Number of Reviews
7
Ranking in other categories
Database Development and Management (21st)
SSIS
Ranking in Data Integration
2nd
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
76
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2026, in the Data Integration category, the mindshare of SAP Replication Server is 1.0%, up from 0.7% compared to the previous year. The mindshare of SSIS is 4.0%, down from 5.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
SSIS4.0%
SAP Replication Server1.0%
Other95.0%
Data Integration
 

Featured Reviews

GagandeepSingh3 - PeerSpot reviewer
Principal Engineer at a tech services company with 1,001-5,000 employees
Good at handling replication, provides cross-database replication but SAP can provide better support for cross-database replication to newer technologies
SAP can provide better support for cross-database replication to newer technologies. The product supports Oracle, but I am not aware of what other technologies it supports. If someone wants to replicate their data from Sybase to a newer technology for data warehousing or other purposes, it would be better if they supported those.
reviewer2318280 - PeerSpot reviewer
Tech Lead at a consultancy with 11-50 employees
Reporting has become streamlined for year-end data checks but integration still needs improvement
When I talk about SQL Server, I am working with SSIS, the data integration tool. I am not entirely sure if I use SSIS as a library of transformations or if I personally work with an extensive library of transformations. I have integrated SSIS with SQL Server Management Studio, and I am very satisfied with the integration as it is integrated well. I am not using the debugging feature in SSIS because the developers would be the ones that would actually utilize it. I have noticed that in 2022, AI functionality has actually been implemented already. I would rate this review overall at a 7.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"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."
"The most valuable thing about this product is that it replicates data between SAP databases (ASE to IQ) very successfully."
"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."
"This product has a catalog with the location of all the objects which were replicated, and it's very simple to maintain."
"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's pretty good at handling replication, even under high load. It also provides cross-database replication, for example, from Sybase to Oracle."
"We use this solution for all kinds of communications like RFC, BAPI, IDoc, connecting with the orders, accounts, finance, data stuff, banking, everything."
"Its easy to use, fast to develop."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"SSIS integrates well with SQL servers and Microsoft products."
"The main benefits SSIS provides for my company is to streamline processes, and the reporting process is the most useful for me, as most of our data is captured into SQL, making it easier to pull the differences in reports for the year."
"SSIS integrates well with SQL servers and Microsoft products, is a cheaper option than other ETL tools, has a lot of in-built transformation, and is easy to learn."
"SSIS is a tool which anybody can learn in no time."
"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
 

Cons

"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."
"It's a very expensive solution."
"There is room for improvement in terms of pricing and faster support."
"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."
"Setup was a little complex."
"There is a need to improve performance in high transactional processes."
"It's complex. It's necessary to understand a little about infrastructure, like network LAN and VLAN environment."
"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."
"This may be done, but upgrades to new versions required re-implementing each package."
"It is an easy solution but needs some improvement. The creation of the measure in the DAC's model could be improved."
"The logging capabilities could be improved, particularly for error logging."
"We have issues with SSIS connectors while extracting data from Excel sources."
"I haven't found too many successful scaling options and that's something that could be improved."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"SSIS, however, is not that compatible with Informatica."
 

Pricing and Cost Advice

"You can pick one of the hosted cloud services as opposed to owning it and doing it yourself. Your cost of ownership on the hardware, the data storage, and the maintenance all go down. It depends on what service you use."
"It's a very expensive solution."
"All of my clients have this product included as part of their Microsoft license."
"People have to opt for a perpetual-based licensing model."
"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."
"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"It would be beneficial if the solution had a less costly cloud offering."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."
"This solution is included with the MSSQL server package."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
920,769 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Construction Company
20%
Comms Service Provider
14%
Outsourcing Company
10%
Financial Services Firm
8%
Financial Services Firm
13%
Manufacturing Company
8%
Outsourcing Company
8%
Construction Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business2
Midsize Enterprise1
Large Enterprise5
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise19
Large Enterprise58
 

Questions from the Community

Ask a question
Earn 20 points
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What is your experience regarding pricing and costs for SSIS?
Pricing is pretty reasonable, so I would rate it at a 5. However, it could be a bit cheaper.
What needs improvement with SSIS?
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly. The initial setup for SSIS is somewhat complex in the beginning, but once you und...
 

Also Known As

Sybase Replication Server
SQL Server Integration Services
 

Overview

 

Sample Customers

Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about SAP Replication Server vs. SSIS and other solutions. Updated: October 2026.
920,769 professionals have used our research since 2012.