BookmarkSubscribeRSS Feed
MariaD
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?

 

Regards,

2 REPLIES 2
SASKiwi
PROC Star

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

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1306 views
  • 0 likes
  • 3 in conversation