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."You can always manipulate a lot of things as long as you have the skill level."
"I have worked with Data Services for a long time, and currently, I find the dashboarding and reporting part to be the most valuable function."
"It is a powerful product with a broad range of features."
"I like how SAP Data Services links reporting and data integration. That's what's most interesting. You also have the opportunity to leverage the power of the Data Services server."
"The API tool in this product is very valuable; it is very easy to onboard and use."
"The initial setup is not complex."
"It's easy to understand and deploy. It's easy to create new applications, and depending on the complexity of the application, it is easy to deploy the new requirements."
"The product's most valuable features are data validation and rules."
"Overall, it's a good product."
"The performance and stability are good."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The scalability of SSIS is good."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The solution is stable."
"The interface is very user-friendly."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"We encounter challenges while exporting implemented rules, such as those applied to objects like the material master, into a format like Excel for documentation and further analysis."
"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."
"There needs to be multi-language support, however, my understanding is they are working on multi-language now."
"Source code control is another headache. When your source code base gets too large, managing the source code becomes cumbersome."
"The skillset of data engineers matters a bit to use all the functionality of this solution. Otherwise, the delivery speed won't be faster."
"An area for improvement in SAP Data Services could involve making the product more accessible to non-technical end-users."
"In the future, Data Services should offer a cloud version."
"Scheduling of jobs in the sequence is not available. It's a very tedious process to do that particular task. If there was a tool to schedule in the sequence that would be extremely helpful."
"We'd like them to develop data exploration more."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"We have issues with SSIS connectors while extracting data from Excel sources."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"At one point, we did have to purchase an add-on."
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.