IT Central Station is now PeerSpot: Here's why

SAP Data Services Room for Improvement

Michael Lutz - PeerSpot reviewer
Sr. Data Warehouse Developer at Fox Chase Cancer Center

Data Services' UI can be annoying. Searching through long lists of things takes time because of some limitations. Source code control is another headache. When your source code base gets too large, managing the source code becomes cumbersome. Also, it's not possible to generate the code. You have to code everything manually. There's no way they're going to fix this. It would be nice to generate code from another program, but you can't do that. 

For some tasks you need to do as an ETL developer, it doesn't make sense to code them all one at a time. You want to be able to read the metadata from something and generate the code. But the architecture of the tool doesn't play nicely with that. The ability to generate code would be one feature that would be nice to have. 

I'd also like to see a smoother code promotion check-in and check-out process for large codebases and fixes to the comparison mechanism. The tool allows you to compare your code against the essential repositories, but the comparison mechanism is buggy. It sometimes reports false positives for what has changed. SAP could maybe improve the performance diagnostics for the production environment. Data Services has some rudimentary performance analysis tools, but they're pretty basic. There's not a dashboard to view where you're doing things well and not well performance-wise. A comprehensive performance dashboard would be nice.

View full review »
US
Associate Consultant at a consultancy with 10,001+ employees

There is always room for improvement when it comes to the sources being dynamic, however, it is not something that can be done easily. These changes, take years to come into the picture, and it's usually the patch upgrade that comes in. Those are very less at the functional level. 

At the integration level, there could be a certain set of improvements to connect to various other systems.

There are still a lot of glitches with SAP Data Services as of now. 

I'd like for them to make scheduling much more dynamic when we create jobs. 

The dependencies to other systems, when we are running a job, we have certain problems, some optimization schemes, if it can be implemented for the data flows when we run it. If we had multiple data loaders and if we could use that at the same time while ensuring the backend data system doesn't get affected, it would be ideal. 

View full review »
Nhlanhla Mgoza - PeerSpot reviewer
Data Services Consultant at Inch solution

They could make it easier to work with web services. They need to make things like connecting to Google Databases, and so on, easier. They also have a data connection layer. If you could connect to those web-based data mixes with other vendors, web vendors, that should help.

View full review »
Buyer's Guide
SAP Data Services
June 2022
Learn what your peers think about SAP Data Services. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
609,272 professionals have used our research since 2012.
RambabuMandala - PeerSpot reviewer
Software Development Senior Advisor at Dell EMC

Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity.

View full review »
RK
BI and Visualization Platform Lead at a agriculture with 10,001+ employees

The skillset of data engineers matters a bit to use all the functionality of this solution. Otherwise, the delivery speed won't be faster. 

View full review »
VM
Senior Data Engineer at a tech services company with 10,001+ employees

I have several issues with this solution. The first is that the deployment process, the migration of the solution between different environments, is quite complex. Data services doesn't have much in terms of data transformation components so if you want to do something special, it requires custom coding. The embedded features that SAP Data Services offers are not enough for me to implement everything that I want.

I've also found that the internet resources SAP provides are really poor despite the good documentation on their site. If I want to have a conversation with other developers or get an opinion from them, there's not much available. I would prefer to use other tools, but because of our current client's requirements, we are using Data Services. 

View full review »
Anzize BADAROU - PeerSpot reviewer
BI MANAGER at Abtech

I want some more business intelligence applications. People need to know more and more about data, including the transformation rules, etc. Informatica is a better product for data cataloging. SAP should update the data catalog. 

View full review »
Christophe BERNARD - PeerSpot reviewer
Business Intelligence Manager at ALPTIS ASSURANCES

Dealing with the REST API is not easy with Data Services.

It is mandatory to have a WADL file and it is difficult to find this file and set it up.

I would like to see a better connection with the API and the use of XML files.

It's an ETL that is very good with relational databases but not as good with files and semi-structured files. 

Also, the support could be better.

View full review »
JC
Gerente General at a tech services company with 11-50 employees

It would be nice if this solution was a bit easier to move from development to production.

View full review »
Buyer's Guide
SAP Data Services
June 2022
Learn what your peers think about SAP Data Services. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
609,272 professionals have used our research since 2012.