I have a python dataframe that I want to insert directly into HANA database and also wants to read it from database.
I have tried this code :
from sqlalchemy import create_engine engine = create_engine('hana+pyhdb://username:firstname.lastname@example.org:port') my_df = pd.DataFrame([[1,2],[3,4],[5,6],[7,8]], columns=["A","B"]) my_df.to_sql('table_name', con = engine, index =False, if_exists ='replace')
Error: DBAPIError: (hdbcli.dbapi.Error) (4321, 'only secure connections are allowed') (Background on this error at:http://sqlalche.me/e/dbapi)*
Is this about adding ssl certificate? How to add it in the engine ?
However, I'm able to connect OK via the Python API using the encrypt option:
conn = dbapi.connect( address="host", port=portnr, encrypt="true", user="user", password="pwd")
But, if I pass this connection object here:
my_df.to_sql('table_name', con = conn, index =False, if_exists ='replace')
I'll still get an error. How to fix this?