Architecting, installing and maintaining your SAS environment

Accessing Salesforce data from SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Accessing Salesforce data from SAS

I would like to establish the ODBC connection to Salesforce from SAS. We have SAS/Access interface to ODBC installed at our site.

By reading the documentation,SAS(R) 9.3 Intelligence Platform: Data Administration Guide, Second Edition i understood that it requires the composite server to be installed.

I do not have the ODBC driver for salesforce installed on the SAS server. Does anybody know which ODBC driver is to be installed for this?

Also, once the driver is installed should i be following the below steps to access the salesforce data?

1)Establish ODBC connection to Salesforce

2)Create a connection to the server from SAS management console using New Server wizard

3)Create a ODBC library in SAS Management console using the New Library Wizard

4)Import the metadata

Are the above steps correct or will it require other tools to be installed (Like Composite studio) for accessing Salesforce data.


Accepted Solutions
Solution
Thursday
SAS Employee
Posts: 44

Re: Accessing Salesforce data from SAS

[ Edited ]

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.

 

 

View solution in original post


All Replies
Occasional Contributor
Posts: 14

Re: Accessing Salesforce data from SAS

Has anybody accessed SalesForce.com from SAS?

Regular Contributor
Posts: 180

Re: Accessing Salesforce data from SAS

As far I understand you need both: SAS Data Surveyor for Salesforce.com (Composite Studio) and SAS Access to ODBC. It means that you need at least SAS DI Server.

Super User
Posts: 5,257

Re: Accessing Salesforce data from SAS

The link shows in very clear steps what to do. What steps have you taken?

If you wish to try alternative solutions. you need to talk to SAS about what other options may apply, and are supported.

Data never sleeps
Solution
Thursday
SAS Employee
Posts: 44

Re: Accessing Salesforce data from SAS

[ Edited ]

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.

 

 

SAS Employee
Posts: 203

Re: Accessing Salesforce data from SAS

Hi @akshatadeshpande

 

This may help...

 

An Insider's Guide to SAS/ACCESS Interface to ODBC

 

There are some Salesforce examples in the paper.

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 2081 views
  • 0 likes
  • 5 in conversation