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

SAP Process Orchestration vs SSIS comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

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 Process Orchestration
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
35
Ranking in other categories
Business-to-Business Middleware (7th)
SSIS
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
76
Ranking in other categories
Data Integration (3rd)
 

Mindshare comparison

SAP Process Orchestration and SSIS aren’t in the same category and serve different purposes. SAP Process Orchestration is designed for Business-to-Business Middleware and holds a mindshare of 3.7%, down 6.3% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 4.0% mindshare, down 5.7% since last year.
Business-to-Business Middleware Mindshare Distribution
ProductMindshare (%)
SAP Process Orchestration3.7%
SEEBURGER Business Integration Suite10.2%
MuleSoft Anypoint Platform9.2%
Other76.9%
Business-to-Business Middleware
Data Integration Mindshare Distribution
ProductMindshare (%)
SSIS4.0%
Informatica Intelligent Data Management Cloud (IDMC)3.8%
Informatica PowerCenter3.6%
Other88.6%
Data Integration
 

Featured Reviews

Vasanth Kumar Sabaapathi - PeerSpot reviewer
Senior Lead Architect at a manufacturing company with 1,001-5,000 employees
Simplified integrations bring flexibility and efficiency to diverse industries through comprehensive features and robust support
SAP is already trying to make improvements for SAP Process Orchestration by releasing updates every quarter, including patches and modules, and from a security standpoint, while it's a tightly coupled tool, they are introducing a lot of enhancements aligned with current market trends. There are standard contents readily available for starting integrations, which suit around 90% of every industry across verticals including pharma, manufacturing, and employee data central with SuccessFactors integration. Regarding functionality-wise improvements in SAP Process Orchestration, they are now incorporating the Salesforce system. Previously, we needed to rely on a third-party adapter for integration within SAP, but now they are building their own adapters to connect with Salesforce. Additionally, there are options like data connectors using Ariba coming up with SAP Process Orchestration. There's much more to explore, especially as they release new patches, enhancements, and adapters each quarter.
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

"The product has good technical support but you usually will not need it because it is quite stable."
"The most valuable feature of SAP Process Orchestration is its flexibility in being able to build integrations with SAP systems and non-SAP systems."
"The support from SAP Process Orchestration is very helpful."
"The stability of the product is very good; there are no bugs or glitches, it doesn't crash or freeze, and it's reliable."
"Process Orchestration fulfils the need for middleware to mediate types of connectivity."
"It is simple to transfer files."
"I think it is a very stable tool. My company did not have any problem with the tool."
"The solution is easy to use."
"The initial setup of this solution is very straightforward."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The most valuable feature of the solution is performance."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The most valuable thing is that it is easy to connect with Microsoft tools."
"The data flow, which controls the data, including where to store it, is an excellent feature and is one of the most interesting points about SQL Integration Services."
 

Cons

"I think the main area that SAP PO should improve on is offering pre-delivered content like they do when you use SAP Cloud Platform Integration (CPI). SAP should not forget that they still have a lot of customers using Process Orchestration and they should focus more on providing pre-delivered content in SAP PO."
"The main issue is that these products, which evolved from Process Integration to SAP Process Orchestration, will be replaced and will have no support in the future."
"Its administration management feature needs to be simpler to use."
"The monitoring governance offered by SAP is too technical and needs to be geared more toward business users."
"It's very difficult to find errors in a simple way."
"The solution could be more scalable."
"This is an on-premise platform and one area they can improve on is having the ability to work with SaaS solutions."
"Some configurations can be a little tricky."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The performance of this solution is not as good as other tools in the market."
"It would be nice if you could run SSIS on other environments besides Windows."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"If you run SSIS from the local system, it will lag, but it will work properly if you host on the cloud somewhere."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"I'm not a fan of SSIS itself."
 

Pricing and Cost Advice

"The fee for maintenance is costly."
"The pricing depends on what type of client you are with SAP and the contract you have. There is a licensing cost that needs to be paid."
"It's not an expensive solution."
"The price of SAP Process Orchestration was reasonable."
"The pricing for this solution is fine."
"It is a very expensive solution. We only pay for the license."
"We subscribe to annual licenses, and the competitive license cost is reasonable."
"My company deals with different pricing models of the product, according to which we don't pay for the solution directly, but we do pay for the maintenance part."
"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."
"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."
"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."
"All of my clients have this product included as part of their Microsoft license."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
report
Use our free recommendation engine to learn which Business-to-Business Middleware solutions are best for your needs.
915,341 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
Comms Service Provider
10%
Manufacturing Company
9%
Outsourcing Company
9%
Construction Company
9%
Financial Services Firm
13%
Construction Company
8%
Manufacturing Company
8%
Outsourcing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business8
Midsize Enterprise3
Large Enterprise26
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise19
Large Enterprise58
 

Questions from the Community

What is your experience regarding pricing and costs for SAP Process Orchestration?
The price for SAP Process Orchestration is a little high when compared to market trends, which is just how the business is. I would rate it an eight.
What needs improvement with SAP Process Orchestration?
SAP is already trying to make improvements for SAP Process Orchestration by releasing updates every quarter, including patches and modules, and from a security standpoint, while it's a tightly coup...
What is your primary use case for SAP Process Orchestration?
The main use case for SAP Process Orchestration is that it's an SAP proprietary tool which integrates within SAP and outside SAP. It's the most familiar middleware tool which is used for integrations.
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

SAP NetWeaver Process Integration, NetWeaver Process Integration
SQL Server Integration Services
 

Overview

 

Sample Customers

Lenovo, Dansk Supermarked A/S, Ego Pharmaceuticals Pty. Ltd, Kaeser Kompressoren
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 Informatica, Seeburger, Salesforce and others in Business-to-Business Middleware. Updated: September 2026.
915,341 professionals have used our research since 2012.