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
%python
import pandas as pd
​
# Create dbapi Connection object
conn = z.getDatasource("zepl_docs_sap_hana")
​
# Create dbapi Cursor object
cursor = conn.cursor()
​
# Create SQL statement
sql_command = 'SELECT * FROM "ZEPL"."View_1" LIMIT 100;'
​
# Execute SQL statment and fetch results
cursor.execute(sql_command)
data = cursor.fetchall()
​
# Convert to Pandas DataFrame
df = pd.DataFrame(data)
df.columns = [col[0] for col in cursor.description]
​
z.show(df)
Use z.getDatasource()  to return SAP Connection Object: pyhdbcli.Connection​
%datasource.zepl_docs_sap_hana
​
SELECT * FROM "ZEPL"."View_1" LIMIT 3; 
Write
Python
%python
import pandas as pd
​
# Create dbapi Connection object
conn = z.getDatasource("zepl_docs_sap_hana")
​
# Create dbapi Cursor object
cursor = conn.cursor()
​
# 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.
sql = "INSERT INTO \"ZEPL\".\"View_1\" VALUES(19, 'PAYMENT', 1234.00, 'C1616398702',0, 0, 'M2089277435',0,0, FALSE, FALSE )"
​
# Insert row into SAP HANA
cursor.execute(sql)
​
# Display number of rows inserted successfully
cursor.rowcount
​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. 
​