Architecting, installing and maintaining your SAS environment

How to register library for Oracle synonyms in MC?

Accepted Solution Solved
Reply
Respected Advisor
Posts: 3,124
Accepted Solution

How to register library for Oracle synonyms in MC?

Dear colleagues and friends,

Newbie to Management Console.

I am aware that in Base, the following will work:

libname ora oracle user=user--name password=password path=path-name db_objects=all;

However, I couldn't get it to work using Management Console. I have not been provided with such an option nor could  I override or edit the automatically generated libname statement manually. 

Thanks for help!

Haikuo


Accepted Solutions
Solution
‎12-10-2012 04:03 PM
Respected Advisor
Posts: 3,124

Re: How to register library for Oracle synonyms in MC?

There is actually an option about synonyms in registering tables, not libraries. This eventually a non-issue. 

Haikuo

View solution in original post


All Replies
Solution
‎12-10-2012 04:03 PM
Respected Advisor
Posts: 3,124

Re: How to register library for Oracle synonyms in MC?

There is actually an option about synonyms in registering tables, not libraries. This eventually a non-issue. 

Haikuo

Super User
Posts: 3,110

Re: How to register library for Oracle synonyms in MC?

Actually there is a way of adding LIBNAME options like db_objects in Management Console. You first tick the Library is pre-assigned option in the library Options tab, you can then assign extra LIBNAME options under the Other Options tab. One option we have found very useful is DEFER = YES. We use this on all external database libraries set up in MC so that connecting to the SAS server is not slowed down by having to create lots of database connections at start up. The database connections are only activated when they are selected or referenced in code.

Respected Advisor
Posts: 3,124

Re: How to register library for Oracle synonyms in MC?

This information is indeed very helpful. right now we are instructed to use pre-assigned option for SAS tables only, that is why I didn't even look; and being annoyed by slow starting up,  I will definitely try DEFER=YES option. Just being switched to SAS admin role, I am desperately needing all the help I can get, and I can hardly wait my fast-track training on Jan 14.

Thank you very much!

Haikuo

Super User
Posts: 3,110

Re: How to register library for Oracle synonyms in MC?

No problem. Also here's a very useful document for Management Console newbies and setting up data libraries in metadata:

http://support.sas.com/documentation/onlinedoc/guide/EG43MetaLibraries.pdf

One of best tips we found from this document was the setting of AssignMode = 2 on MC data library attributes to show ALL SAS and external database tables by default in the EG server list without having to register them in metadata first.

You might also want to check out this reference for best practices in metadata security as this has implications for data libraries as well:

http://support.sas.com/resources/papers/proceedings11/376-2011.pdf

I rate both these papers as among the most useful in distilling what you need to know when setting up metadata in a BI Server installation.

Respected Advisor
Posts: 3,124

Re: How to register library for Oracle synonyms in MC?

Awesome! Now you got me some lullaby papers to read  before falling asleep Smiley Happy

Haikuo

Trusted Advisor
Posts: 1,300

Re: How to register library for Oracle synonyms in MC?

I used to use the show_synonyms=yes option for this, however, as you stated the db_object option is the new way to request this information and gives additional control over which objects you will see.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 1614 views
  • 6 likes
  • 3 in conversation