About former_member187605

former_member187605 · 02-18-2019

In section 34 Changed Data Capture of the SAP Data Services Designer Guide you can find a very good description of the various delta load capabilities in SAP Data Services. Isn’t that worth an attentive read? Delta loads are commonly used to reduce ...

former_member187605 · 03-19-2018

When it comes to DS performance, many factors can be important. The one with most impact often is the design of your jobs. This does not only apply to data flow design (see my blogs on SQL pushdown and ECC data extraction for some interesting example...

former_member187605 · 10-26-2017

SAP Data Quality Management, microservices for location data (DQMms) offers cloud-based microservices for address cleansing, geocoding, and reverse geocoding on the SAP Cloud Platform (SCP). It enables embedding address cleansing and enrichment servi...

former_member187605 · 03-13-2017

Many SAP Data Services (DS) applications use SAP ECC data as a source. It now happens that DS supports multiple mechanisms to extract data from SAP ECC. Which one to choose? There often is a preferred method, depending on the functionality required a...

former_member187605 · 01-05-2017

I can connect from a Linux Suse ODBC client with the SYSTEM user to my HANA db. No issues. But when I try with another user, I get an "[SAP AG][LIBODBCHDB SO][HDBODBC] General error;10 authentication failed" error message:The SAP_CMS user is not a re...

former_member187605 · 12-13-2020

Check out the word_ext built-in function.

former_member187605 · 03-18-2020

That's default behaviour indeed. Why would you want to avoid generation of optimal code?

former_member187605 · 03-12-2020

i always prefer to have all data in a single database. In HANA, Oracle, DB2, Teradata...you can separate from target data at schema level. In a less powerful dbms, lke MS SQL Server, SQL Anywhere... create separate staging and target databases.

former_member187605 · 02-29-2020

If you know the maximum number of rows in advance, use a Reverse_Pivot transform. Then concatenate all pivot columns into 1.If you don't, use a SQL transform.

former_member187605 · 02-28-2020

The name change from SAP BusinessObjects Data Services (BODS) to SAP data Services (DS) dates from 2012 !!!

User Statistics

User Activity

SAP Data Services - Defining delta using hash functions

SAP Data Services: the ultimate hexadecimal to decimal conversion function

Integration of SAP Data Quality Management microservices for location data into an SAP Data Services job

Extracting data from SAP ECC

Only SYSTEM user can connect to HANA with ODBC, others cannot

Re: How to read number of rows into variable in BODS Script with exec?

Re: Let the database do the hard work! Better performance in SAP Data Services thanks to full SQL-Pushdown

Re: Staging area design for SAP Data services

Re: How to implement wm_concat logic in BODS

Re: Datastore creation error for SOAP webservice as a source in SAP BODS with https url