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
0
votes
1 answer

SAP DS: Read input xml file result in an error

I am using SAP Data Services v. 4.2. I am trying to acquire an XML file in input. I created a new XML Schema starting from a .xsd file. When I launch the job I have this error: 2076818752FIL-0522267/25/2017 2:56:35 PM|Data flow…
Centro Ricerca Napoli
  • 9
  • 1
  • 6
0
votes
1 answer

SAP BODS error Correlation name '' not found

I am working with SAP Data Services at the moment. I need to load a load procedure from the SQL file. And I'm getting this error: SQL submitted to ODBC data source resulted in error <[Sybase][ODBC Driver][Sybase IQ]Correlation name 't_table'…
Edvards Veļa
  • 41
  • 3
0
votes
1 answer

How to skip xml attribute or element when generating xml in SAP BODS?

I am trying to figure out how I can skip an attribute or element writing on to XML. For ex: ... ... .. is enumerated and can only accept 'Y' and this needs…
SKB
  • 11
  • 3
0
votes
1 answer

SAP BODS : XML export and alias names

I exported my BODS job into XML format. I wanted to check the error tables in the bulk loading properties, I found the teradata_errortable1 and teradata_errortable2 tags for that. My issue is that even though I mentioned the ALIAS names in the Bulk…
user3055262
  • 405
  • 3
  • 9
  • 20
0
votes
0 answers

Find Bulk Loader jobs in SAP BODS

Is there a straight forward way to find out through the metadata whether any BODS job is using the 'Bulk Loader Option' in its target table objects. I wanted to find all the jobs in my repository which use the Teradata Multiload option as a Bulk…
user3055262
  • 405
  • 3
  • 9
  • 20
0
votes
3 answers

Syntax for insert data into table in SAP BODS

I tried this to insert data into table in SAP BODS, but it seems like it won't work : BEGIN sql('TEST_DB', 'INSERT INTO TEST_CODE VALUES ({$ID_NUMBER}, {$DATE}, {$NAME})) END Is there any missing syntax? I already search for the SQL…
octoberafternoon
  • 37
  • 1
  • 8
0
votes
1 answer

Push log file into SAP BODS with VBScript

I need to look for a string of text in a log file. When that string of text is found, I want to get the next 4 lines of text immediately after, see my example below: Example found text string first line after found string second line after found…
Chirag
  • 1
0
votes
1 answer

Avoiding multiple look ups and improving the performance

I have a case, where I need to do multiple joins(lookups) like below query. Sample scenario was given. I have around 200 CAT_CODE. I thought few solutions and I listed it down as cases. Is there is any different way to write a SQL query to have…
Raja
  • 507
  • 1
  • 6
  • 24
0
votes
0 answers

XML Parsing Error - Extra content at end of document

I have been trying to parse this xml response from a service and I keep getting a parsing error. I am working with BODS and its very sensitive to xml structure. XML response as follows: …
user5849246
  • 1
  • 1
0
votes
2 answers

What index function does in SAP Data Services?

I am looking at a data flow in SAP Data Services (BODS). One of the column 'Reg' in a table (WORKCODE) has double values (for e.g. 8.33E-02). Can anyone please explain the below expression and what is the function of 'index' in the below…
Kuldip.Das
  • 191
  • 1
  • 3
  • 13
0
votes
2 answers

Year 2014 getting converted to 1914 in BODS job

The current arrangement is: SAP DSO: contains the data columns in the form of dd-mm-yyyy. The BODS job fetches the data from the DSO and loads to the landing table. The corresponding date column in Teradata is dd-mm-yy. When the dates are loaded…
user3055262
  • 405
  • 3
  • 9
  • 20
0
votes
0 answers

How do I extract a timestamp column in a SQL transform using Data Services Designer?

I'm a Business Intelligence intern and am trying to write a simple ETL batch job to bring one table into our warehouse using SAP Data Services Designer. The source table has a timestamp column, which halts the job's execution, saying: You cannot…
Canucklesandwich
  • 693
  • 6
  • 15
0
votes
0 answers

How to get 0001 instead of 2001 using YYYY

I have a column with different timestamps, like: 5771.10.04 16:07:23.800913000 0967.06.17 06:20:28.800906000 3857.06.18 03:49:03.800906000 01.04.29 16:45:04.400909000 I need to convert these into decimals (which I use for a join of some million…
Cos
  • 1,649
  • 1
  • 27
  • 50
0
votes
1 answer

Slow SAP Data Services export to MySQL

We've a MySQL 5.1 server and we are trying to import data from SAP Data Services from another server. It works but it takes 3h! We tried to setup an Oracle XE server to test the same operation and it takes only 10 minutes. I think the problem is…
Dimas
  • 331
  • 1
  • 5
  • 15
0
votes
3 answers

SQL Query that filters OUT the first and last row

I'm working with SAP Data Services, and have a table that I'm trying to filter. Nothing I can think of in SAP would work, however if I use a SQL query that might. My questions is: How do I make a query that will filter out the first and last row in…
Ali Kazmi
  • 11
  • 5
1 2 3
4
5