topic How do I configure Oracle database connection to SAS in Linux? in Administration and Deployment

How do I configure Oracle database connection to SAS in Linux?

WorkingMan — Mon, 20 Apr 2020 10:13:11 GMT

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?

Re: How do I configure Oracle database connection to SAS in Linux?

Kurt_Bremser — Mon, 20 Apr 2020 10:42:08 GMT

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

Re: How do I configure Oracle database connection to SAS in Linux?

Sajid01 — Wed, 22 Apr 2020 13:41:54 GMT

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.