We performed a comparison between SAP Data Services and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature is the logging capability."
"The most valuable feature of SAP Data Services is the integration with data sources."
"The solution is easy to use since it's a graphical tool. It also requires only low-level coding."
"The initial setup is not complex."
"The product's most valuable features are data validation and rules."
"The fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth."
"I appreciate having access to the SAP data."
"The maintenance of data services is the solution's most valuable feature."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The data reader is the most valuable feature."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"We can connect with multiple data sources easily using an external connector in SSIS."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The technical support is very good."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"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 interface is not quite user-friendly and is in need of improvement."
"Integration with other products could be improved."
"The migration of the solution between different environments is quite complex."
"Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity."
"The description of error messages isn't extensive, although they point to the problem. With other solutions, like Talend, I was able to use the debugger to get directly to the problem, but with SAP Data Services the debugger is not working. I'm not sure if it's a problem with the version specifically, but I'm using it in an enterprise environment and I can't do an upgrade."
"It would be nice if this solution was a bit easier to move from development to production."
"They could make it easier to work with web services."
"At the integration level, there could be certain set of improvement to connect to various other systems."
"I would like to see better technical documentation because many times information is missing."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"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."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"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."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
SAP Data Services is ranked 10th in Data Integration with 45 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. SAP Data Services is rated 8.0, while SSIS is rated 7.6. The top reviewer of SAP Data Services writes "Responsive support, scalable, and beneficial integration". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". SAP Data Services is most compared with Azure Data Factory, Syniti Data Quality, Informatica PowerCenter, SAP Process Orchestration and IBM InfoSphere DataStage, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and FME. See our SAP Data Services vs. SSIS report.
See our list of best Data Integration vendors.
We monitor all 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.