How to connect to SAP HANA Studio using 'Database - Connect' activity

You might be able to use “HANADB1” as the Data Source Name (DSN).

ConnectionString = “DSN=HANADB1;UID=myUser;PWD=myPassword”

There’s more information about connecting to SAP HANA via ODBC here.

https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.03/en-US/66a4169b84b2466892e1af9781049836.html

Hope this helps.

1 Like