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."Data Services' table comparison mechanism is very powerful. It's pretty hard to find a similar feature in other solutions."
"You can always manipulate a lot of things as long as you have the skill level."
"The initial setup is not complex."
"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 logic is also simple. It makes it easy to build your extraction."
"It is a powerful product with a broad range of features."
"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."
"The fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The solution is easy to use and developer friendly."
"The performance is good."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"Some of the jobs that are built within Data Services require local files, and during initial deployment, those local files cannot be transported between machines simply because of security issues."
"They could make it easier to work with web services."
"There needs to be multi-language support, however, my understanding is they are working on multi-language now."
"The solution shows a lack of cloud support data services."
"The interface is not quite user-friendly and is in need of improvement."
"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."
"Source code control is another headache. When your source code base gets too large, managing the source code becomes cumbersome."
"The solution should offer more machine learning and automation."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"The solution could improve on integrating with other types of data sources."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"The creation of the measure in the DAC's model could be improved."
"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."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"I would like to see more features in terms of the integration with Azure Data Factory."
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.