topic Re: Creating Oracle library in SAS 9.3 in SAS Data Management

Creating Oracle library in SAS 9.3

MG18 — Mon, 20 Nov 2017 13:12:27 GMT

Hi All,

I am trying to create an oracle library using SAS/ACCESS and i am able to create it and libname is shown below :-

LIBNAME FIN_PROD ORACLE PATH="172.21.00.40:1521/******" SCHEMA=T****M AUTHDOMAIN="F**_PROD_AUTH" ;

which is running fine also. but sometime Our client wanted to do extraction from DR server having ip address 172.31.00.40 and other details are same only ip is different. we are having 50/60 job in which we have this libaname and every time we are changing this libname and redeploying those jobs which is very hectic task 😛 .

is there any other different way to create library in SAS where we can store this ip and can be changed whenever we want?

what are the different type of creating SAS library For oracle engine ? what is the workout for above problem ?

Please provide some other link from where i can get this information.

Many many thanks in Advance.

Re: Creating Oracle library in SAS 9.3

Kurt_Bremser — Mon, 20 Nov 2017 13:33:21 GMT

Use a macro variable:

%let oraclehost=172.21.00.40;

libname fin_prod oracle path="&oraclehost.:1521/******" schema=T****M  authdomain="F**_PROD_AUTH" ;

If you use &oraclehost in all your libname or connect statements, you only need to set it once (eg in autoexec.sas) and maintain it there.

Re: Creating Oracle library in SAS 9.3

SASKiwi — Mon, 20 Nov 2017 19:25:43 GMT

In my experience it is unusual to specify server IP addresses in a library definition. We use server aliases for all of our library definitions so our code doesn't change when switching between Production and DR. The actual IP switching is done by IT Admin. Not sure if this approach would suit you or not though.