Connect to Salesforce and others from SAS using JDBC

Introduction

SAS is the leader in analytics. Through innovative analytics, BI and data management software and services, SAS helps turn your data into better decisions. SAS used to leverage the ODBC interface to access data across other SQL, NoSQL, SaaS and Big Data sources. Now they have introduced SAS/ACCESS Interface to JDBC, which means you can use Progress DataDirect JDBC drivers to connect to your favorite data sources. In this tutorial, we will walk you through on how you can connect to Salesforce data using Progress DataDirect JDBC drivers.

Download and Install DataDirect Salesforce JDBC driver

  1. Download DataDirect Salesforce JDBC driver from here.
  2. To install the driver, you would have to execute the .jar package and you can do it by running the following command in terminal or just by double clicking on the jar package.
    java -jar PROGRESS_DATADIRECT_JDBC_SF_ALL.jar
  3. This will launch an interactive Java installer which you can use to install the Salesforce JDBC driver to your desired location as either a licensed or evaluation installation.
  4. Note that this will install Salesforce JDBC driver and bunch of other drivers too for your trial purposes in the same folder.

Connect to Salesforce from SAS

  1. With SAS/ACCESS Interface to JDBC, you can now easily connect to your data in Salesforce driver using Progress DataDirect Salesforce driver.
  2. To get started, Open SAS and create a New Program by going to File->New Program.
  3. Below is a sample program you can use to connect to Salesforce and read the data from Opportunity table.
    libname x jdbc driverclass="com.ddtek.jdbc.sforce.SForceDriver"
    URL='jdbc:datadirect:sforce://login.salesforce.com;SecurityToken=1CMqHZ8yskBcjC2lrSI8khdsa37;'
    USER='user@company.com'
    PASSWORD='mypassword'
    classpath="C:\Program Files\Progress\DataDirect\JDBC_60\lib";
    proc print data=x.OPPORTUNITY;
    run;
  4. Now when you run the program, you should see your data as shown below.

    sas results

With SAS/ACCESS Interface to JDBC, you can now connect to your Salesforce data as easily as that. Not only you can connect to Salesforce using Progress DataDirect drivers, you can connect to sources such as MongoDB, DB2, Redshift, Oracle, SQL Server, Eloqua etc., Feel free to try any our JDBC drivers and if you have any questions, please contact us.

JDBC TUTORIAL

Connect to Salesforce and others from SAS using JDBC

View all Tutorials

Connect any application to any data source anywhere

A product specialist will be glad to get in
touch with you