BookmarkSubscribeRSS Feed
WorkingMan
Calcite | Level 5

I just received a new Linux server and I would like to extract data from Oracle database. Currently, I haven't got the access to the linux server but assuming that it has SAS/Access component, what would be the steps for me to configure in order for me to extract data from Oracle database and used in SAS Data Integration studio?

 

What I can remember for a windows server without SAS/ACCESS component is to install oracle client. Then, configure tnsnames.ora file by putting oracle user and password. Next is to create a "server" in SAS Management Console and later create a group for storing this DB access. Lastly, configure in ODBC.

For Linux, will the steps be similar like below?
1. Install Oracle Client

2. Create a "server" in SMC (skip tnsnames.ora due to having SAS/ACCESS)

3. Create a group for storing this DB access

 

Hope I can get advice for this?

2 REPLIES 2
Kurt_Bremser
Super User

You will also need to configure the Oracle client, so it can reach the Oracle server from a commandline call.

 

I remember that I did have to create an "instance" when I used ACCESS to DB/2, so I guess you need to do something similar for Oracle.

 

See 

Establishing Connectivity to an Oracle Database 

SAS/ACCESS Interface to Oracle 

Sajid01
Meteorite | Level 14

Hello
This is my experience with setting up oracle on RHEL With SAS Access interface to ODBC.

(I had followed similar steps on SLES 11 )

Others may have different suggestions depending on their use cases.
Assuming you have installed SAS

1. Make sure that ODBC manager unixODBC is installed. Typically done by Unix/Linux Administrator.

2.Make sure that oracle client is installed. This is typically this is done by Oracle DBA. tnsname.ora etc are typically done by the ORACLE DBA's

3.Ensure that /etc/odbc.ini is configured. Oracle DBA provides the content. You may need the Linux admins help to edit this file. Typically SAS Admins cannot edit anything under /etc

4.Configure the sasenv_local file with LD_LIBRARY . ORACLE_HOME paths.

6.Make sure that access is allowed to the users from this server. Oracle DBA's do this.

7.Test connectivity from the Linux command line (sas -nodms). Once you are OK with this you can do the next steps.

 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1938 views
  • 0 likes
  • 3 in conversation