SAS ODBC Access to Salesforce, SQL Server and Marketo

Businesses can integrate any data source with SAS using ODBC drivers. In this tutorial, we outline how your SAS shops can benefit from DataDirect ODBC Drivers.

SAS and DataDirect ODBC Driver

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 leverages the ODBC interface to access data across other SQL, NoSQL, SaaS and Big Data sources.

Progress DataDirect is the co-founder of the ODBC standard and is the leader in standards based data connectivity. We developed the innovative wire-protocol architecture that provides direct access to data which eliminates the need for client dependencies or staging databases for SaaS sources.

Traditionally, ODBC drivers had required specialized database client libraries tied to specific database versions on each system that needed to interact with a database server. This translated into deployment, maintenance, performance and support headaches for IT administrators. However, with our ODBC driver architecture, we are able to deliver superior functionality over the wire for SAS shops to access data:

Our wire protocol architecture makes it an ideal choice to use with SAS shops. The drivers have been proven to work efficiently with SAS, and they go through extensive testing before each version of SAS is released. Foxwoods resort complex, the largest casino in the US, used our ODBC drivers to connect SAS to its data sources. Learn more from Foxwood’s success story. Our SAS solutions page also talks more about what we can do for SAS shops.

Connect SAS to Salesforce, Marketo or Eloqua

As enterprise applications proliferate, data becomes more and more siloed. In such a distributed environment, it becomes essential for businesses to be able to connect their SAS application to a variety of data sources such as Salesforce, SQL Server, Marketo or Eloqua. Enabling ODBC access to these sources from SAS involves the following steps:

Installing the drivers
Setting the environment variables
Configuring the connection to the database
Setting up the ODBC connection in SAS

We have set up the following tutorials to help you connect SAS to other data sources:

You can learn more about our SAS solutions here, and our award-winning technical support team is available 24x7 to work with you on any questions you may have. Talk to an expert right away.

Idaliz Baez

Idaliz is a Sales Engineer with Progress. After receiving her undergraduate degree from Duke University in Civil and Environmental Engineering, Idaliz Baez spent a year at NASA Goddard Space Flight Center gaining on-the-job experience before returning to Duke in pursuit of her Masters of Engineering Management degree.