IT Central Station is now PeerSpot: Here's why

SAP Process Orchestration vs SSIS comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
Read 16 SSIS reviews
25,772 views|19,937 comparisons
Featured Review
Buyer's Guide
Cloud Data Integration
June 2022
Find out what your peers are saying about MuleSoft, Amazon, Informatica and others in Cloud Data Integration. Updated: June 2022.
610,518 professionals have used our research since 2012.
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 standard adapter with EBA abilities is the most valuable feature. It has good process integration.""SAP Process Orchestration is middleware where we are able to manage and interact with everything from a single location. One of the most beneficial areas is monitoring which is very easy because it is all in one place. There are many adapters added recently that can be used for new functionality. The solution is easy to operate and it is more mature than the cloud solution provided by SAP.""The solution offers very good documentation and manuals to assist with understanding the solution.""The initial setup was straightforward.""The solution provides very good and central logging systems. It offers high flexibility with vertical and horizontal extend capacity.""The solution is stable.""With the latest version what I find to be the most valuable are the REST, SuccessFactors, and Ariba Network adapters."

More SAP Process Orchestration Pros →

"The performance and stability are good.""The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products.""The technical support is very good.""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.""It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better.""The interface is very user-friendly.""It's a competent product.""You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."

More SSIS Pros →

Cons
"In terms of technical support, it would be helpful if they handled the tickets a bit faster when queries are sent to them.""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 cloud capability features need improvement.""The solution is not very scalable because it is at the end of its life.""The solution could improve by making it more user-friendly by limiting the code required. We have to add some code in some cases where we need complex logic or some other functions. If this was able to be done in a more simplified manner then it would save a lot of effort and time.""The usability is an area where it can be improved upon.""The solution could be more scalable.""It is not a scalable solution for the cloud. I would not recommend this for the cloud."

More SAP Process Orchestration Cons →

"I would like to see more features in terms of the integration with Azure Data Factory.""It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well.""It's a legacy tool, that is nearing the end of its useful life.""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.""Options for scaling could be improved.""I would like to see better integration with Power BI.""The solution could improve on integrating with other types of data sources.""The security could be improved, as it is more important in our context."

More SSIS Cons →

