SAP Process Orchestration vs SSIS comparison

The compared SAP and Microsoft solutions aren't in the same category. SAP is ranked #2 in BBM , with an average rating of 8.2, and holds a 9.0% mindshare in the category. Microsoft is ranked #4 in DI , with an average rating of 8.0, and holds a 8.0% mindshare. Additionally, 91% of SAP users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

SAP Process Orchestration

Read 32 SAP Process Orchestration reviews

2,669 Views
1,114 Comparison Views

91% willing to recommend

SSIS

Read 72 SSIS reviews

13,122 Views
10,210 Comparison Views

79% willing to recommend

SAP Process Orchestration

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between SAP Process Orchestration and SSIS based on real PeerSpot user reviews.

Find out in this report how the two Business-to-Business Middleware solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed SAP Process Orchestration vs. SSIS Report (Updated: January 2025).

Buyer's Guide

SAP Process Orchestration vs. SSIS

January 2025

Download the complete report

Helped 837,501 peers since 2012

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

7.2

Number of Reviews

Ranking in other categories

Business-to-Business Middleware (2nd)

SSIS

Average Rating

7.6

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Data Integration (4th)

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 9.0%, down 13.7% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 8.0% mindshare, up 8.0% since last year.

Business-to-Business Middleware

Data Integration

Featured Reviews

Laxman Molugu

Chief Executive Officer at Saanvi systems inc

Enhances operational efficiency with valuable prepackaged content and cost-effective pricing

For organizations that operate within an SAP ecosystem, SAP Process Orchestration is recommended due to its cost-effectiveness and the availability of valuable prepackaged content. It is important to consider the needs of your industry, as SAP Process Orchestration may not meet all requirements in consumer-oriented sectors. I'd rate the solution eight out of ten.

Read full review

BobAmy

Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

Robust and does a good job of handling overload conditions

We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

Read full review

Quotes from Members

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

Pros

"SAP Process Orchestration has all the features that are necessary."

"The solution provides very good and central logging systems. It offers high flexibility with vertical and horizontal extend capacity."

"The solution is easy to use."

"With the latest version what I find to be the most valuable are the REST, SuccessFactors, and Ariba Network adapters."

"Orchestration is beneficial for us."

"The solution's technical support is good."

"The most valuable feature is the seamless integration with backend systems."

"The initial setup is easy...The solution gets automatically connected. The deployment takes six months. I rate its setup phase a ten out of ten."

More SAP Process Orchestration pros

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"It is easy to set up the product."

"Overall, it's a good product."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

"The simplicity of the solution is great. The solution also offers excellent integration."

More SSIS pros

Cons

"Its administration management feature needs to be simpler to use."

"It is not a scalable solution for the cloud. I would not recommend this for the cloud."

"We encounter challenges while connecting to MQTT and MQDD adapters."

"The older version of the solution will no longer be supported."

"Process Orchestration doesn't provide authentication for data sent to us, meaning we have to rely on client certificate-based or basic authentication."

"It's very difficult to find errors in a simple way."

"The cloud capability features need improvement."

"The solution is not very scalable because it is at the end of its life."

More SAP Process Orchestration cons

"The security could be improved, as it is more important in our context."

"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."

"I would like to see more features in terms of the integration with Azure Data Factory."

"Improvement as per customer requirements."

"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."

"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."

"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."

More SSIS cons

Pricing and Cost Advice

"Looking at market conditions, vendors nowadays are giving products at very low price levels. However, SAP Process Orchestration have not yet reduced their prices. The prices could be reduced a lot to stay competitive."

"It's not an expensive solution."

"Normally, you will have to choose CPU-based licensing...I rate the tool price a five out of ten."

"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."

"The product is not a low-priced solution, but I can say that it is competitively priced in the market."

"There are fees in addition to the licensing."

"The cost of SAP products is quite high but the quality is really good."

"The pricing for this solution is fine."

More SAP Process Orchestration pricing and cost advice

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"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."

"It would be beneficial if the solution had a less costly cloud offering."

"We have an enterprise license for this solution."

"This solution is included with the MSSQL server package."

"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."

"The solution is available at a lesser price than that of Informatica."

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Business-to-Business Middleware solutions are best for your needs.

See recommendations

837,501 professionals have used our research since 2012.

Comparison Review

it_user90069

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…

Read full review

Top Industries

By visitors reading reviews

Manufacturing Company

18%

Computer Software Company

15%

Financial Services Firm

Energy/Utilities Company

Financial Services Firm

18%

Computer Software Company

12%

Government

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about SAP Process Orchestration?

It provides essential features such as continuous monitoring of all interfaces are crucial for our needs.

See all answers

What is your experience regarding pricing and costs for SAP Process Orchestration?

The main concern is the cost. If additional help is needed due to lack of skill, we have to pay for SAP support.

See all answers

What needs improvement with SAP Process Orchestration?

There are two main areas for improvement: performance and cost. The cost is quite high, and if it were reduced, it might also improve the performance, potentially allowing us to access a more effic...

See all answers

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...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

What is your experience regarding pricing and costs for SSIS?

The solution comes free of cost.

See all answers

Comparisons

SAP Data Services vs SAP Process Orchestration

Compared 18% of the time

MuleSoft Anypoint Platform vs SAP Process Orchestration

Compared 15% of the time

IBM Sterling B2B Integration Services vs SAP Process Orchestration

Compared 12% of the time

webMethods.io vs SAP Process Orchestration

Compared 12% of the time

IBM App Connect vs SAP Process Orchestration

Compared 6% of the time

More SAP Process Orchestration Competitors

Informatica PowerCenter vs SSIS

Compared 21% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

AWS Glue vs SSIS

Compared 4% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

SAP Process Orchestration

January 2025

Download SAP Process Orchestration product report

Buyer's Guide

SSIS

January 2025

Download SSIS product report

Also Known As

SAP NetWeaver Process Integration, NetWeaver Process Integration

SQL Server Integration Services

Overview

SAP NetWeaver Process Integration facilitates the integration of business processes that span different departments, organizations, or companies. SAP PI is based on general standards so as to enable 3rd-party systems to be integrated. At the center of SAP PI is an XML-based communication that uses HTTP (Hyper Text Transfer Protocol). Irrespective of the scenario used, the application-specific contents are transferred in messages in user-defined XML eXtensible Markup Language) from the sender to the receiver either via the Integration Server, or directly between the systems involved. SAP PI can be installed in different ways: Dual usage type installation: Based on both AS ABAP and AS Java. and Advanced Adapter Engine Extended (AEX): Based on AS Java only.

SAP

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Microsoft

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

Buyer's Guide

SAP Process Orchestration vs. SSIS

January 2025

Free Report: SAP Process Orchestration vs. SSIS

Find out what your peers are saying about SAP Process Orchestration vs. SSIS and other solutions. Updated: January 2025.

DOWNLOAD NOW

837,501 professionals have used our research since 2012.

See our SAP Process Orchestration vs. SSIS report.

We monitor all Business-to-Business Middleware 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.