12-10-2012 03:51 PM
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!
12-10-2012 07:34 PM
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.
12-10-2012 08:09 PM
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!
12-10-2012 10:31 PM
No problem. Also here's a very useful document for Management Console newbies and setting up data libraries in metadata:
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:
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.
12-11-2012 04:52 PM
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.
Need further help from the community? Please ask a new question.