Skip to Content

How to pull Data into python from SAP BW?

Hi, I am a data scientist and do not have a prior background of SAP.

I need to pull data from SAP BW to python for some analysis, but I am not able to find the right answer to this.

I Found a library "hdbcli" which is for connecting with SAP HANA. Can I use this library for the aforementioned task?

Please help

Add a comment
10|10000 characters needed characters exceeded

  • Hi, keep in mind that SAP BW is an application, not a database. The first thing you would need to answer is what type of object/content do you need to read from BW (Query, Cube, DSO, aDSO, HANA tables, other DB-tables, etc.). Additionally, you need to know on which Database your BW runs on (HANA, Oracle, MS SQL Server, etc.). The answers to these questions will dictate the possibilities for connecting from an external application.

    The library you mention is for connecting directly to HANA databases, which could include BW, but also other HANA-based applications. This would also bypass the BW application semantic layer and you would be restricted to reading HANA views and tables.

Related questions

1 Answer

  • Posted on May 21 at 10:18 AM

    First you must check "Open Analysis Interfaces" for your BW version.

    For example, for BW 7.5:

    https://help.sap.com/viewer/64e2cdef95134a2b8870ccfa29cbedc3/7.5.16/en-US/d9ed8c3c59021315e10000000a114084.html

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.