Try our new research platform with insights from 80,000+ expert users

SAP Data Services vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

SAP Data Services
Ranking in Data Integration
10th
Average Rating
8.0
Number of Reviews
48
Ranking in other categories
Data Quality (2nd)
SSIS
Ranking in Data Integration
4th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
71
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of SAP Data Services is 2.9%, down from 3.4% compared to the previous year. The mindshare of SSIS is 8.6%, down from 9.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

RambabuMandala - PeerSpot reviewer
Responsive support, scalable, and beneficial integration
The BA reporting tools, such as Data Services, and ETL tool in SAP Data Services are the most valuable. When we had in-memory requirements, we used HANA. HANA is most preferably for most the customers for in-memory. SAP is the first company that created the in-memory concept. There are a lot of SAP applications and they have good integration with SAP packages. In the next release, they should be more advanced cloud functionalities and web services. More integration with other applications including SAPs and other applications. They should not switch to a complete solution but provide better integration with other applications.
Sakiru Dosumu - PeerSpot reviewer
Its ability to transform and transport data is extremely valuable
he ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The reporting on the data, even from third-party software, is very good."
"The most valuable feature is the logging capability."
"The HANA database, which is very fast, is a valuable feature."
"The product's most valuable features are data validation and rules."
"The most valuable features of SAP Data Services lie in its ability to effectively observe and interpret the information within data related to people or facts, stands out."
"Its integration capabilities and the data migration capabilities are the most valuable. It is very good for SAP and non-SAP tools. It has very good integration with SAP, but it also has the capabilities to connect to other systems. We find it very helpful and stable."
"The basic functionality is quite good as is the basic logic and data information."
"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 most valuable features of this solution are the fast insert and fuzzy logic matching."
"The interface is very user-friendly."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"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."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The UI is very user-friendly."
 

Cons

"Integration with other products could be improved."
"The solution shows a lack of cloud support data services."
"There should be some kind of enhancement that can be done on the admin side of certain sites where we can assign the roles and responsibilities. We should be able to control who is using the tool and how."
"Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity."
"The migration of the solution between different environments is quite complex."
"They could make it easier to work with web services."
"In the future, Data Services should offer a cloud version."
"We would like the different tools offered within this solution to be available as standalone entities, rather than having to purchase the entire package when we only require a few features."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"I would like to see more features in terms of the integration with Azure Data Factory."
"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"It needs more integration tools, so you can connect to different sources."
"We'd like them to develop data exploration more."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"Generic processes should be used instead of custom code for each table."
 

Pricing and Cost Advice

"The price is very reasonable."
"The enterprise version of SAP Data Services is free."
"It's relatively expensive compared to other vendors, but it is competitive."
"Pricing is good, there is no problem."
"At the entry level, if you're using it only for data integration, it is a little bit cheap. However, for large organizations it can be expensive. There are additional costs apart from the license."
"I rate the product price as one or two on a scale of one to ten, where one is a low price, and ten is a high price."
"The price of SAP Data Services is a little high when compared to other solutions. Due to the pricing and capabilities, many clients are switching to other solutions."
"There is a one time purchase fee plus annual maintenance."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."
"This solution is included with the MSSQL server package."
"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"The solution comes free of cost."
"All of my clients have this product included as part of their Microsoft license."
"People have to opt for a perpetual-based licensing model."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Manufacturing Company
15%
Computer Software Company
13%
Financial Services Firm
9%
Energy/Utilities Company
8%
Financial Services Firm
17%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How do you evaluate the ratio of price to quality for SAP Data Services?
I believe the license for the product is fair, even though some competitors offer similar services at lower prices. The difference between the Edge edition and the next one up is significant in pr...
Would you recommend SAP Data Services to complete beginners?
I think after some preparation, a beginner will be able to use SAP Data Services, however, if you are completely unprepared, you may have some issues. I think that in particular you will need a mo...
How has SAP Data Services helped your organization?
SAP Data Services has helped our whole staff understand the data across various sources and systems within the company. Not everyone who works at my organization is an IT expert - most just have av...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
 

Also Known As

SAP BusinessObjects Data Services, SAP BusinessObjects Data Integrator, BusinessObjects Data Integrator
SQL Server Integration Services
 

Learn More

 

Overview

 

Sample Customers

EMC Corporation, LivePerson, Eldorado, Mozzart, The VELUX Group, AOK Bundesverband, Hilti Group, Nissha Printing Company Ltd., Asian Paints, Aareal Bank Group, Migros Group
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about SAP Data Services vs. SSIS and other solutions. Updated: November 2024.
816,406 professionals have used our research since 2012.