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: https://www.progress.com/data-sources/amazon-redshift
Can you utilise SAS/ACCESS to Postgresql for Amazon Redshift as it is based on Postgresql?
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.
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.
Want to write an article? Sign in with your profile.