ORACLE CONNECTION ENABLE IN SAS EG

[BrahmanandaRao]

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 

[Kurt_Bremser]

On Demand does not provide SAS/ACCESS to Oracle.

PS: you determine this by running PROC SETINIT.

[BrahmanandaRao]

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

[Patrick]

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.

[Kurt_Bremser]

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.