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

Converting CSV to Parquet File format using Script in SAP BODS

BODS job is creating CSV Files. IS there a way to convert CSV Files to Parquet and Upload to S3 Bucket in SAP BODS. The Current approach i am using is below for Converting the CSV to Parquet Create a CSV File in the Folder that BODS is…
Madhu Reddy
  • 1
  • 1
-1
votes
1 answer

Is there a way to run a loop through the output of SQL transformation?

I have run the following in SQL transform in Data Services select stag_table from op_schem.dataset where tx=23 This gave me 40 tables. Is there a way, I can do a select * from on each of these 40 tables and load them into flat…
RB17
  • 356
  • 1
  • 8
  • 26
-1
votes
1 answer

SAP Data Services 4.2 & PostgreSQL 10.5

I need to populate a table by using SAP DS in PostgreSQL. I've been trying to find out if PostgreSQL 10.5 is supported by SAP Data Services 4.2, but I couldn't find a proper answer. Does anybody know? Thanks!
Alex
  • 9
  • 2
-1
votes
1 answer

SAP BODS - Getting PK violation from a Table Comparison

I want to read from a table, change a couple column values for a few lines in a query, then update those lines on the same table. I'm using SAP BODS, and that's what I tried: I was about to insert images but just found out I can't insert images…
Max
  • 1
  • 3
-1
votes
1 answer

Get file name from SAP Data Services

I'm unable to read file name from data services which contain date_time format, I can read date but time can be variable, I've tried with *.csv on file name(s) property for flat file, but this for static file name. Example: File_20180520_200003.csv,…
naoufelabs
  • 133
  • 3
  • 9
-2
votes
0 answers

Microsoft-ODBC SQL Server Driver-Error after submitting ETL job on SAP BODS 4.3

I am getting below error when I try to execute ETL job on SAP BODS 4.3 We have recently upgraded to Data Services 4.3 but everytime I run ETL I see below error. (14.3) 08-24-23 03:35:24 (E) (0208:8732) CON-120302: |Session…
Chinmay Karanjkar
  • 1
  • 1
-3
votes
2 answers

Using SAP BODS to load data to Snowflake it is taking a lot of time

Using SAP BODS to load data to Snowflake it is taking a lot of time. BODS job is simple source (HANA table) query then Target as Snowflake table. Just to load 6 records with 10 columns it is taking more than half an hour. I analyzed where most of…
Mahantesh Hiremath
  • 15
  • 4
1 2 3 4
5