SAS ODBC Access to Salesforce, SQL Server and Marketo

SAS ODBC Access to Salesforce, SQL Server and Marketo

Posted on November 22, 2016 0 Comments
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:

Wire Protocol ODBC Drivers

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:

  1. Installing the drivers
  2. Setting the environment variables
  3. Configuring the connection to the database
  4. Setting up the ODBC connection in SAS

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

  1. Connect SAS to Salesforce, SQL Server, Oracle or RedShift using our Connect Drivers
  2. Connect to Marketo, Eloqua or Hubspot using our DataDirect Cloud Drivers

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. 


Comments are disabled in preview mode.

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation