SAP Hana odbc connection / data direct odbc driver manager

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
wbeitler
Premium Member
Premium Member
Posts: 70
Joined: Tue Feb 21, 2006 2:58 am
Location: Netherlands
Contact:

SAP Hana odbc connection / data direct odbc driver manager

Post 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
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post 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.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
wbeitler
Premium Member
Premium Member
Posts: 70
Joined: Tue Feb 21, 2006 2:58 am
Location: Netherlands
Contact:

Post by wbeitler »

'Standard' odbc.ini and uvodbc.config setup worked in the end after IBM provided a new DDODBC.LIC
Post Reply