on 2025 May 19 4:46 PM
Is there a way to automatically run the query in SAP DSP via python and create an export file on users machine
Thanks
Request clarification before answering.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
30 | |
21 | |
16 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.