python连接SAP HANA 数据库

高个子男孩

已于 2023-07-21 16:58:56 修改

阅读量406

点赞数

分类专栏： Python 文章标签： python 数据库

于 2023-07-21 16:58:04 首次发布

本文链接：https://blog.csdn.net/qq_41982570/article/details/131855788

版权

Python 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

SAP 官方有关Python连接HANA数据库方式
https://developers.sap.com/tutorials/hana-clients-python.html

在这里插入图片描述

实例

#!/usr/bin/python3

# Import your dependencies
import platform
from hdbcli import dbapi

# verify the architecture of Python
print("Platform architecture: " + platform.architecture()[0])

# Initialize your connection
conn = dbapi.connect(

    address='xx.xx.xx.xx',
    port='xx',
    user='xx',
    password='xx',
    currentschema='xx'
)
# If no errors, print connected
print('connected')

cursor = conn.cursor()
sql_command = '''
        select  * from xxxx
'''
cursor.execute(sql_command)

rows = cursor.fetchall()
for row in rows:
    for col in row:
        print("%s" % col, end=" ")
    print("  ")
cursor.close()
print("\n")

cursor.close()
conn.close()