Director at Pixel Studio PTY
Real User
Top 5Leaderboard
An easy to use solution that supports data warehousing
Pros and Cons
  • "The solution is easy to use since it's a graphical tool. It also requires only low-level coding."
  • "The solution shows a lack of cloud support data services."

What is our primary use case?

We use the solution to support data warehousing. 

What is most valuable?

The solution is easy to use since it's a graphical tool. It also requires only low-level coding. 

What needs improvement?

The solution shows a lack of cloud support data services. 

For how long have I used the solution?

I have been using the solution for more than 30 years. 

Buyer's Guide
SAP Data Services
April 2024
Learn what your peers think about SAP Data Services. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,236 professionals have used our research since 2012.

What do I think about the stability of the solution?

The solution is a stable and mature tool. It is standardized in such a way that you don't have issues with upgrading.

What do I think about the scalability of the solution?

I would rate the product's scalability a nine-point five out of ten. The tool is intelligent enough to split the workload. 

How are customer service and support?

The support classifies your incidents as low priority, medium priority, and high priority. Usually, I am classified as a medium priority and get an answer in 24 hours. I get the fix in less than a week. Support has people who are very knowledgeable about the product. 

How would you rate customer service and support?

Positive

How was the initial setup?

The product is simple to setup. If you are setting it up on Windows, then it's a matter of a few clicks. 

What other advice do I have?

I would rate the product an eight out of ten. The solution suits medium to enterprise organizations and would be expensive for small companies. The product is very useful for SAP customers. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Manager at GTX Soft
Real User
Good dashboards and data reporting but needs more cognitive analytics
Pros and Cons
  • "The reporting on the data, even from third-party software, is very good."
  • "The solution should offer more machine learning and automation."

What is most valuable?

The solution has very good dashboards. They have a good refresh rate - after every 300 articles.

The reporting on the data, even from third-party software, is very good.

What needs improvement?

The solution should offer more machine learning and automation.

The solution should add more cognitive analytics, particularly on the RPA. It should allow for data to be picked up in Outlook and processed in SAP, then communicated via any third-party software. This will help with decision making and retrieve the data per the requirements of the user.

The existing ERP doesn't have any capabilities. The features of RPA need to be built into ERP. It's lagging in not just this solution, but almost all software.

For how long have I used the solution?

I primarily use the solution for building data cubes from existing third party software at SAP and consolidating different stages on queries.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

We do plan to increase usage in the future.

How are customer service and technical support?

We interact with technical support regularly and often reach out about two times a week. Their support office is very close to ours in Bangalore. We've been very satisfied with their level of service.

Which solution did I use previously and why did I switch?

We did previously use a different solution. We switched because Data Service has a lot of upcoming technology and there's a good market for their services currently.

How was the initial setup?

The solution is straightforward to set up. A lot of research needs to go into the work, however. A standard deployment takes a few months.

What about the implementation team?

We had our own consultants assist with the implementation. They have a lot of knowledge about SAP and SAP environments for building a gateway.

What other advice do I have?

We use the on-premises deployment model.

SAP Data Services predominantly works for event tracking or training environments. However, if you're talking about social media, where there needs to be a lot of understanding about the data, you could build this solution into that area as well. You will just need a lot of research and development.

I'd rate the solution seven out of ten. If they build in cognitive capabilities and went beyond just reporting on the dashboard, I'd rate it higher.

Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
Buyer's Guide
SAP Data Services
April 2024
Learn what your peers think about SAP Data Services. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,236 professionals have used our research since 2012.
Program Manager at a tech services company with 10,001+ employees
Real User
Has a convenient dashboard and good data integration
Pros and Cons
  • "The HANA database, which is very fast, is a valuable feature."
  • "Integration with other products could be improved."

What is our primary use case?

I’m not an SAP consultant but I have quite a long experience with SAP projects. I've been working in IT for 20 years (HP Services / DXC) and I have a lot of contacts with SAP customers so my opinion is based rather on my experience of real SAP implementations not based on a deep knowledge of SAP technology abilities. I’m a business consultant technology agnostic and very often my customers asking me for advice in the scope of a transformation of their IT environment.

Most of our customers are dealing with a huge amount of data so we usually apply the solution to enterprise companies that have SAP technology and they are usually SAP customers. It's not separate analytics that can be applied to another ERP system. 

Usually, between five and 10% of employees in a particular company will be using the solution, it will be slightly higher when the solution is applied in the retail sector. It really depends on the company. Some are based on IT technology and others provide a more operational or production base. In these companies, there is a utilization of analytics. It strongly depends on the company's activities. 

What is most valuable?

The HANA database, which is very fast, is a valuable feature. I think it's very useful and gives the customer a lot of options. I like the dashboard, it's very convenient. 

What needs improvement?

Integration with other products could be improved. Often we need to apply analytics for the data coming directly from production. The product could be improved by providing employees with a more simplified ability to build reports.