Pricing and Cost Advice
  • "There are fees in addition to the licensing."
  • "It's not an expensive solution."
  • "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."
  • "The license is a one-time payment, and additional costs are only incurred on the infrastructure side since it's an on-premise solution."
  • "The price of SAP Process Orchestration was reasonable."
  • More SAP Process Orchestration Pricing and Cost Advice →

  • "It would be beneficial if the solution had a less costly cloud offering."
  • "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."
  • "We have an enterprise license for this solution."
  • "It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
  • "All of my clients have this product included as part of their Microsoft license."
  • "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."
  • "SSIS is a cheaper option compared to the cost of other ETL tools."
  • More SSIS Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    610,518 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The most valuable features of SAP Process Orchestration are the standard APIs that we can use.
    Top Answer:SAP Process Orchestration could improve from an API standpoint. This is not an API management tool, which is one of its drawbacks. However, SAP has released an SAP Cloud Platform Integration which has… more »
    Top Answer: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… more »
    Top Answer:What is the OLAP that you are using? Hosted in Cloud or on-premise?  The target DB should have its tool to extract data.
    Top Answer:SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together.
    Ranking
    Views
    9,202
    Comparisons
    5,859
    Reviews
    11
    Average Words per Review
    654
    Rating
    7.9
    3rd
    Views
    25,772
    Comparisons
    19,937
    Reviews
    16
    Average Words per Review
    494
    Rating
    7.9
    Comparisons
    Also Known As
    SAP NetWeaver Process Integration, NetWeaver Process Integration
    SQL Server Integration Services
    Learn More
    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.

    SQL Server Integration Services (SSIS) is a Microsoft platform designed to build enterprise-level data integration and data transformation solutions. Users now have the ability to solve intricate business queries by downloading and copying files, cleansing and mining data, loading data warehouses, and managing SQL Server objects and data through Integration Services. SSIS is a component of the Microsoft SQL Server data software used for many data migration tasks.

    SSIS loads data into one or more destinations by extracting and transforming data from a wide variety of sources such as XML data files, flat files, and relational data sources.

    Integration Services include:

    • An SSIS catalog database to manage, store, and run packages.
    • An ample set of built-in transformations and tasks.
    • Graphical tools for building packages.

    Create packages programmatically and code custom tasks through programming the extensive Integration Services. With graphical Integration Services, you can create solutions without writing any code.

    Benefits of SSIS

    There are many benefits of SSIS, such as:

    • Solve complex business problems - encrypt files with SSIS and send them to various network locations.

    • Migration of DTS packages to SSIS - users can migrate DTS packages to SSIS while choosing to run DTS packages using DTS runtime or incorporate DTS packages into SSIS.

    • Development of ETL processes - Microsoft’s SSIS packages provide the ability to extract, transform, and load data into data warehouses. This service takes data from various sources, like CSV files, XML files, flat files, and relational data sources and transforms and loads them to their destinations.

    • Data migration from other databases - with Integrations Services, users can transform data to make sure it complies with the rules of the database they are migrating to.

    • Managing and automating SQL server objects - SSIS packages can manage and automate SQL server objects which will help save you time and resources.

    Reviews from Real Users

    The SSIS platform stands out among its competitors for a variety of reasons. Two major ones are its debugging capabilities during data flow execution and its easy connectivity with other Microsoft tools.

    Muhammad J., a senior manager software developer at Techlogix, notes, "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."

    Ismail L., a data engineer at a tech service company, writes, "The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."

    Offer
    Learn more about SAP Process Orchestration
    Learn more about SSIS
    Sample Customers
    Lenovo, Dansk Supermarked A/S, Ego Pharmaceuticals Pty. Ltd, Kaeser Kompressoren
    PKP Energetyka, UniCredit Bank, Mostar, waldwasser, Ashok leyland, Florida Atlantic University, Stadt Frankfurt am Main
    Top Industries
    REVIEWERS
    Computer Software Company23%
    Manufacturing Company23%
    Energy/Utilities Company15%
    Recreational Facilities/Services Company8%
    VISITORS READING REVIEWS
    Computer Software Company30%
    Comms Service Provider12%
    Manufacturing Company9%
    Energy/Utilities Company8%
    REVIEWERS
    Financial Services Firm25%
    Healthcare Company9%
    Insurance Company9%
    Retailer9%
    VISITORS READING REVIEWS
    Computer Software Company22%
    Comms Service Provider14%
    Financial Services Firm12%
    Government6%
    Company Size
    REVIEWERS
    Small Business28%
    Large Enterprise72%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise14%
    Large Enterprise73%
    REVIEWERS
    Small Business28%
    Midsize Enterprise22%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise68%
    Buyer's Guide
    Cloud Data Integration
    June 2022
    Find out what your peers are saying about MuleSoft, Amazon, Informatica and others in Cloud Data Integration. Updated: June 2022.
    610,518 professionals have used our research since 2012.

    SAP Process Orchestration is ranked 3rd in Business-to-Business Middleware with 11 reviews while SSIS is ranked 3rd in Data Integration Tools with 16 reviews. SAP Process Orchestration is rated 8.0, while SSIS is rated 7.8. The top reviewer of SAP Process Orchestration writes "Gateway for all integrations that is stable and quick to install". On the other hand, the top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". SAP Process Orchestration is most compared with Mule Anypoint Platform, SAP Data Services, webMethods Integration Server, IBM Sterling B2B Integration Services and SEEBURGER Business Integration Suite, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and AWS Glue.

    See our list of best Cloud Data Integration vendors.

    We monitor all Cloud 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.