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."It is a scalable solution."
"The initial setup is easy."
"With the latest version what I find to be the most valuable are the REST, SuccessFactors, and Ariba Network adapters."
"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."
"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."
"It provides essential features such as continuous monitoring of all interfaces are crucial for our needs."
"Great monitoring tools and has its own alert framework."
"The product has good technical support but you usually will not need it because it is quite stable."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The UI is very user-friendly."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"SSIS integrates well with SQL servers and Microsoft products."
"The setup is straightforward. It's very easy to install."
"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 performance and stability are good."
"It is easy to set up the product."
"Process Orchestration doesn't provide authentication for data sent to us, meaning we have to rely on client certificate-based or basic authentication."
"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 all of the features, such as API management along with process integration to replace what they had previously."
"It is scalable, but there can be performance issues with high data volume or traffic, especially during month ends."
"The solution could be more scalable."
"The usability is an area where it can be improved upon."
"The responsiveness of technical support needs to be improved."
"The solution needs to move to the cloud."
"It does not have all of the industry-standard solutions available in PO and it is not plug and play, so we have to do a lot of development."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"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."
"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."
"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."
"The performance of this solution is not as good as other tools in the market."
"Improvement as per customer requirements."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
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.