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 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

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