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."The main benefit is that the solution is low maintenance. Moreover, it's the license cost is very low because it's part of the package. The maintenance is standard maintenance. And the updates are regular. So there's a regular update and you can choose whether you want to do those updates or not."
"The solution provides very good and central logging systems. It offers high flexibility with vertical and horizontal extend capacity."
"The product has good technical support but you usually will not need it because it is quite stable."
"SAP Process Orchestration has all the features that are necessary."
"Process Orchestration fulfils the need for middleware to mediate types of connectivity."
"The standard adapter with EBA abilities is the most valuable feature. It has good process integration."
"The solution offers very good documentation and manuals to assist with understanding the solution."
"The solution's technical support is good."
"The initial setup of this solution is very straightforward."
"The scalability of SSIS is good."
"SSIS is easy to use."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"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."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The technical support is very good."
"It's very difficult to find errors in a simple way."
"The cloud capability features need improvement."
"The product roadmap suggests it will approach the end of support in several years, and a lot of innovations are now implemented by SAP not in SAP PO, but in SAP Integration Suite, hence, the platform is stable, but doesn't receive a lot of new features in recent updates."
"The older version of the solution will no longer be supported."
"Process Orchestration needs to provide secure connectivity as no one has any data information."
"This is an on-premise platform and one area they can improve on is having the ability to work with SaaS solutions."
"We encounter challenges while connecting to MQTT and MQDD adapters."
"It would be beneficial to enhance the ease of implementing new projects and improve overall stability in our implementations."
"At one point, we did have to purchase an add-on."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"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."
"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."
"The performance of SSIS could improve when comparing it to Oracle Database."
SAP Process Orchestration is ranked 1st in Business-to-Business Middleware with 28 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. SAP Process Orchestration is rated 8.2, while SSIS is rated 7.6. The top reviewer of SAP Process Orchestration writes "A tool that can be useful for small integrations and large integrations". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". SAP Process Orchestration is most compared with Mule Anypoint Platform, SAP Data Services, webMethods Integration Server, IBM Sterling B2B Integration Services and IBM B2B Integrator, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. 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.