How to Start Oracle Warehouse Builder Repository Browser
By Dong Ruirong on Jan 05, 2010
The Repository Browser is a browser-based tool that generates reports from data stored in Oracle Warehouse Builder (OWB) repositories. When you install Warehouse Builder from Oracle Universal Installer, the Repository Browser is also installed and runs in all the languages that you selected during installation.
The Repository Browser connects to Warehouse Builder repositories and enables you to view metadata, run Web reports, perform lineage and impact analysis on your metadata, and audit runtime executions. Using the Repository Browser, you can view:
- Detailed information about the design of a workspace. Reports are generated from data stored in the workspaces.
- Reports that provide access to both high-level and detailed ETL runtime information. This information includes the following:
- Timings for each mapping and process flow
- Details of activities for each process flow
- Error details
- Deployment information to manage separate target environments
How to Start Repository Browser?
1. Start the Repository Browser Listener
Before you can open the Repository Browser, you must start the Repository Browser Listener.
Starting the Repository Browser Listener in Windows
Open a command prompt window and run startOwbbInst.bat located in the OWB_ORACLE_HOME\owb\bin\win32 directory. You are prompted to set the password for the OC4J administrator. Enter a password and press the Enter key. When you are prompted to confirm the password, enter the same password again.
Starting the Repository Browser Listener in UNIX/LINUX
Run ./startOwbbInst.sh located in the OWB_ORACLE_HOME/owb/bin/unix directory. You are prompted to set the password for the OC4J administrator. Enter a password and press the Enter key. When you are prompted to confirm the password, enter the same password again.
Figure 1 is the screen-shot from Linux when starting the Repository Browser Listener. When you see that Oracle Containers for J2EE 10g (10.1.3.4.0) initialized, the Repository Browser Listener is started.
Figure 1 Starting the Repository Browser Listener
2. Access the Repository Browser
Once the Listener is running, you can start the Repository Browser in any one of the following ways:
- From the Start menu, select Programs, then the Warehouse Builder folder, and then Warehouse Builder, Repository Browser. This is for Windows only.
- From the Tools menu of the Design Center, select Repository Browser.
- From within any web browser, type the location of the Repository Connection page. For example, if the Repository Browser Listener is running on a computer named owb_server, then typing the following address will start the Repository Browser:
Regardless of which approach you take, once you start the Repository Browser, the browser opens the Repository Connection page from which you log in to the Repository Browser. Figure 2 is the screen-shot of the Repository Connection page.
Figure 2 Repository Connection Page
3. Login a Workspace
To login a workspace, specify the connection information for the workspace that you would like to access.
You can connect to the Control Center either as the workspace owner or as a workspace user. When you connect as the workspace owner, you can purge audit details, validate locations, unregister locations, change service node settings, view user data values, and start or stop execution jobs. When you connect as a workspace user with administrative privileges, you can also purge audit details, unregister locations, change service node settings, view user data values related to your execution jobs, and start or stop your execution jobs.
Once you log in to the Repository Browser, you can view any of the following reports: Deployment, Execution and Management. If you log in to a heterogeneous database or an OC4J server using a data store, you can only view Execution reports.
If you are going to connect to a repository based on Oracle database, please provide the following information in the login page before clicking the Login Button:
User Name: Provide the name of the workspace owner or workspace user used to connect to the workspace.
Password: Provide the password of the user specified in the User Name field.
Two options to connect to a repository based on an Oracle database, you should only choose one of the options:
Specify the host address, port number, and service name: Choose this option to connect to the workspace by providing the host name, port number, and service name of the Oracle Database that contains the workspace.
Select the net service name: Choose this option to connect to the workspace by providing the net service name associated with the Oracle Database that contains the Warehouse Builder repository.
According to what you need, you still need to choose one of the report options:
Design Center: Select Design Center to display the Repository Navigator that provides access to reports about object design.
Control Center: Select Control Center to display the Control Center Reports page that lists all the types of reports available through the Repository Browser.
In the following two sections, we will introduce what we can play around with after login a workspace with Design Center Option and Control Center Option. Before starting the exercise, you need to create a project: OWBB_PROJ, an oracle module: ORA_MOD, an oracle location: ORA_MOD_LOC, two tables: T_SRC and T_TGT and a mapping T2T_MAPING, add several columns to tables T_SRC and T_TGT and keep the column names of both tables the same, add table T_SRC and table T_TGT to the mapping T2T_MAPING and add mapping edges to connect columns of the table operators by column names, then deploy the tables and the mapping, and start the mapping. Simply, you can import the MDL file to set up the environment.
1) Login the Workspace with Design Center Option
After login or navigate to Design Center, you can expand the workspace to view the node-tree which displays all kind of objects created in the workspace, such as project, module, mapping, table etc. By clicking the nodes of the structure tree, you can drill down to all levels and all objects. You can display the reports, lineage and impact by click the report icon, lineage icon and impact icon. See Figure 3, Figure 4 and Figure 5.
Figure 3 Home Page of Design Center
Figure 4 Expanded Tree of a Workspace
Figure 5 Detailed Mapping Report of T2T_MAPPING
2) Login the Workspace with Control Center Option
If login a workspace with Control Center Option, the user is presented with the following report, which may be considered as the home page of the Repository Browser (Figure 6). The home page provides the links to access Deployment Schedule Report, Object Summary Report, Location Report, Execution Schedule Report, Execution Summary Report and Service Node Report and describes what the reports display. Here we will take Deployment Schedule Report and Execution Summary Report for example to show you how to use the reports and what kind of things they are.
Figure 6 Home Page of Control Center
Click the link Deployment Schedule Report to display details of all deployments in time order (Figure 7).
You have the following options on the page:
- Expand deployments to show run details
- Filter deployments on date range
- Calendar icon for date picker available to set start and end of date range
- Purge selected deployment audit details
- Refresh report to show up-to-date deployment details
- The option to purge audit details available only to user roles with sufficient privilege.
You can also make use of the links to access different pages, such as Object Summary Report, Locations Report, Execution Schedule Report, Execution Summary Report, and use the embedded links to access Process Deployment Report, Map Deployment Report, Data Object Deployment Report, etc. See Figure 8 and Figure 9.
Figure 7 Deployment Schedule Report 1
Figure 8 Deployment Schedule Report 2
Figure 9 Deployment Report
Click the link Execution Summary Report to list all Processes (and top-level Maps) with details of their latest execution run in type/name order (See Figure 10).
You have the following options on the page:
- Sort execution runs on name, type, latest execution time, execution status
- Filter Processes and Maps on type and execution status
You can also make use of the links to access different pages, for example, Deployment Schedule Report, Object Summary Report, Locations Report, Execution Schedule Report, and use the embedded link to access Process Execution Report or Map Execution Report. See Figure 11 and Figure 12.
Figure 10 Execution Summary Report
Figure 11 Execution Report of T2T_MAPPING
Figure 12 Execution Job Report of T2T_MAPPING
How to Stop Repository Browser?
Stopping the Repository Browser Listener in Windows
Open a command prompt window and run stopOwbbInst.bat located in the OWB_ORACLE_HOME\owb\bin\win32 directory. You are prompted to provide the OC4J administrator password that you set while starting the Repository Browser listener. Type the password and press the Enter key.
Stopping the Repository Browser Listener in UNIX/LINUX
Run ./stopOWBBInst.sh located in the OWB_ORACLE_HOME/owb/bin/unix directory. You are prompted to provide the OC4J administrator password that you set while starting the Repository Browser listener. Type the password and press the Enter key.