Python Data Engineer Enterprise Notebook
Project description
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...
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.