pydeen 0.5.0

Python Data Engineer Enterprise Notebook

PYDEEN

Python Data Engineer Enterprise Notebook

Work with Enterprise data as an Data Engineer in notebook style.

Main features:

• Extract data from SAP ABAP Backend OData Services

• Extract data from SAP ABAP Backend via SQL (SAP abapGit Addon ZDEEB required)

• Websocket Stack for secure SAP ABAP callbacks and realtime messaging

current state and license

This library is still experimental at the moment and is currently being tested by selected people in practical scenarios. A release under an open source license is planned.

CHANGELOG

0.5.0

• bugfix sap_abap result to pandas - timestamp fields

• abapGit Addon DEEB support

• execute SQL statements in SAP ABAP (via DEEB Addon)

0.4.0 2022-08-07 pandas support

• basic auth menu

• property encoding

• export results as pandas dataframe

• parse odata xml

• sap type mapping (e.g. Date)

0.3.0 2022-08-04 sap abap odata support

• command line menu framework

• redesign pyodata support

• support for sap abap odata gateway

0.2.0 2022-06-30 odata v1

• doc for websocket usage

• websocket restart mode

• odata v2 access (pyodata) - early access

0.1.0 2022-06-21 initial pre-alpha release

• core types

• config file handling

• websocket scenario with default command handler for SAP APC

SAP Netweaver ABAP support

Pydeen support ABAP backend systems from releases like 7.40 to current S/4 HANA. No additional plugin is required. The default access is the ODATA gateway.

SAP ODATA example

# 1. import required libaries

from pydeen.auth import AuthBasic

from pydeen.sap_abap import SAPAbapHttpBackend, SAPAbapODataConnector



# 2. enter your sap backend connection details

sap_host = "http://<hostname|ip>:<port>"

sap_client = "<your_client>" 

sap_name = "<your_name>"



# 3. load authentification or open menu for interaction

auth = AuthBasic()

auth.set_menu_context(sap_name)

if auth.load_config(auth.get_menu_filename()) == False:

    auth.menu()



# 4. open a SAP backend with OData connector

backend = SAPAbapHttpBackend("SAP", sap_host, sap_client, auth=auth)

connector = SAPAbapODataConnector(backend)



# 5. open the sap OData connector menu for interaction: select endpoint + entity, select, get as pandas dataframe

connector.menu()



# 6. get the last selection as raw result

result = connector.get_current_result()

print(result)



# 7. get the last selection as pandas dataframe object

df = connector.get_current_result_as_pandas_df()

df.head()

df.info()



# 8. start step 5..7 again...