DATA Step, Macro, Functions and more

ODBC connection to IBM Netezza

Reply
Frequent Contributor
Frequent Contributor
Posts: 76

ODBC connection to IBM Netezza

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 

 

 

Super User
Posts: 10,516

Re: ODBC connection to IBM Netezza

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;";

 

Ask a Question
Discussion stats
  • 1 reply
  • 386 views
  • 0 likes
  • 2 in conversation