BookmarkSubscribeRSS Feed
Barite | Level 11

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?



Opal | Level 21

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.  

SAS Employee

@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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 3 in conversation