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."t is a pretty stable solution. I have not seen any outages in the solution."
"The solution's technical support is good."
"In my opinion, SAP PO is the most mature suite of tools to integrate processes across SAP environments at this moment. It's really unbeatable because it allows you to integrate whatever scenarios you can imagine."
"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."
"The solution is stable."
"The most valuable features of SAP Process Orchestration are its system monitoring and alerts."
"The initial setup is easy."
"It is strategically focused to forecast a global integration platform for our business."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"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."
"SSIS' best feature is SFTP connectivity."
"The simplicity of the solution is great. The solution also offers excellent integration."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"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 interface is very user-friendly."
"The monitoring governance offered by SAP is too technical and needs to be geared more toward business users."
"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."
"It requires some maintenance."
"In terms of technical support, it would be helpful if they handled the tickets a bit faster when queries are sent to them."
"Data modeling is an area of concern in the product where improvements are required."
"SAP Process Orchestration breaks down sometimes."
"Process Orchestration doesn't provide authentication for data sent to us, meaning we have to rely on client certificate-based or basic authentication."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"I would like to see better integration with Power BI."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
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, IBM Sterling B2B Integration Services, webMethods Integration Server 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.