topic Can SAS access to Cloud data? in Administration and Deployment

Can SAS access to Cloud data?

WHH — Tue, 14 Nov 2017 18:54:11 GMT

Is that possible that SAS can access to the third party cloud data. e.g. SalesForce

Re: Can SAS access to Cloud data?

MargaretC — Tue, 14 Nov 2017 19:08:25 GMT

This question has been asked before on this community. Here is the answer:

"Using SAS/ACCESS to ODBC is the only way you can currently access salesforce.com data.

Please contact Data Direct or Simba or salesforce.com themselves for the driver."

Cheers,

Margaret

Re: Can SAS access to Cloud data?

SASKiwi — Tue, 14 Nov 2017 19:18:36 GMT

A quick Google confirms there are ODBC drivers available for SalesForce. So as long as you have a network connection to the database from your SAS server plus SAS/ACCESS to ODBC installed and licensed and the SalesForce ODBC driver installed then in theory it should all just work.

BTW it shouldn't matter whether SalesForce is cloud-based or not as long as you have a working network connection from SAS.

Re: Can SAS access to Cloud data?

JBailey — Fri, 07 Jun 2019 15:06:18 GMT

Hi,

This is exciting. There is a new SAS/ACCESS product for Salesforce. This product requires SAS 9.4M6.

For more information take a look at the doc.

SAS Doc (Non-Relational) https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=acnrdb&docsetTarget=titlepage.htm&locale=en

Best wishes,

Jeff

@JBailey