BookmarkSubscribeRSS Feed

How does SAS Support Amazon Redshift?

Started ‎06-24-2015 by
Modified ‎05-05-2016 by
Views 10,393

SAS Support Amazon Redshift via SAS/ACCESS Interface to ODBC.


An ODBC Driver is available from Amazon. Information about it can be found here:


Once this ODBC driver is installed and configured, then the SAS/ACCESS to ODBC interface engine is able to connect to it:


This SAS Global Forum paper elaborates more details about how these technologies operate together:


DataDirect also produces an ODBC driver for Redshift. It is much faster at loading data from a non-AWS location into Redshift. This driver is not free. The Amazon Redshift driver is free.

Here is the link:

Can you utilise SAS/ACCESS to Postgresql for Amazon Redshift as it is based on Postgresql?  

I can't answer this completely, but here's what I learned. While Amazon Redshift is based on PostgresSQL, it is optimized for a certain style of transaction and omits many features that you might be accustomed to. See Amazon's documentation here:



SAS/ACCESS to PostgreSQL is not a valid way to access Redshift data. In the beginning, Amazon pointed people to a PostgreSQL ODBC driver. It was problematic. That is why they created and Amazon Redshift specific ODBC driver.


Right now (and this may change, soon), the preferred method to access Redshift from SAS is via SAS/ACCESS to ODBC combined with a Redshift ODBC driver. Amazon and DataDirect produce ODBC drivers.

****** UPDATE******

The preferred method of accessing Redshift data is via SAS/ACCESS Interface to Redshift. 


Also, as of April 2016, SAS/ACCESS Interface to Amazon Redshift is a new offering. You can use this SAS/ACCESS engine that is geared specifically to Amazon Redshift  to take advantage of features access the DBMS system directly. You can find more information about direct support for Amazon Redshift here

You can see SAS/ACCESS to Amazon Redshift in action in this talk and demo from SAS Global Forum -- check it out!  Hear about how Amazon Redshift can be slower with straight ODBC, and much faster with the dedicated access engine. 

Version history
Last update:
‎05-05-2016 09:08 AM
Updated by:



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Labels
Article Tags