This example accesses
an Oracle database by connecting to the DataFlux Federation Server
and by submitting a fully-specified connection string.
-
The LIBNAME statement
assigns the libref Myfiles and specifies the FEDSVR engine and Dataflux
Federation Server server connection arguments.
-
The DRIVER=FEDSQL option
specifies the language driver, which is required for an Oracle database
when using the LIBNAME engine.
-
The CONOPTS= option
specifies the connection string arguments for an Oracle database server.
-
The PRINT procedure
prints an Oracle table.
libname myfiles fedsvr server=a123.us.company.com
port=2171 user="sasadm@saspw" pwd=lpwd 1
connect_string="driver=fedsql; 2
conopts=(driver=oracle; uid=oracleid; pwd=oraclepw;
path=or9010; catalog=cat_oracle;)"; 3
proc print data=myfiles.table1; 4
run;