Create an SAP Data Warehouse Cloud Data Source

1. Navigate to: Resources > Data Sources

2. Select the SAP Data Warehouse Cloud icon:

Data Source Inputs

• Name (required)

• Host (required):

  • Enter the hostname of your SAP Data Warehouse 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 Data Warehouse Cloud

• Password (required - can be entered later): Password used for connecting to SAP Data Warehouse Cloud

Use SAP Data Warehouse Cloud

Read

%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)

%datasource.zepl_docs_sap_hana
​
SELECT * FROM "ZEPL"."View_1" LIMIT 3; 

Write

%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 Data Warehouse Cloud database environment. 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.

​