topic ORACLE CONNECTION ENABLE IN SAS EG in SAS Enterprise Guide

ORACLE CONNECTION ENABLE IN SAS EG

BrahmanandaRao — Thu, 12 May 2022 12:42:55 GMT

proc sql;
connect to oracle (user=myusr1 password=mypwd1);
select *
   from connection to oracle
     (select *       from  table
      
    disconnect from oracle;
quit;

How to enable oracle engine in and connect in SAS EG IN SAS ON DEMAND

Re: ORACLE CONNECTION ENABLE IN SAS EG

Kurt_Bremser — Thu, 12 May 2022 14:18:42 GMT

On Demand does not provide SAS/ACCESS to Oracle.

PS: you determine this by running PROC SETINIT.

Re: ORACLE CONNECTION ENABLE IN SAS EG

BrahmanandaRao — Fri, 13 May 2022 09:27:25 GMT

which database can we connect Mysql can enable in SAS EG in SAS ondemand

Re: ORACLE CONNECTION ENABLE IN SAS EG

Patrick — Fri, 13 May 2022 09:46:31 GMT

proc setinit; run; will tell you what's licensed

proc product_status; run will tell you what's installed.

If SAS/Access to ODBC is installed then you should "theoretically" be able to connect to Oracle once you've done all the configuration work. But not sure what sort of connectivity the SAS On Demand version allows.

Re: ORACLE CONNECTION ENABLE IN SAS EG

Kurt_Bremser — Fri, 13 May 2022 11:10:02 GMT

And if a suitable module is found, the documentation will tell you how to use it. Oracle, MySQL and a slew of others fall under "Relational Databases".

Mind that connecting to databases is way beyond trivial; it takes thorough knowledge of the DB in question and the necessary SAS parts. On top of that, a client for the DB in question must be installed and configured on the SAS server.