cancel
Showing results for 
Search instead for 
Did you mean: 

Writing Table data to csv or text file in SAP Datasphere

Satheesh9204
Explorer
0 Kudos
788

Hi Experts, 

We were able to write data to file format in SAP BODS. Similarly, Is there any operator/transform to write data from DB table to file (CSV or Text) in SAP Datasphere? 

 

Appreciate your help.

 

Thank You 

View Entire Topic
JulianJuraske
Participant
0 Kudos

Yes but this would result in a File in a different System, a direct Export from DSP is not possible and I think this is the Question here @Satheesh9204 ? 
However you can manually export the Result of a Analytic Model when using the Preview Feature 😉 
But this is not something that you can schedule/automate

JulianJuraske_0-1729069485307.png

 



n_gaertner
Product and Topic Expert
Product and Topic Expert

Hello Julian,

I understood the question like if DSP can write CSV files (probably as part of an automated data flow), not if it is possible to export the data on UI level.
If it is just about accessing data via excel, then ODBC access would also work (i have posted a link above), and you could then save it in whatever format you like.

Best Regards,

Nico

JulianJuraske
Participant
0 Kudos
You are total right, he said BODS, so probalby he is talking about generating files in another System.