topic Re: How to register library for Oracle synonyms in MC? in Administration and Deployment

How to register library for Oracle synonyms in MC?

Haikuo — Mon, 10 Dec 2012 20:51:50 GMT

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

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

Haikuo — Mon, 10 Dec 2012 21:03:20 GMT

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

Haikuo

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

SASKiwi — Tue, 11 Dec 2012 00:34:59 GMT

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.

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

Haikuo — Tue, 11 Dec 2012 01:09:08 GMT

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

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

SASKiwi — Tue, 11 Dec 2012 03:31:10 GMT

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.

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

Haikuo — Tue, 11 Dec 2012 03:43:04 GMT

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

Haikuo

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

FriedEgg — Tue, 11 Dec 2012 21:52:35 GMT

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.