Usage Note 65280: Single Sign-On (SSO) support for Greenplum in-database macros
 |  |  |  |  |
SAS/ACCESS® Interface to Greenplum in-database macros currently do not support SSO connections.
Click the Hot Fix tab in this note to access the hot fix for this issue.
This hot fix enables the macros to accept SSO connections.
You can set the connection details by using either of the following methods:
- Use the options in the data source name (DSN) entry in the odbc.ini file.
- Use the CONOPTS= option in a DSN-less connection similar to the following:
%let indconn= server='gpserver.unx.com' db=database port=5432 schema=test
conopts='AuthenticationMethod=4;ServicePrincipalName=postgres/gpserver.unx.com@PDE.KRB.SAS.COM';
conopts='AuthenticationMethod=4;ServicePrincipalName=postgres/gpserver.unx.com@PDE.KRB.SAS.COM';
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS In-Database Code Accelerator for Greenplum | Microsoft® Windows® for x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 |
| Microsoft Windows 8 Enterprise 32-bit | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Enterprise x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Pro 32-bit | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Pro x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Pro x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 10 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Datacenter | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Std | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Std | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2016 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2019 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Enterprise 32 bit | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Enterprise x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Home Premium 32 bit | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Home Premium x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Professional 32 bit | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Professional x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Ultimate 32 bit | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Ultimate x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| 64-bit Enabled AIX | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| 64-bit Enabled Solaris | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| HP-UX IPF | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Linux for x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Solaris for x64 | 9.43 | 9.44 | 9.4 TS1M6 | 9.4 TS1M7 | ||
A fix for this issue for SAS Accelerator Publishing Agent for Greenplum 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F4U.html#65280A fix for this issue for SAS Accelerator Publishing Agent for Greenplum 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F1Q.html#65280| Type: | Usage Note |
| Priority: |
| Date Modified: | 2019-12-23 14:35:23 |
| Date Created: | 2019-12-20 09:36:56 |