Query data
Tags: #sap #saphana #database #snippet
Author: Jeremy Ravenel

Input

Install packages

1
!pip install hdbcli
Copied!

Import library

1
import sap_hana_connector
Copied!

Declare variables

1
type: 'SapHana'
2
name: 'JPAK_LIVE'
3
user: 'USER'
4
password: 'PASSWORD'
5
port: 30015
6
host: 'HOST'
Copied!

Model

Query to get specific table in SAP HANA

1
query: 'SELECT * FROM JPAK_LIVE.OINV T0'
Copied!

Output

Return Data Frame

1
df = query
Copied!
Last modified 2mo ago
Copy link
Edit on GitHub