12c Web Services to extract Catalog information

brilliant

Hi,

Been trying to research the documentation on how I can retrieve all the Dashboards, Sub Pages, Objects and access privileges using Web Services. I know it is possible using the tool, but looking for a Web Services option.

Would this be the WebCatalog? MetadataCatalog? Or API?

If I don't know the Subject Area names nor do I know what's in the catalog and want to extract for the entire Web Catalog given an administrator's user and password, how can this be done?

Thanks,

[Deleted User]

1.) There are two entities: Web Catalog and Repository. First contains the objects (dashboards, analyses,...) the second all the metadata (data models).

2.) There is no such thing as a "metadatacatalog"

3.) For accessing the web catalog you either use the runcat command line or the web services: https://docs.oracle.com/middleware/12213/biee/BIEIT/index.html

brilliant

How do I access the Repository?

I am new to OBIEE, looking for some pointers

Gianni Ceresa

You asked for the catalog and the list of things you look for is catalog, therefore stick to it and forget the repository.

If you don't know how to access the repository and don't ask for anything coming from there, no need to look into the repository (or you will never do any work as you will spend the next months learning any possible detail of the tool).

All you need is the WebCatalogService ( https://docs.oracle.com/middleware/12213/biee/BIEIT/methods.htm#BIEIT286  ), you can recursively loop over the object of the catalog starting from the root of the shared folder (you can't access home folders of users, that would require runcat.sh in offline mode) and there you get all the objects. They have various properties which tell you the kind of object, ACL etc. Everything is in the doc.

[Deleted User]

Gianni beat me to it. Start with the documentation that both of us posted.

And if you are new to OBI, then you should get some good training as soon as possible. The tool is way too powerful and complex to be comprehended and understood "just like that". No question in an online forum can ever replace training.

brilliant

thanks both!

until next time

[Deleted User]

Can you please close the thread? It will help other users and is considered good etiquette.

brilliant

Have a new issue here. I am calling the SecurityService Web Service and I am able to get the SessionID but when I call the securityService, I get Authentication Error, Invalid session id.

The Oracle Support points to firewall issues, but port 9502 is open already. I communicate over 9502 to get webcatalog data successsfully.

Is there something i am missing?

https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2176644_1.html