SAP is a very powerful system and definitely first class for big companies. Its wide scope of functionality and models adjusted to different business activities give SAP a leading position within extended ERP systems. From the other side, such a wide range of modules and functionality generates difficulties in implementation and real full utilization of all system possibilities. An example of this is with my last customer that I discussed with two weeks ago – one of the biggest logistics and retail companies in Poland. They implemented SAP seven years ago. They bought a wide scope of modules with some logistic extensions and up to now, they pay very expensive maintenance for licenses. In reality, they didn’t implement SAP in the scope of owned licenses because they finally find the system too inflexible to adopt applications to their business processes. As a result, they utilize core ERP, HR, BW and a small portion of APO while the rest of the modules that are not implemented are exchanged with Z programs. A very strong point is BW but for quick reporting and report personalization (BI) they bought other technology due to more flexible and chipper reporting. They integrated SAP with TMS, WMS, and core operating systems for their special business and have a big problem with maintaining a lot of interfaces (they didn’t implement SAP PI).

Now the customer is thinking about migration to Dynamics and evaluating this scenario in different aspects. An upgrade of the old SAP version means total reimplementation of the SAP to S4. Now SAP offers a very wide range of retail and logistic functionality especially in S4 but to buy all retail and logistic modules, customers evaluate as very expensive and are afraid about the ability to implement.

This is not the only example. A very similar situation was with another customer with an older SAP version. Especially for production companies, SAP is evaluated as a system that is very difficult to implement within the production environment. Implementation with MES generates lot of analytical effort (technical part is not a problem but way of data enquiry by SAP).

From my experience in SAP implementation, I am often irritated by very selective knowledge of SAP implementation consultants and it’s not only from my company but generally taking into consideration SAP services market. Usually, a consultant knows one module, sometimes 2 or 3 but to cover business area eg. retail and logistic you need a few of them and this is the reason that very often customers implement system functions (within every module) not implement process flow (cross modules view).

In the case of analytics, SAP offers great tools (especially HANA gives very powerful tools) but many customers decide to use SAP BW but chose BI from other technologies taking into consideration ratio functionality, flexibility, and price.

This is my personal opinion, mainly based on my experience with SAP customers and real SAP implementation. SAP is a best in class system but requires a very good implementation team (which is expensive) and a reasonable time frame (time is expensive too), to maximize its potential but in other cases, implementation can be unsuccessful regardless of technological system abilities.

How are customer service and technical support?

I think the technical support is good enough. 

How was the initial setup?

Initial setup is rather complex. SAP Analytics requires integration with the rest of SAP models. We are the final link in the chain of implementation of SAP technology so some customers could do with external assistance. It really depends on the client's internal culture and skills. It helps to have a consultant and in some cases it's crucial. 

What other advice do I have?

Many customers want to apply additional tools that are connected and integrated with SAP Analytics. It gives them more flexibility in building some reports. In some cases, we would still require an additional appliance, some additional tools to fulfill the needs of our customers.

I would rate this solution an eight out of 10. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user163365 - PeerSpot reviewer
Sr Solution Architect, Data at a manufacturing company with 1,001-5,000 employees
Vendor
Matching Transforms are quite complex but Connectivity with SAP is a valuable feature.

What is most valuable?

Connectivity with SAP and low impact on SAP environments. Also overall stability of the product.

How has it helped my organization?

Kellogg (the company I work for) used this product for data migration into the new SAP environment that we have established for North America. We also used the tool during the Pringles acquisition.

What needs improvement?

Matching Transforms are quite complex.

For how long have I used the solution?

5 years.

What was my experience with deployment of the solution?

No issues that would impact our timelines.

What do I think about the stability of the solution?

Data Services is extremely stable and stability information steward is considerably higher in version 4.2 than it was at the initial version 4.0.

What do I think about the scalability of the solution?

Easy to scale horizontally or vertically.

How are customer service and technical support?

Customer Service:

Satisfied.

Technical Support:

Needs improvement as far as responsiveness.

Which solution did I use previously and why did I switch?

No.

How was the initial setup?

I was not directly involved at the initial setup.

What about the implementation team?

I heard Kellogg used a combination of SAP and Accenture for the initial setup.

What was our ROI?

Data Quality has an indirect ROI and we have not derived a fixed number.

What's my experience with pricing, setup cost, and licensing?

Since I was not involved with the initial setup I am not able to answer a question about the start-up cost. As far as day-to-day cost, it is minimal (1/4 FTE) due to its stability.

What other advice do I have?

Depends on the environment. If you are connecting to SAP environment I would recommend involvement of a 3rd party vendor with experience.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Public Affairs Manager at a pharma/biotech company with 10,001+ employees
Real User
Handles financial reporting but needs voice recognition
Pros and Cons
  • "The user interface is ok."
  • "The initial setup is complex."

What is our primary use case?

We use this solution for financial reporting.

What is most valuable?

The most valuable feature is the user interface.

What needs improvement?

This product could improve the uploading of documents and the amount of time it takes to upload.

The required typing could be minimized by adding Voice recognition.

For how long have I used the solution?

I have been using SAP Data Services for eight years.

