BookmarkSubscribeRSS Feed

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

Started ‎05-20-2016 by
Modified ‎05-20-2016 by
Views 2,432

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.

 

Comments

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.

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

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

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

Version history
Last update:
‎05-20-2016 11:27 AM
Updated by:
Contributors

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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