Using SAS/ACCESS Interface to ODBC on UNIX Platforms

[#1]

SAS Technical Support and Publications will post a series of articles about using SAS/ACCESS Interface to ODBC on UNIX platforms. From these, you can learn about specific platforms and how they interact with various ODBC drivers and driver managers. 

About This Series

No matter what specific interfaces or platforms you want to work with, start with the overview article, followed by a platform-specific build article.  You can then continue with other articles based on what you want to accomplish. Here's a list of articles:

Overview

How to configure SAS/ACCESS Interface to ODBC on UNIX Platforms

Build the Latest unixODBC Driver Manager

How to build the latest unixODBC Driver Manager for Linux

How to build the latest unixODBC Driver Manager for AIX

How to build the latest unixODBC driver manager for Solaris

Drivers and Driver Managers

Where to find sources for ODBC drivers for Oracle on UNIX

Configure Various Interfaces

How to configure SAS/ACCESS Interface to ODBC on Linux with an ODBC driver from Oracle

How to configure SAS/ACCESS Interface to ODBC on Linux with a Sybase IQ ODBC driver from Sybase

[SASKiwi]

Nice series, but can you get all of the hyperlinks working?

[AnnaBrown]

Hi SASKiwi,

Glad you like the series! The links will be available as the articles publish over the next several days.

Best,

Anna

[SASKiwi]

OK. I think the best thing about this article is gathering all of the setup information in one place.

[AnnaBrown]

Great point SASKiwi. All the articles have now posted and you'll find updated links in this initial article. Thanks for reading!

[PascalMaurice]

Hi there,

we find this advice:

• A Linux startup script is used to set the needed Oracle and ODBC environment variables. Normally, the best place to set these in the SASENV_LOCAL file in the !SASROOT/bin directory because it ensures that they are set for whoever starts SAS, no matter how it is started.

perhaps the SASENV_LOCAL could not be considered as the best place: now we have the Lev1... directory tree with all the files to be used to tune the SAS platform, doing so we are sure that all the specific tuning and parameters is done in this directory tree and not on files spreaded across Lev1 and sashome.

for example Lev1/level_env_usermods.sh could be a best place ?

[KatT_sas]

Your point is well taken, PascalMaurice, & you can certainly do that.  One assumption we made for these articles was to be sure that all SAS/ACCESS products working with ODBC on UNIX platforms can be used in the same SAS session.