BookmarkSubscribeRSS Feed
WHH
Calcite | Level 5 WHH
Calcite | Level 5

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

3 REPLIES 3
MargaretC
SAS Employee

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

SASKiwi
PROC Star

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.

 

JBailey
Barite | Level 11

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

 

Best wishes,

Jeff

@JBailey

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1343 views
  • 2 likes
  • 4 in conversation