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
0 answers

Reading CSV file in SAP Data Services using double quotes as text delimiter - but only single double quotes in column value

I am reading a CSV file in SAP Data Services Designer and using " as text delimiter. The client sometimes sends data that only has one double quote in a column, without a closing " which would mark the end of string. Because of this, it ends up…
Anuj
  • 1
  • 1
0
votes
0 answers

Unable to generate correct namespace in generated XML

I am getting some extra lines in the namespace for the xml file generated by SAP BODS using the XSD file. The below is my main XSD:
Paras Singh
  • 383
  • 1
  • 3
  • 11
0
votes
0 answers

Reading csv file with double quote delimiter in SAP BODS

I am trying to read a csv file in SAP BODS the file delimiter is ,(comma) and text delimiter is "(double quotes) the text withing the "" AND COMMAS also have double quotes in them due to which the column is being split into new column Is there…
preetesh patel
  • 1
  • 1
0
votes
0 answers

Invoke SAP Data Services Web Service using VBA script

I'm trying to execute an SAP Data Services job which was published as a Web Service with the session security turned off. I followed one of the blogs and wrote the below VBA script. However, this does not execute the job. Dim sMsg As String …
Bharath Kumar
  • 13
  • 2
0
votes
1 answer

Slowly changing dimensions in HANA Views?

I am a newbie to HANA.Our org is planning to build a native datawarehouse on top of SAP HANA. Till date we have implemented SCD types using the ETL approach in SAP BODS. Wondering if some types of SCD's could be offloaded onto the HANA Studio by…
Sai Teja
  • 1
0
votes
1 answer

How to call materialized views using informatica power center?

I have script component to refresh 10 materialized views in data services job (BODS) and views created in Oracle but I have to migrate to Informatica job. How can I create from Informatica Power Center designer? Please specify the steps as I am new…
Pirinthan
  • 494
  • 2
  • 8
  • 28
0
votes
1 answer

How to load array data type from parquet file stored in Amazon S3 to Azure Data Warehouse?

I am working with parquet files stored on Amazon S3. These files need to be extracted and the data from it needs to be loaded into Azure Data Warehouse. My plan is: Amazon S3 -> Use SAP BODS to move parquet files to Azure Blob -> Create External…
skadam85
  • 483
  • 7
  • 19
0
votes
1 answer

How to get the data that is not loaded in the target table?

I am having a small ETL mapping in SAP BODS where the Source table data is loaded into the target table. But there are chances where some rows might be having some errors and may be skipped. I want to store the count of all these rows that are…
pranay tanniru
  • 31
  • 6
0
votes
2 answers

Why complex DB2 "VALUE" Function is used here?

While searching through some older view in our system. I came across some value function use that while I understand what it is doing I cannot for the life of me figure why it would be made unnecessarily complex. This is from a View creation DDL.…
Exnuke1972
  • 5
  • 1
  • 3
0
votes
1 answer

Send file to Azure Storage BLOB from SAP

How is it possible to send a file to Azure Storage BLOB from SAP? Maybe SAP PI can do it? I am standing ground on SAP matters. Any advice here would be appreciated.
Jaish Mathews
  • 766
  • 1
  • 9
  • 25
0
votes
2 answers

Invalid date format in datatype column in BODS job to Oracle

I am using SAP BODS and I am trying to fetch data from an ORACLE server using SQL query transformation. Now The table has a column named latest_changed_date which is a datetime column. I only want yesterday and current day data from that table. Now…
Vandan Bhardwaj
  • 53
  • 3
  • 11
0
votes
1 answer

execute procedure having grant statements from BODS

I have a procedure that runs grant select statements for various tables in different schema . I have used AUTHID CURRENT_USER for this to execute successfully from SQL Developer. But when I try to execute the same procedure from BODS designer, it…
Shrangi Tandon
  • 63
  • 1
  • 2
  • 5
0
votes
1 answer

Creation of products in Hybris commerce using web services in SAP Data Services

I've been trying to use SAP Data Services to integrate products from an existing ECC system into Hybris commerce platform, the data is ready to be pushed to the system but for the life of my I cannot get SAP Data Services to interface with the…
N Wilson
  • 13
  • 4
0
votes
1 answer

SAP DS is not pushing down ifthenelse or decode()

I'm designing a DS JOB targeting a SybaseIQ and realize that IfthenElse Syntax and DI Decode() function are not getting pushed down to the database server. Is there any equivalent DI function that I can use to push the whole operation down to…
EagerToLearn
  • 675
  • 7
  • 24
0
votes
1 answer

How to make ABAP understand "_" as a special character in a global variable value from BODS?

I have one requirement in BODS to execute ABAP dataflows with dynamic global variables. The ABAP code is a custom one with dynamic where clause. I am trying to send the global variable value like Field-name like "%underscroe%". But instead of…
tst2016
  • 67
  • 1
  • 7
1 2
3
4 5