SAS/ACCESS Interface to Greenplum provides access to the EMC Greenplum database.

This product delivers the necessary Open Database Connectivity (ODBC) drivers to connect to Greenplum with the "greenplm" engine. The supplied DataDirect Greenplum ODBC drivers cannot be accessed using the "odbc" engine.

To verify that this product is licensed, invoke SAS and submit the following in the SAS Editor:

   proc setinit noalias; run;

Look in the SASLOG for SAS/ACCESS Interface to Greenplum. If you do not see this product listed, then you do not have the product licensed.

If you see this product listed, verify that you have it installed. Using Windows Explorer, look in the !SASROOT\access\sasexe folder for SASGPL.DLL and SASIOGPL.DLL. If you do not see these files listed, then you do not have this product installed.

Here are the system requirements for using the Windows or Windows for x64 version of SAS/ACCESS Interface to Greenplum:

• Base SAS^® software
• SAS/ACCESS Interface to Greenplum software

Examples That Illustrate Use of the Greenplum Engine

• LIBNAME with a DSN

  libname grn1 greenplm dsn=greenplum user=gpuser password=gppass schema=public;
  

• LIBNAME 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=greenplum 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

libname myconn greenplum user=dbitest password=XXXXXXX dsn=greenplum schema=public;

WARNING: The name greenplum has been truncated to 8 characters.
ERROR: The GREENPLU engine cannot be found.
ERROR: Error in the LIBNAME statement.

Error:

libname myconn greenplm user=dbitest password=XXXXXXX dsn=greenplum schema=public;

CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
ERROR: Error in the LIBNAME statement.

Note: If SAS is running on Windows x64, the Windows ODBC Data Source Administrator is found in two places.

If SAS is 32-bit, the correct Windows ODBC Data Source Administrator is found here:

C:\Windows\SysWOW64\odbcad32.exe

If SAS is 64-bit, the correct Windows ODBC Data Source Administrator is found here:

C:\Windows\System32\odbcad32.exe

Error:

libname myconn greenplm server="192.168.123.45" port=5432 database=test user=gpuser password=XXXXXXX schema=public;

CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
ERROR: Error in the LIBNAME statement.

Note: The zip files containing the drivers and readme.txt can be found here:

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;Line436;Routine InitializeSessionUserId;) : [SAS 
ACCESS to Greenplum][ODBC Greenplum Wire Protocol driver]Socket closed.
ERROR: Error in the LIBNAME statement.

Error:

The dialog box below appears. SAS code is trying to use the connection to Greenplum:

Operating System and Release Information