Problem Note 68235: Creating a Redshift Data Service in SAS® Federation Server 4.4 generates the error "License check failed for feature 'TK Ext for Amazon Redshift'..."
 |  |  |  |  |
When you create a Redshift Data Service in SAS Federation Server 4.4, the following error might occur:
License check failed for feature 'TK Ext for Amazon Redshift': The feature is not licensed
SAS Federation Server Driver for Redshift is not available with SAS Federation Server 4.4. Instead, you must use Data Direct Redshift ODBC driver, which is included with SAS Federation Server 4.4. Although the driver is included, you must configure the following files, which are available on the Downloads tab:
- odbc.ini
- odbcinst.ini
After you download the files, you can use this example LIBNAME statement to connect to a REDSHIFT Data source. In the statement below, italic text indicates where you need to input your values.
LIBNAME fedred FEDSVR DSN=redshift1 SERVER="servername.sas.com" PORT=24141 USER=user PASSWORD=XXXXXXX;
NOTE: Libref FEDRED was successfully assigned as follows:
Engine: FEDSVR
Physical Name: redshift1
Engine: FEDSVR
Physical Name: redshift1
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Solaris for x64 | 4.4 | 4.5 | 9.4 TS1M7 | 9.4 TS1M8 |
| Linux for x64 | 4.4 | 4.5 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| HP-UX IPF | 4.4 | 4.5 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| 64-bit Enabled Solaris | 4.4 | 4.5 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| 64-bit Enabled AIX | 4.4 | 4.5 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft® Windows® for x64 | 4.4 | 4.5 | 9.4 TS1M7 | 9.4 TS1M8 | ||
Download this ZIP file and configure the contents to connect to a REDSHIFT data source.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Redbrick |
| Date Modified: | 2021-08-25 13:21:08 |
| Date Created: | 2021-08-11 19:28:24 |