ODBC connection to IBM Netezza

Ivy — Thu, 18 Feb 2016 15:34:10 GMT

Dear friends,

I am trying to coonect IBM Netezza using libname in SAS. The NZSQL data source is configured in the ODBC Administrator Control Panel on Windows platforms, I filled out the server name, port, user name , and database in the ODBC adminstrotor.

However, the following libname statement did not work at SAS. 😞

libname cde netezza dsn= NZSQL user= password= abcde;

ERROR: The NETEZZA engine cannot be found

How this can be fixed ?

Thank you very much,

Ivy

Re: ODBC connection to IBM Netezza

ballardw — Thu, 18 Feb 2016 15:56:46 GMT

Your libname statment may be incomplete for using ODBC, it should look like

LIBNAME libref odbc <connection-options> <LIBNAME-options>;

With netezza instead of odbc in your code it is attempting to use the Netezza engine which requires that specific license. And you may want to use DATAsrc=NZSQL instead of DSN. From the documentation:

DSN= is an alias for this option that indicates that the connection is attempted using the ODBC SQLConnect API, which requires a data source name. You can also use a user ID and password with DSN=. If you want to use an ODBC file DSN, then instead of supplying DATAsrc=<'>ODBC-data-source<'>, use the PROMPT= or NOPROMPT= option followed by "filedsn=(name-of-your-file-dsn);". For example:

libname mydblib odbc noprompt="filedsn=d:\share\msafiledsn.dsn;";

topic Re: ODBC connection to IBM Netezza in SAS Programming

ODBC connection to IBM Netezza

Re: ODBC connection to IBM Netezza