topic Re: Viya Caslib using Tnsnames in Administration and Deployment

Viya Caslib using Tnsnames

bbernade0 — Tue, 22 Sep 2020 04:12:13 GMT

I am trying to find if anyone has created a viya caslib using a tnsname entry instead of the full path to the database. If possible, this will help switching server and keep the same Caslib instead of recreating a new one.

Thank you

Re: Viya Caslib using Tnsnames

AnandVyas — Tue, 22 Sep 2020 05:55:32 GMT

Can you try the example provided in this link: https://documentation.sas.com/?docsetId=casref&docsetTarget=n0s9iuu3d4cxjzn1st0z33ik35if.htm&docsetVersion=3.5&locale=en#p16mu1n10ys6ksn1xjegisphikhj

caslib oralib 
   datasource=(srctype='oracle', 
               username='myuser1', 
               password='myPwd', 
               path="myORAdata");