Usage Note 21061: Requirements for SAS/ACCESS® Interface to Netezza on Unix
SAS/ACCESS Interface to Netezza allows you to access a Netezza database
from SAS. To verify that this product is licensed, invoke SAS and submit
the following in the SAS Program Editor screen:
proc setinit noalias; run;
and look in the SASLOG for
---PRODNUM550
-OR-
---SAS/ACCESS Interface to Netezza
If you do not see the PRODNUM550 or SAS/ACCESS Interface to Netezza
product listed, then it is not licensed. If the product is listed, then
verify that it is installed.
To verify that the SAS/ACCESS Interface to Netezza product is installed,
the files, sasnza and sasionza, must reside in the !SASROOT/sasexe
directory, where !SASROOT is the directory where SAS is installed.
Issue the following commands to see if these files are installed.
unix_prompt> cd !SASROOT/sasexe
unix_prompt> ls -la sasnza
unix_prompt> ls -la sasionza
If these files does not exist then the product is not installed.
Below are the system requirements for using SAS/ACCESS Interface to
Netezza on Unix for SAS 9.:
- Base SAS software
- SAS/ACCESS Interface to Netezza software
- Netezza ODBC driver, release 3.1.4 or later
(available for download from the Netezza Web site or through Netezza
technical support; see below for more information)
SAS/ACCESS Interface to Netezza requires an ODBC driver from Netezza. To
get the Netezza ODBC driver, release 3.1.4 or above, please contact
Netezza technical support at (877) 810-4441 or visit the Netezza
customer support Web site, http://www.netezza.com/support/login.cfm.
The Netezza release may vary depending on the the Unix platform and SAS
Release so verify that you meet the system requirements by selecting the
appropriate operating system from the following link and view the system
requirements for SAS/ACCESS Interface to Netezza.
http://support.sas.com/documentation/installcenter/basic.html
If you meet the system requirements and you have all the necessary
software products, you must now configure the product using the
instructions in the SAS Configuration Guide.
http://support.sas.com/documentation/installcenter/the_sas_system/9.1.3_TS1M3/unx/config.pdf
You will need to run a NICKNAMES procedure to use NETEZZA instead of
SASIONZA in your syntax. The following code accomplishes this. Remember
that you must run it with a user ID that has write privileges for the
core catalog.
proc nickname cat=sashelp.core engine;
add nickname=netezza module=sasionza desc="SAS/ACCESS to Netezza"
preferred eng;
quit;
Be sure you have all the appropriate enviroment variables set correctly
and that your Netezza environment is set-up correctly (i.e. SHLIB_PATH,
LIBPATH, LD_LIBRARY_PATH).
NOTE: It is recommended that the environment variables should be set
in the "sasenv_local" file located in the !SASROOT/bin directory.
Prior to SAS 9.1.3 Service Pack 4, these environment variables
are recommended to be set in the "sasenv" file.
To verify that Netezza is configured appropriately outside of SAS, test
a connection using Netezza's ODBC utility, "nzsql", on the SAS server,
as follows:
unix_prompt> nzsql -host hostname databasename userid password
sql -> select count(*) from table_name
sql -> quit
/* Where hostname, dbname, userid, password & table_name are valid
Netezza values */
If you can NOT connect outside of SAS using the NZSQL utility, then you
will need to contact your Database Administrator (DBA) for assistance in
getting this to work.
Once you are able to connect outside of SAS and you have configured SAS
correctly, you are now ready to access Netezza from within SAS. You can
use the following access LIBNAME engine with SAS/ACCESS Interface to
Netezza example to test your connection:
libname nzalib netezza user=userid password=userpw server=hostname
database=dbname;
/* Use the same connections values used with NZSQL utility */
proc sql;
select count(*) from nzalib.table_name;
quit;
data work.new;
set nzalib.table_name;
run;
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Netezza | 64-bit Enabled AIX | 9.1 TS1M3 SP4 | |
HP-UX IPF | 9.1 TS1M3 SP4 | |
Linux | 9.1 TS1M3 SP4 | |
64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | |
64-bit Enabled Solaris | 9.1 TS1M3 SP4 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | |
Topic: | SAS Reference ==> LIBNAME Engines
|
Date Modified: | 2008-03-05 15:51:35 |
Date Created: | 2007-10-02 12:48:19 |