Compare SAP Data Services vs. SSIS

Cancel
You must select at least 2 products to compare!
SAP Data Services Logo
9,168 views|7,099 comparisons
SSIS Logo
Read 20 SSIS reviews.
34,023 views|26,854 comparisons
Most Helpful Review
Find out what your peers are saying about SAP Data Services vs. SSIS and other solutions. Updated: September 2020.
437,064 professionals have used our research since 2012.
Quotes From Members

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

Pros
The solution offers very good integration capabilities.The most valuable feature is the logging capability.The reporting on the data, even from third-party software, is very good.The maintenance of data services is the solution's most valuable feature.The HANA database, which is very fast, is a valuable feature.It is a powerful product with a broad range of features.The user interface is ok.The fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth.

More SAP Data Services Pros »

The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline.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 most valuable features of this solution are the fast insert and fuzzy logic matching.This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language.The initial setup of this solution is very straightforward.The setup is straightforward. It's very easy to install.With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server.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.

More SSIS Pros »

Cons
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.The interface is not quite user-friendly and is in need of improvement.The solution should offer more machine learning and automation.The pricing of the solution should be improved.Integration with other products could be improved.Newer feature integration is lagging behind the company acquisitions and the product could do more to service a broader range of devices.The initial setup is complex.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.

More SAP Data Services Cons »

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.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.Generic processes should be used instead of custom code for each table.Tuning using this solution requires extensive expertise to improve performance.The performance of this solution is not as good as other tools in the market.Video training would be a helpful addition.The solution should work on the GPU, graphical processing unit. There should also be piping integration available.It needs more integration tools, so you can connect to different sources.

More SSIS Cons »

Pricing and Cost Advice
The pricing is a little high to make the product more competetive in the marketplace.Pricing is good, there is no problem.

More SAP Data Services Pricing and Cost Advice »

t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base.This solution is included with the MSSQL server package.My advice is to look at what your configuration will be because most companies have their own deals with Microsoft.This solution has provided an inexpensive tool, and it is easy to find experienced developers.

More SSIS Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
437,064 professionals have used our research since 2012.
Questions from the Community
Top Answer: The most valuable feature is the logging capability.
Top Answer: The interface is not quite user-friendly and is in need of improvement. In the next release of this solution, I would like to have a planning tool.
Top Answer: Our primary use is for storing incidents and all of the financial information that accompany them.
Top Answer: Product recommendation depends on the business requirement and use case. Both are good products and well established in the market. Parameters to look for at the time of product selection : 1)… more »
Top Answer: There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for… more »
Top Answer: Check out my review where I lay out the pros and cons. https://www.itcentralstation.com/product_reviews/ssis-review-30205-by-garym
Ranking
8th
Views
9,168
Comparisons
7,099
Reviews
10
Average Words per Review
506
Avg. Rating
7.6
1st
Views
34,023
Comparisons
26,854
Reviews
19
Average Words per Review
502
Avg. Rating
7.7
Popular Comparisons
Compared 12% of the time.
Compared 21% of the time.
Compared 9% of the time.
Compared 8% of the time.
Compared 3% of the time.
Also Known As
SAP BusinessObjects Data Services, SAP BusinessObjects Data Integrator, BusinessObjects Data IntegratorSQL Server Integration Services
Learn
SAP
Microsoft
Overview

You cannot afford to run your business on questionable data. With SAP® Data Services software, you can access, transform, and connect data to fuel your critical business processes. Together, these enterprise-class solutions enable data integration and data quality, providing the right level of insight across your business so you can make better decisions and operate more effectively.

SSIS is a package is an organized collection of connections, control flow elements, data flow elements, event handlers, variables, parameters, and configurations, that you assemble using either the graphical design tools that SQL Server Integration Services provides, or build programmatically. You then save the completed package to SQL Server, the SSIS Package Store, or the file system, or you can deploy the ssISnoversion project to the SSIS server. The package is the unit of work that is retrieved, executed, and saved.
Offer
Learn more about SAP Data Services
Learn more about SSIS
Sample Customers
EMC Corporation, LivePerson, Eldorado, Mozzart, The VELUX Group, AOK Bundesverband, Hilti Group, Nissha Printing Company Ltd., Asian Paints, Aareal Bank Group, Migros GroupPKP Energetyka, UniCredit Bank, Mostar, waldwasser, Ashok leyland, Florida Atlantic University, Stadt Frankfurt am Main
Top Industries
REVIEWERS
Manufacturing Company33%
Comms Service Provider11%
Construction Company11%
Pharma/Biotech Company11%
VISITORS READING REVIEWS
Computer Software Company49%
Comms Service Provider10%
Media Company6%
Government5%
REVIEWERS
Financial Services Firm26%
Healthcare Company9%
Manufacturing Company9%
Retailer9%
VISITORS READING REVIEWS
Computer Software Company33%
Comms Service Provider11%
Insurance Company8%
Government7%
Company Size
REVIEWERS
Small Business12%
Midsize Enterprise8%
Large Enterprise80%
REVIEWERS
Small Business24%
Midsize Enterprise24%
Large Enterprise51%
VISITORS READING REVIEWS
Small Business4%
Midsize Enterprise9%
Large Enterprise88%
Find out what your peers are saying about SAP Data Services vs. SSIS and other solutions. Updated: September 2020.
437,064 professionals have used our research since 2012.
SAP Data Services is ranked 8th in Data Integration Tools with 11 reviews while SSIS is ranked 1st in Data Integration Tools with 20 reviews. SAP Data Services is rated 7.6, while SSIS is rated 7.6. The top reviewer of SAP Data Services writes "Helps us to collect and analyze data and has enabled us to increase our product line ". On the other hand, the top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". SAP Data Services is most compared with Azure Data Factory, SAP Data Hub, Informatica PowerCenter, IBM InfoSphere DataStage and Oracle Data Integrator (ODI), whereas SSIS is most compared with Informatica PowerCenter, Oracle Data Integrator (ODI), Talend Open Studio, IBM InfoSphere DataStage and Mule Anypoint Platform. See our SAP Data Services vs. SSIS report.

See our list of best Data Integration Tools vendors and best Cloud Data Integration vendors.

We monitor all Data Integration Tools 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.