SAS VA connectivity to Oracle 10g

[Rahul_SAS]

Hi Experts,

I have to establish a connection SAS Visual Analytic to Oracle 10g in linux environment so could anybody guid me how do i do that. If any relevant document please provide.

Regards

Rahul 

[SASKiwi]

SAS VA uses the same SAS software to connect to Oracle as other SAS components. That means you would need to have installed and licensed SAS/ACCESS to Oracle or SAS/ACCESS to ODBC.

Run the following code to confirm what SAS products you are licensed for: proc setinit noalias; run;

Please advise which of these products you have. If you have neither then you will not be able to connect to Oracle.

This link may be helpful: http://support.sas.com/documentation/installcenter/en/ikfdtnlaxsr/66396/PDF/default/sreq.pdf

[Rahul_SAS]

hi SASKiwi,

what is the difference between SAS/ACCESS to Oracle or SAS/ACCESS to ODBC. If I have SAS/ACCESS to ODBC so what is the complete process with command which is usefule in linux.

[SASKiwi]

SAS/ACCESS to ODBC gives you the flexibility to use it for other databases apart from Oracle without getting another SAS/ACCESS product.

I'm not sure what you mean by "complete process with command".

If you want to know how to install or configure SAS/ACCESS to ODBC then here is a starting point for post-install steps: https://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

You can search further in the install documentation for the rest of the process.

If you want to know how to use SAS with Oracle then it is the same for all operating systems. Search on the SAS support site for SAS 9.4 ODBC documention. You can use both SQL, SAS DATA steps and procedures on Oracle via ODBC.

[Community_Help]

Hi, I am moving your question to our SAS Visual Analytics Community so that your question will have visibility to other VA users who go there. Thanks!

cc to Community Manager

[FriedEgg]

,

Here is a link to a relavent page in the VA User's Guide:

http://support.sas.com/documentation/cdl/en/vaug/66720/HTML/default/viewer.htm#p1ee44qnbsxa2on11zu9j...

It also briefly describes the assumptions made to opening the connection to Oracle, which I will reiterate as:

1. The server has access the Oracle client installed

2. The server is licensed with SAS/ACCESS Interface to Oracle

For help with installation you should reference the guide for your specific OS to make sure the SAS/ACCESS interface is properly installed and configured.