New addition to SAS/ACCESS software family - SAS/ACCESS to Amazon Redshift

[#1]

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.   

• It simplifies installation and configuration. 

       - We worked with Progress Software so that you could have an easier access to their DataDirect ODBC driver to be used with SAS/ACCESS software. SAS/ACCESS to Amazon Redshift includes the driver which gets deployed as a part of SAS/ACCESS engine installation. 

• It simplifies connection with and without a DSN configuration.

• It provides National Language Support.

• It enables performance boosting techniques: 

        -  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.

[PrabhakarC]

Hi Team,
Working in SAS2AWS conversion project , in one of my code we are using VBscript where we are replacing ~ symbol with the \n using the below part in the VBscript,

strNewText = Replace(strText, "~", "~"& vbCrLf )

But this is working in SA9.3 but not in SAS9.4.

Could some one please help on this in way how to update it in so that it will work under LINUX 9.4.

[AnnaBrown]

Hi @PrabhakarC, 

Thanks for your question! If you've not already, I suggest opening a SAS Technical Support track for this scenario. The team there should be able to work through this with you.

Anna

[PrabhakarC]

Thanks @AnnaBrown , I have created ticket under the given request.

[AnnaBrown]

Wonderful to hear, @PrabhakarC. Thanks for using the communities!