SAP HANA Cloud

Create an SAP HANA Cloud Data Source
1.Navigate to: Resources > Data Sources
2.Select the SAP HANA Cloud icon:
Data Source Inputs
Name (required)
Host (required):
Enter the hostname of your SAP HANA Cloud database. 
Example: ww23456-1db2-4dd0-8cbe-71521705c697.hana.prod-eu10.hanacloud.ondemand.com
Port (required): 30015 or 443 are default values
Database (optional)
Credential Type: See Data Source Security​
Username (required - can be entered later): Username used for connecting to SAP HANA Cloud
Password (required - can be entered later): Password used for connecting to SAP HANA Cloud
Use SAP HANA Cloud
Read
Python
SQL
1
%python
2
import pandas as pd
3
​
4
# Create dbapi Connection object
5
conn = z.getDatasource("zepl_docs_sap_hana")
6
​
7
# Create dbapi Cursor object
8
cursor = conn.cursor()
9
​
10
# Create SQL statement
11
sql_command = 'SELECT * FROM "ZEPL"."View_1" LIMIT 100;'
12
​
13
# Execute SQL statment and fetch results
14
cursor.execute(sql_command)
15
data = cursor.fetchall()
16
​
17
# Convert to Pandas DataFrame
18
df = pd.DataFrame(data)
19
df.columns = [col[0] for col in cursor.description]
20
​
21
z.show(df)
Copied!
Use z.getDatasource()  to return SAP Connection Object: pyhdbcli.Connection​
1
%datasource.zepl_docs_sap_hana
2
​
3
SELECT * FROM "ZEPL"."View_1" LIMIT 3; 
Copied!
Write
Python
1
%python
2
import pandas as pd
3
​
4
# Create dbapi Connection object
5
conn = z.getDatasource("zepl_docs_sap_hana")
6
​
7
# Create dbapi Cursor object
8
cursor = conn.cursor()
9
​
10
# Values to insert into the HANA table. This is an example, but these values can come from a list or dataframe. Simply loop through and insert each row.
11
sql = "INSERT INTO \"ZEPL\".\"View_1\" VALUES(19, 'PAYMENT', 1234.00, 'C1616398702',0, 0, 'M2089277435',0,0, FALSE, FALSE )"
12
​
13
# Insert row into SAP HANA
14
cursor.execute(sql)
15
​
16
# Display number of rows inserted successfully
17
cursor.rowcount
Copied!
​Open examples in Zepl​
Configure Authentication
Please reference SAP's Documentation to setup your SAP HANA database environment. One recommended method of access is through SAP Data Warehouse Cloud (DWC). Create a Space for your Zepl project and Database Users with both Ingest and Consumption enabled. You will be given a Username and Password that you can enter into the Zepl Data Source inputs. 
​