We’re smarter together. Learn from this collection of community knowledge and add your expertise.

Where to find sources for ODBC drivers for Oracle on UNIX

by SAS Employee KatT_sas on ‎03-11-2016 09:17 AM - edited on ‎03-11-2016 09:33 AM by Community Manager (362 Views)

Overview

This article is part of a series.  See Using SAS/ACCESS Interface to ODBC on UNIX Platforms for a listing of all articles in this series.

 

ODBC Driver Manager

To use SAS/ACCESS Interface to ODBC on UNIX platforms to read from and write to Oracle, you must independently obtain an ODBC driver manager and an ODBC driver for Oracle.

 

Progress DataDirect is an ODBC driver vendor that can provide—and is considered to be the gold standard for—the needed ODBC client components for UNIX platforms. Through DataDirect, you can license an ODBC driver and also an ODBC driver manager for various ODBC data sources, including Oracle. DataDirect drivers are sound, easy to implement and maintain, and well-supported.

 

For a relatively nominal fee, you can also license an ODBC driver manager and an ODBC driver for Oracle for UNIX platforms from Easysoft or OpenLink.

 

You can also use an ODBC driver from Oracle.  If you use an Oracle ODBC driver, you must also obtain a unixODBC driver manager.  Download a zipped tar file (unixODBC-x.x.x.tar.gz) for unixODBC from the unixODBC project home page.  (x.x.x refers to the most recent subrelease.)

 

You can implement this solution without incurring any additional licensing fees. Be aware, however, that there is a known Oracle ODBC driver bug in releases prior to Oracle 11.2, so you might want to avoid using older versions of the Oracle ODBC driver.

Contributors
Your turn
Sign In!

Want to write an article? Sign in with your profile.


Looking for the Ask the Expert series? Find it in its new home: communities.sas.com/askexpert.