Page 1 of 1

SAP Hana odbc connection / data direct odbc driver manager

Posted: Tue Dec 10, 2013 7:37 am
by wbeitler
Hi all,

trying to find out how to get the SAP Hana ODBC driver simultaniously with the other datadirect odbc drivers (Need to read from SAP Hana and write to Netezza, preferably in one go). But hard to find any best practices on the net.... So... Anyone?

thanks again,

William

Posted: Tue Dec 10, 2013 10:59 am
by asorrell
I've used two other "non-standard" ODBC drivers and I got them both to work the same way. Use the same entry mechanism in the .odbc.ini & uvodbc.config files that you do for other drivers.

This means putting the path to the new library in the .odbc.ini file under a connection definition. You'll need to get the connection options from the documentation for the new drivers - don't assume the standard ones will work.

If you have errors, come back and post your definitions and error messages and we'll see if we can assist.

Posted: Mon Mar 10, 2014 10:33 am
by wbeitler
'Standard' odbc.ini and uvodbc.config setup worked in the end after IBM provided a new DDODBC.LIC