SAP HANA Cloud
Zepl’s native integration into SAP HANA Cloud gets teams connected to Zepl and analyzing their data in seconds. Read and write back are supported.
- 1.Navigate to: Resources > Data Sources
- 2.Select the SAP HANA Cloud icon:
- 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)
- 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
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)
%datasource.zepl_docs_sap_hana
SELECT * FROM "ZEPL"."View_1" LIMIT 3;
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
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.