Providing software solutions since 1976
Usage Note 44785: System requirements for SAS/ACCESS® Interface to Greenplum in UNIX environments
 |  |  |  |
SAS/ACCESS Interface to Greenplum provides access to the EMC Greenplum database.
This product delivers the Open Database Connectivity (ODBC) drivers needed to connect to Greenplum with the Greenplum engine. The supplied DataDirect Greenplum ODBC drivers cannot be accessed using the ODBC engine.
To verify that SAS/ACCESS Interface to Greenplum is licensed, invoke SAS and submit the following in the SAS Editor:
proc setinit noalias; run;
Look in the SAS log for SAS/ACCESS Interface to Greenplum. If you do not see the product name listed, then you do not have this product licensed.
If you do see this product name listed, verify that it has been installed. Change directory to the !SASROOT/sasexe folder and verify that the sasgpl and sasiogpl files exist. If you do not see these files listed, then you do not have the product installed.
There are two system requirements for using SAS/ACCESS Interface to Greenplum under UNIX:
- Base SAS® software
- SAS/ACCESS Interface to Greenplum software
Here are some examples using the Greenplum engine:
LIBNAME statement with a data source name (DSN):
libname grn1 greenplm dsn=greenplum user=gpuser password=gppass schema=public;
LIBNAME statement without a DSN:
libname grn2 greenplm server="gpserver.us.company.com" port=5432 database=gpdb user=gpuser password=gppass schema=public;
Explicit pass-through with a DSN:
proc sql;
connect to greenplm(dsn=greenplm user=gpuser password=gppass);
...
disconnect from greenplm;
quit;
Explicit pass-through without a DSN:
proc sql;
connect to greenplm(server="gpserver.us.company.com" port=5432 database=gpdb user=gpuser password=gppass);
...
disconnect from greenplm;
quit;
Troubleshooting and Common Errors
Error
libname myconn greenplum user=dbitest password=XXXXXXX dsn=greenplum schema=public;
ERROR: The GREEPLUM engine cannot be found.
ERROR: Error in the LIBNAME statement.
Cause: Misspelled engine name. Valid names are "greenplm" and "sasiogpl".
Error
libname myconn greenplm user=dbitest password=XXXXXXX dsn=greenplum schema=public;
ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib]
System information file not found. Please check the ODBCINI
environment variable.
ERROR: Error in the LIBNAME statement.
Cause: The environment variable ODBCINI is not set.
Note: The following are four important environment variables that should be set.
export ODBCHOME=/path_to_directory_where_DDSO.LIC_is_located
export ODBCINI=$ODBCHOME/odbc.ini
export ODBCINST=$ODBCHOME/odbcinst.ini
export LD_LIBRARY_PATH=$ODBCHOME/lib:$LD_LIBRARY_PATH
Error
libname myconn greenplm user=dbitest password=XXXXXXX dsn=greenplum schema=public;
ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Data
source name not found and no default driver specified
ERROR: Error in the LIBNAME statement.
Cause: DSN entry has not been defined in the odbc.ini file. Make sure that there is a DSN entry defined in the odbc.ini file.
Error
libname myconn greenplm server="192.168.123.45" port=5432 database=test user=gpuser password=XXXXXXX schema=public;
ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib]
Specified driver could not be loaded
ERROR: Error in the LIBNAME statement.
Causes:
- The ODBCINST environment variable has not been set
- The odbcinst.ini does not have the correct path to the drivers
Error
libname myconn greenplm dsn=greenplum user=dbi password=XXXXXXXX schema=public;
ERROR: CLI error trying to establish connection: [SAS ACCESS to Greenplum] [ODBC Greenplum Wire Protocol driver]
[Greenplum]FATAL: role "dbi" does not exist(File miscinit.c;Line 436;Routine InitializeSessionUserId;) :
[SAS ACCESS to Greenplum][ODBC Greenplum Wire Protocol driver]Socket closed.
ERROR: Error in the LIBNAME statement.
Cause: The concept of a "role" in Greenplum encapsulates users and groups in the database. The most likely cause of this error is that the user has not been defined in Greenplum.
Error
The warning message below appears when you try to use the connection to Greenplum:
Warning:
[SAS ACCESS to Greenplum][ODBC Greenplum Wire Protocol driver] The DataDirect product you are attempting to
access has been provided to you by SAS Institute, Inc for exclusive use with SAS ACCESS to Greenplum.
You are not licensed to use this product with any application other than SAS ACCESS to Greenplum.
If you would like to purchase this product for some other use, please call 800-876-3101 or visit DataDirect
at www.datadirect.com
Cause: When you try to use the connection to Greenplum, this error occurs if you used the ODBC engine instead of the GREENPLUM engine.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Greenplum | 64-bit Enabled AIX | 9.3 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.3 | 9.3 TS1M0 | ||||
| HP-UX IPF | 9.3 | 9.3 TS1M0 | ||||
| Linux | 9.3 | 9.3 TS1M0 | ||||
| Linux for x64 | 9.3 | 9.3 TS1M0 | ||||
| Solaris for x64 | 9.3 | 9.3 TS1M0 | ||||
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> GreenPlum |
| Date Modified: | 2011-12-02 14:23:44 |
| Date Created: | 2011-11-02 16:42:57 |
