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 HANA database, which is very fast, is a valuable feature."
"The maintenance of data services is the solution's most valuable feature."
"The feature of SAP Data Services has enhanced our company's business processes because we are able to run around 800 jobs in areas like data extraction and transaction objects."
"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."
"The fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth."
"You can always manipulate a lot of things as long as you have the skill level."
"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."
"The solution is easy to use since it's a graphical tool. It also requires only low-level coding."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The UI is very user-friendly."
"It has good data integration and good processes."
"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 main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"SSIS is easy to use."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The setup is straightforward. It's very easy to install."
"Newer feature integration is lagging behind the company acquisitions and the product could do more to service a broader range of devices."
"They could make it easier to work with web 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."
"In the future, Data Services should offer a cloud version."
"At the integration level, there could be certain set of improvement to connect to various other systems."
"The solution should offer more machine learning and automation."
"It will work fine only in an SAP environment. It could be said that the integration with other vendors could be better."
"The skillset of data engineers matters a bit to use all the functionality of this solution. Otherwise, the delivery speed won't be faster."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"It hangs a lot of the time."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"We have issues with SSIS connectors while extracting data from Excel sources."
"I would like to see more features in terms of the integration with Azure Data Factory."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
SAP Data Services is ranked 10th in Data Integration with 15 reviews while SSIS is ranked 2nd in Data Integration with 33 reviews. SAP Data Services is rated 8.0, while SSIS is rated 7.6. The top reviewer of SAP Data Services writes "Easy to use, simple to implement, and offers very good mapping capabilities". 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, Syniti Data Quality, Informatica PowerCenter, Palantir Foundry and SAP Process Orchestration, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and Matillion ETL. 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.