In April 2016, the SAS/ACCESS family of products grew by a new member: SAS/ACCESS Interface to Amazon Redshift.
While you could (and still can) use SAS/ACCESS to ODBC to access Amazon Redshift data from your SAS jobs and applications, the new engine brings a series of enhancements over that route.
- Enhanced implicit pass-through (implicit conversion of SAS queries into Amazon Redshift SQL). Implicit pass-through is turned on by default (DBIDIRECTEXEC option) to minimize the amount of data transferred to SAS.
- More SAS functions will push down to the database.
- Explicit pass-through support (you can create and execute Amazon Redshift code from SAS).
- Better data insert performance.
Note that SAS/ACCESS Interface to Amazon Redshift requires the 3rd Maintenance release of SAS 9.4.
"This sounds good; where do I learn more?", you wonder. There is a recently published whitepaper that provides much more granular info and code examples: It’s raining data! Harnessing the Cloud with Amazon Redshift and SAS/ACCESS, by Chris DeHart and Jeff Bailey.
You might also want to check out the SAS Tech Talk: Using SAS/ACCESS to Amazon Redshift, a five-minute recording that demonstrates SAS/ACCESS to Amazon Redshift in action and highlights its performance benefits.