BookmarkSubscribeRSS Feed

Where to find sources for ODBC drivers for Oracle on UNIX

Started ‎03-11-2016 by
Modified ‎03-11-2016 by
Views 1,503

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.

Comments
Could you please give explain for teradata also. I need to connect teradata using odbc engine.
Version history
Last update:
‎03-11-2016 09:33 AM
Updated by:
Contributors

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Labels
Article Tags