Skip to Content
0
Jul 16 at 08:51 AM

batch insert of tuples into HANA using HANA Client in SAP Data Intelligence

234 Views Last edit Jul 16 at 08:51 AM 2 rev

via python code , I can do batch insert to HANA table ( code sample below )

_list = []

# loop and add tuples to the _list 
_list.append( tuple ( ( value1, values2 , values3  )) )   
  
PARAMS = '?,?,?'     
SQL = f"insert into schema.table values ( {PARAMS})"
cursor.executemany(SQL , _SQL_TUPLE)

How can we achieve the same in HANA client