SAS Access to Oracle Cloud Database

[MariaD]

Hi folks,

we have SAS 9.4 M6 installed on Linux Server. We have SAS access to Oracle and we connect with a large variety of Oracle databases without any problem. Now, we’re testing a Oracle cloud database. How is the procedure to connect to a Oracle database on cloud? We need to define it in tsnname.ora file?

Regards,

[SASKiwi]

If what you are talking about is simply a standard Oracle database (eg 11g, 12c, 18c etc) hosted on a cloud platform then I'd say connectivity should be exactly the same as on premise server hardware hosted database. Your Oracle administrator should be able to provide the connection details to update your tnsnames.ora configuration file.  

[alexal]

@MariaD ,

As @SASKiwi  said, there shouldn't be any difference with a regular Oracle database. Just get the connection info and define it in a tnsnames.ora file.