How to Start Oracle Warehouse Builder Repository Browser

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.

startOWBB1

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:

   https://owb_server:8999/owbb/RABLogin.uix?mode=design

  or

  https://owb_server:8999/owbb/RABLogin.uix?mode=runtime

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.

login 

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:

Option1:

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.

Option2:

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.

The MDL file used to set up the environment: owbb_proj.mdl

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.

 

design1

Figure 3 Home Page of Design Center

des2

Figure 4 Expanded Tree of a Workspace

des3

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.

exec1

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.

clip_image014

Figure 7 Deployment Schedule Report 1

clip_image016

Figure 8 Deployment Schedule Report 2

clip_image018

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.

clip_image020

Figure 10 Execution Summary Report

clip_image022

Figure 11 Execution Report of T2T_MAPPING

clip_image024

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.

Comments:

Found bug: http://st-curriculum.oracle.com/obe/db/11g/r1/owb/owb11g_update_getting_started_intro/lesson1/less1_start.htm + 1. Download the owbdemo_files.zip file by right-clicking here and selecting Save Target As from the pop-up menu. Direct the download to any directory on your computer's hard drive. and OMBCC '/$project/$module' puts "Loading ROLAP Cube" source $sourcedir/Sequences.tcl source $sourcedir/dim_times.tcl source $sourcedir/dim_channels.tcl source $sourcedir/dim_products.tcl source $sourcedir/dim_promotions.tcl source $sourcedir/dim_customers.tcl source $sourcedir/cube_sales.tcl I guess somebody made mistake .. it's crashing under unix, there is only "sequences.tcl" file in archive ;) Anyway.. I found few more bugs in OWB. Can sb explain me why there are so many problems with refreshing of GUI window handlers in OWB? I'm forced to kill IDE 20 times a day.

Posted by Rafal on October 13, 2010 at 02:19 AM PDT #

Hi,
I want to know in one instance in oracle,how many repository can be make?If it is more than one repository,how we can make it?

Regards,
Sahar

Posted by guest on November 27, 2011 at 10:15 PM PST #

Hi Sahar

You can use the OWB Repository Assistant to create multiple workspaces, each is essentially its own repository. The repository implementation tables are stored in one schema and striped by the workspace.

Cheers
David

Posted by David on November 28, 2011 at 02:54 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today