cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Is there a way to automatically run the query in SAP DSP via python?

0 Kudos
136

Is there a way to automatically run the query in SAP DSP via python and create an export file on users machine

 

Thanks  

Accepted Solutions (0)

Answers (1)

Answers (1)

XaviPolo
Active Contributor
0 Kudos

You can use Python (from a file or a Jupyter Notebook) to connect to the SAP Datasphere HANA Database. This allows you to send queries, retrieve data, and use it as you wish (e.g., store it in a file, convert it to Excel, send it to a database).

To configure SQL access, you'll need to do it space by space within Space Management (see Integrating Data via Database Users/Open SQL Schemas | SAP Help Portal). 

However, if you're asking about using Python Transformation within a Data Flow in SAP Datasphere, then no, that's not possible. Input/output functions are prohibited for Python code executed in DSP Data Flows.

Regads,