Connect to Salesforce and others from SAS using JDBC

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.

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.
   
   
   

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.