How to create/export a CSV file from Datasphere?

[RafaelBizzotto]

Hi all,

I need to create a CSV file based in a table from Datasphere.

In the past we had a SAP BW sytems which was responsible to export some data saving it in a local share drive by a CSV file.

Is there any option for creating a CSV from Datasphere?

[XaviPolo]

Datasphere does not have a process to generate and serve files.

You should use a sencodary system to archive this:

• Share Table to Open SQL Schema, to allow access from an external system via SQL interface. From there you can read and export to CSV using any programming language like Python, js, etc or SQL clients like DBeaver, etc  
• Create an analytical model on top of the table and pusblish odata service to access with this protocol. Use the odata to access data and generate the CSV with it. It's easy with Python and Pandas, powershell, or Excel.
• Integrate an object storage system with a connection in DSP, like AWS S3, and use Replication Flow to export the content of the table to the S3. You can get from there the file.

Regards,

[amolabhyankar]

or access the Analytical View in SAP AFO file so data will be directly put in Excel via AFO