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
1
vote
1 answer

Unable to execute python command in SAP BODS

I tried executing a python command using ksh in SAP BODS script to run a program called "zzz.py" in the BODS server: print(exec('ksh', '-c "python --version"', 8)); print(exec('ksh', '-c "python zzz.py"', 8)); However, upon executing the script, I…
chaooder
  • 1,358
  • 1
  • 17
  • 37
1
vote
1 answer

Declare variable in template table

I am writing an ETL to extract data from HANA table and load into SQL Server in BODS. My job is to create a new table on SQL Server every time I run my job with name as date of that day. I know we can do that for flat files by using global variable…
user5342687
  • 55
  • 1
  • 1
  • 5
1
vote
1 answer

Make MERGE statement in BODS

I have SAP BODS as ETL tool running towards Oracle Exadata. I would like to produce a merge into statement from BODS that include a where clause, limiting the columns that will be updated when found a match. The merge statement I have today looks…
Øyvind Botn
  • 31
  • 2
1
vote
1 answer

ORA-12899 - value too large for column when upgrading to Oracle 12C

My project is going through a tech upgrade so we are upgrading Oracle DB from 11g to 12c. SAP Data Services is upgraded to version 14.2.7.1156. The tables in Oracle 12C is defaulted to varchar (byte) when it should be varchar (char). I understand…
Shanaaz
  • 11
  • 2
1
vote
1 answer

Milliseconds are lost in Table_Comparison/Map_Operation in timestamps columns

I have a data flow in BODS (SAP Data Services) where the milliseconds on a SQL Server column defined as datetime2 are dropped when I am using the Table_Comparison/Map_Operation combination. When the target table is updated by the Map_Operation,…
Davidson
  • 1,064
  • 3
  • 20
  • 35
1
vote
2 answers

Dynamically add columns and adapt schema to it

If my source table keeps getting one column added to it at a time, how do I map the new column to my query/source? It is different from slowly changing dimension, as it is not records that are changing, but the number of columns itself, i.e. the…
Ankush Venkatesh
  • 11
  • 4
1
vote
1 answer

Check scheduled job status in SAP BODS

I am new to BODS, At present I have configured a job to execute every 2 minutes to perform transaction from MySQL server and load into HANA tables. But sometimes when the data volume in MySQL is too large to transform and load into HANA within 2…
kishorre
  • 57
  • 1
  • 9
1
vote
1 answer

Import flat file containing commas/quotes into SAP BODS

Hi I have a row like following in .csv file 12346,abcded,ssadsadc,2013.04.04 08.42.31,8,"I would like to use an existing project as a template for a new project for another Report Suite but it just overwrites the existing project rather than…
Mad
  • 11
  • 1
  • 3
0
votes
0 answers

SAP dataservices designer shows error about an

I am trying to create a file location in SAP Data Services designer using SFTP protocol, but it shows an error: The field cannot be empty. Please enter a value. (BODI-1220393) I searched the internet, and found that it has…
Ahmed
  • 1
  • 1
0
votes
0 answers

Validate a file name in an S3 bucket through SAP Data Intelligence 3.1

I need to validate the file name format of a .csv file that is available in an S3 bucket through SAP DI. What is the operator used in SAP DI to perform this task? Can I use 'Monitor Files' component to achieve this?
Garushi
  • 1
0
votes
0 answers

Extra "" after field transformation?

Cant figure out why there is an extra "" in the query transform as below in the KEY: The other fields are without "" and coming fine. Example as below: I am stuck, please help.
user18670180
  • 1
  • 1
0
votes
1 answer

Problem loading Snowflake tables from SAP Data Services using S3 bucket

I'm trying to load tables from Data services to Snowflake using a s3 bucket (it's required to bulkload the info). I can't format output files to s3 bucket. I have problems with break lines (doesn't break the lines) and dates (extra precision) , and…
Lorenzo Lomos
  • 1
  • 1
0
votes
0 answers

Passing Multiple Values in a Global Variable and print it during Runtime of BODS job

I am new to BODS and currently in my project I have a requirement where after the BODS job gets completed I have to send a mail alert to the user along with total how many IDOCs have been posted and their IDOC numbers. So for IDOC number I have…
sayan nandi
  • 83
  • 1
  • 6
0
votes
0 answers

returning sys_refcursor from oracle in SAP BODS

I want to write a sript in BODS which will call an Oracle SP, which upon passing 2 parameters will return a sys_refcursor containing 3-4 columns. How to write such a script so that that returned value can be stored in a variable and displayed.
TBose
  • 115
  • 2
  • 10
0
votes
1 answer

Creation of Index during data load

In BODS, can we create index on a table while data is being read from it? Actually I am using an ETL tool to load data to target. The performance is very slow and I do not want the data load to stop. Will the performance improve if I create the…
Ashutosh Rai
  • 123
  • 9
1
2
3 4 5