Stack Overflow
Stack Overflow

Questions tagged [sap-data-services]

The tag is intended about the question related to new SAP ETL and CDC product called SAP Data Services, also known as SAP BODS. It is not intended for questions about other SAP integration products like: SAP PO/PI, SAP Data Hub and others.

SAP Data Services is a ETL and CDC (changed-data-capture) tool that allows connecting data sources between each other and data governance in a wide variety of tasks:

  • connection of heterogeneous data stores and data lakes
  • schedule batch jobs for data synchronization
  • aggregation, transformation, lookups between data stores and more
  • changed-data-capture, i.e. deliver only updated data to decrease redundancy

etc.

67 questions
2
votes
0 answers

Wrapped lines in source splits lines in destination

I have a SAP BODS Pipeline setup to extract a table from Source to destination. Source Data: Destination File: Invoice Address field is being truncated and starting as new line in destination which is creating problems. How can I handle…
Krishnamohan
  • 21
  • 4
2
votes
1 answer

How to capture rejected records in SAP BODS?

I am doing a lookup operation in BODS. The records that match need to be sent to a table and the ones that don't match need to be captured in a file. Can you please help me out on how to capture the records that failed the lookup? It was easy in IBM…
Ashwath Raj
  • 47
  • 5
1
vote
1 answer

How to repeat a delta using SAP_CDC connector from Azure Data Factory

We've just started with ADF and are using the SAP_CDC connector to connect to generic data sources in ODP. This all works but one time the update in Azure failed yet the ODP request was flagged as confirmed. Our only option seemed to be to…
Greg
  • 41
  • 3
1
vote
0 answers

How to upload file from external URL into posts programmatically

I've custom content type, added by BODS, and I've added a file field, that should save a PDF file from external URL. How to save it programmatically? I know how to save the image but it seems that for the PDF files it's a different approach.
Ferland
  • 21
  • 2
1
vote
1 answer

2LIS_17_I3HDR data is not being pushed into ODQDATA

We are extracting SAP PM data to BO Data Services (BODS) using Operational Data Provisioning (ODP), and have successfully done this for notifications. We've gone through all the LBWE config for 2LIS_17_I3HDR & 2LIS_17_I3OPER and it is set as Direct…
Greg
  • 41
  • 3
1
vote
1 answer

Consuming REST Web Service in SAP Data Services

In SAP BODS, I want consuming REST Web Service in SAP Data Services using Web Service REST Datastore. I followed the instructions from this link…
LyLy
  • 41
  • 2
1
vote
0 answers

How to specify JSON parameters in a WADL file?

Dear Stack Overflow Experts, We have a requirement to access an API from SAP BODS. SAP BODS needs a WADL file configured in order to access the API. The API we are trying to call is a rest services API with a POST method and accepts only JSON…
User123
  • 11
  • 1
1
vote
1 answer

Update all changed tables in SAP BODS datastore

In order to transform and load data I am only able to connect to data stores that have already been imported into Data Services from HANA. In my case the tables might change in the forthcoming future so I wanted to script the transform through…
RB17
  • 356
  • 1
  • 8
  • 26
1
vote
1 answer

SAP BODS cannot fetch 255+ columns from Excel

We are facing an issue when uploading long texts (longer than 255 symbols) from Excel file using Data Services in SAP BODS. Data Services ODBC driver truncates all further texts in this column to 255 symbols, even if the field length is defined as…
Sai Charan
  • 11
  • 3
1
vote
1 answer

Create directory using SAP BODS script?

How does one create directories in a given path on Windows using SAP Business Objects Designer 4.2 Script? I got a Script with path that I'd like to create if it does not exist: $My_Path = '\\\\localsrv\\source data\\post\\november' My current…
Kamil Gosciminski
  • 16,547
  • 8
  • 49
  • 72
1
vote
1 answer

SAP Function Module to SQL Server stored procedure

I am trying to convert a SAP ETL process (implemented by BODS) to SQL Server (SSIS). The process is for delta changes (every 15 minutes) and the object is called “0FI_AP_4” in SAP. I want to implement an SSIS package (SQL Server stored procedure)…
user3707761
  • 21
  • 8
1
vote
1 answer

How to use SAP designer combine multiple rows to one cell

How to use SAP designer combine multiple rows into one cell? My source table is like below: | Col_A | Col_B | |---------------------|------------------| | 1 | A | | 1 …
Benny Hsieh
  • 21
  • 1
  • 4
1
vote
1 answer

Need Help at Getting data from SAP to C#

I want to get some data from an SAP Server to my C# program in Visual Studio. The connection between the SAP and the program is already working but I don't really know how to get the data from the Server into the program. namespace ConsoleApp1 { …
brachi
  • 119
  • 1
  • 3
  • 16
1
vote
1 answer

Subtract 14 days from system date

I am using the following code to give me the system date in BODS, to_char(sysdate(),'YYYYMMDDHHMISS'), I have the system date returning correctly, but am unable to subtract days. FAGLFLEXA.TIMESTAMP >= "MISSING CODE HERE" and FAGLFLEXA.TIMESTAMP…
Carl Skonieczny
  • 11
  • 4
1
vote
1 answer

Conditional directory name in SAP BODS

I'm trying to create a function that return path of directory with condition. My function code is like below : $Local_Folder = DECODE(($Global_Class = 'XYZ', '\\\CLASS-DEV\ETL\RESULT1', ($Global_Class = 'JKL', '\\\CLASS-DEV\ETL\RESULT2',…
octoberafternoon
  • 37
  • 1
  • 8
1
2 3 4 5