We are having the problem in seeing the libraries of the Oracle database.
Earlier it used to work, now we are unable to see the libraries of Oracle in the SAS EG under:
Servers pane ----> SASApp ---> Libraries
Able to see the Oracle libraries and tables in the SMC, but not in SAS EG.
Can anyone help me on this.
Thanks & Regards,
Alternatively, if your Oracle libraries are not preassigned, there is a setting in later versions of EG which causes unassigned libraries not to be visible. Compare these two screenshots (EG 8.3):
You'll see that the bracketed libraries (unassigned) are greyed out in the second one. The circled button toggles whether unassigned libraries are visible. This may not be the cause in your case but it's something which has caught out a few of my users.
Another way to troubleshoot this is to create an Oracle LIBNAME statement with exactly the same settings as in your metadata library definition. If the LIBNAME works then there is nothing wrong with the Oracle connection settings and the problem is with the metadata permissions.
Also, I always define this metadata library option in external database connections to ensure tables show in EG without having to register them:
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
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.