OWB - Repository Browser

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

Repository Browser is a J2EE web software interface that permit you to:

The application owbb.war is located in this directory Owb_Home\10203\owb\j2ee

Advertising

3 - How ?

3.1 - to grant it

To be able to connect to the Web repository Browser, you must have the ACCESS_PUBLICVIEW_BROWSER privileges.

Don't forget to save the repository. A click on the OK button is not enough.

3.2 - to start/stop it

You must first:

  • start the listener

The first time you invoke this listener, select and re-confirm a password for an oc4jadmin account. The next time, it would not be necessary.

owb_home\owb\bin\win32\startOwbbInst.bat start the OWB browser listener
owb_home\owb\bin\win32\stopOwbbInst.bat stop the OWB browser listener (password was given during the process start)
owb_home\owb\bin\win32\openDB.bat start the Web Repository Browser

You can launch them from the start menu.

Advertising

3.3 - to call/launch it

3.3.1 - from an URL

You can call it of through the short-cut menu or directly on this URL:

3.3.2 - from OWB

By default, OWB add to the URL the default value connections such as host, port and service with the help of this URL parameters:

def_host=owb.gerardnico.local&def_port=1521&def_service=orcl

but they are filled in with a NULL value if you have choose the TNS method during your connection to OWB as you can see in the session properties

3.3.2.1 - From the OWB Menu

3.3.2.2 - From a Mapping

You can call it from the contextual menu. Example with a table.

Advertising

4 - Port

It seems that the port is located in the file owb-home/j2ee/config/http-web-site.xml. See attribute: port

5 - Support

5.1 - Not a valid Warehouse Builder Control Center

When you try to connect, you can have this message: Not a valid Warehouse Builder Control Center. This is a standard message. To resolve it:

6 - Documentation / Reference