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."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 initial setup is not complex."
"The product's most valuable features are data validation and rules."
"You can always manipulate a lot of things as long as you have the skill level."
"The most valuable feature is the ETL functionality."
"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 API tool in this product is very valuable; it is very easy to onboard and use."
"The reporting on the data, even from third-party software, is very good."
"The setup is straightforward. It's very easy to install."
"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."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The solution is stable."
"The technical support is very good."
"The 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."
"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."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity."
"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."
"The pricing of the solution should be improved."
"It's an ETL that is very good with relational databases but not as good with files and semi-structured files."
"It would be nice if this solution was a bit easier to move from development to production."
"The solution could improve the overall features. There is a lot that can be done in the solution, therefor there are areas where it can improve. Additionally, there is a need to make it easier for one to create connections to other non-SAP systems. The flexibility to connect to other non-SAP systems is needed."
"It will work fine only in an SAP environment. It could be said that the integration with other vendors could be better."
"Source code control is another headache. When your source code base gets too large, managing the source code becomes cumbersome."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"It's a legacy tool, that is nearing the end of its useful life."
"Future releases should improve the data lineage, as it currently is not good."
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 Informatica Cloud Data Integration, 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.