What do I think about the stability of the solution?

It takes some time to get familiar with this solution.

What do I think about the scalability of the solution?

Our company has one hundred and twenty thousand people around the world that use many SAP solutions.

How are customer service and technical support?

We are happy with technical support and we have had no problems with it.

How was the initial setup?

The initial setup is complex. It takes time to get used to.

What's my experience with pricing, setup cost, and licensing?

Pricing is good. We don't have any problems with it. 

What other advice do I have?

I would recommend this product, but nothing is perfect, there is always room for improvement.

I would rate this solution a seven out of ten. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
PeerSpot user
President at i-DValue
Consultant
Enables ability to change the source and target from Oracle to SQL without changing your code

What is our primary use case?

  • Data warehousing project (with CDC or comparison table to update our histories).
  • Four sources: SQL Server, Oracle, SAP ECC, Excel file.
  • One target: Azure SQL Data Warehouse.
  • Complex transformation to load the Data Warehouse (good and simple optimization).

How has it helped my organization?

  • It's very simple to build a data flow.
  • The development is faster than SSIS or Talend.
  • Impact analysis is very useful to know who used this KPI (the report on the user that had access to this report).
  • Profiling data is very useful to know the interesting fields.

What is most valuable?

  • Portability of development (you can change your source/target from Oracle to SQL without changing your code).
  • Web console monitoring.
  • Auto-documentation.
  • Simple toolbox with all you need.

What needs improvement?

  • Development with web tool (today is with client tool).
  • Connection to Active Directory to extract user and group.
  • A PaaS cloud service (today is on-premise).
  • Better connection to SAP BW.

For how long have I used the solution?

More than five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Senior Technical Consultant at a tech services company with 501-1,000 employees
Consultant
A little trouble handling parallel batch jobs in one job, but helps align your information with the business process.

What is most valuable?

- Its single infrastructure for Data Migration and Data Integration.

- Heterogeneous processing with broad database support.

- Parsing, Standardization and Cleansing the Data.

- Matching and consolidation of records.

- Multi-user support and security with central repository.

- Instant trace-ability with impact analysis and data lineage functionality.

How has it helped my organization?

It helps our organization and our clients achieve its goals and objectives by having the right information at the right time and at the right people.

We can standardize business information though data is disparate or came from many sources like flat files (CSVs, Textfiles, Excel files), RDBMS, Application Systems and etc.

With this product you can align your information with the business process and can provide Enterprise Data Warehouse that will suit to your reporting needs.

What needs improvement?

I think it has a little trouble handling more users running parallel batch jobs in one job server but minimal.

For how long have I used the solution?

SAP BusinessObjects Data Services 3.1,3.2, 4.0 and 4.1 (SAP) for 5.3 years

What was my experience with deployment of the solution?

Yes but minimal and can be resolve quickly.

What do I think about the stability of the solution?

None.

What do I think about the scalability of the solution?

None.

How are customer service and technical support?

Customer Service:

4.5 out of 5.

Technical Support:

4.5 out of 5.

Which solution did I use previously and why did I switch?

Yes, because its more dynamic and has so many features.

How was the initial setup?

Straightforward. You just have to follow the guides, check Product Availability Matrix (PAM) and if issues related to sources and targets arise do some research.

What about the implementation team?

Both. 4.7 out of 5.

What was our ROI?

300%.

What other advice do I have?

You can leverage this product in all your business needs regarding data or information or any business requirements in the systems but first you must find a dedicated consultant or developer for this product and they should also train the people from your organization.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Technical Project Manager Big Data and BI - Banking at a tech services company with 5,001-10,000 employees
Real User
Easy code writing and good stability but needs integration with big data solutions
Pros and Cons
  • "The fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth."
  • "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."

What is most valuable?

The fact that it's built on SQL, makes it easy to write code. Also, the database and the connection are quite smooth. 

What needs improvement?

The solution lacks user-friendly features. Compared to other integration tools I've used before, it's less user-friendly and the built-in features just aren't sufficient. 

The description of error messages isn't extensive, although they do point out the problems. 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.

The query feature does not allow a lot of flexibility in building the code. They need to make progress with this feature as well.

In future releases, I'd like to see the integration of a big data solution within SAP Data Services. I don't know if they offer that right now. The version I have is quite basic. If I was able to use more data sources with other software, and have the solution be more compliant with more data source types and big data sources, that would be helpful.

For how long have I used the solution?

I've been using the solution for 1.5 years.

What do I think about the stability of the solution?

I would rate the stability seven out of ten. It's good, but it's not the best.

How was the initial setup?

I wasn't part of the initial setup, so I can't speak directly to the implementation of the solution.

What other advice do I have?

We are using the on-premises version of the solution. We work on the enterprise version and have a few hundred users.

I like the platform. It's quite robust. It's just there are little improvements that could make the solution better, but it's quite a good tool.

I would rate the solution seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free SAP Data Services Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Data Integration Data Quality
Buyer's Guide
Download our free SAP Data Services Report and get advice and tips from experienced pros sharing their opinions.