Extracting Oracle Business Intelligence Metadata Using Catalog Manager and Administration Tool

In this step, you extract Presentation Catalog (webcat) and repository (RPD) metadata into files sourced during load of the Data Lineage warehouse tables. You use Windows-based OBIEE clients from versions 11.1.1.6.0 and 11.1.1.7.0 to generate the following files:

• webCat_dashboard_text.txt
• webCat_ text.txt
• rpd_text.txt

Prerequisites

OBIEE 11.1.1.6.0 and 11.1.1.7.0 client installations on a Windows machine are a prerequisite to extract OBIEE metadata.

Extract Dashboard Metadata

1. Open Oracle Business Intelligence Catalog Manager 11.1.1.6.0 and connect using a connection type of online to the Oracle Business Intelligence Server, URL: http://<Host:port>/analytics/saw.dll.
2. Select Tools > Create Report.

3. In the Create Catalog Report dialog box, select Dashboard in the Select type to report on drop-down list.
4. In the Available Columns list, select the following columns and arrange them in order:
• Owner
• Folder
• Name
• Path
• Dashboard Page Name
• Dashboard Page Path
• Dashboard Style
• Analysis Name
• Analysis Path

Note:

The column order must be as above.

5. Click OK. It will take few minutes to generate the report. Click OK if an Error window pops up after few minutes.
6. Save the file as webCat_dashboard_text.txt in a local folder.

Extract Report Metadata

1. Select Tools > Create Report.
2. In the Create Catalog Report dialog box, select Analysis in the Select type to report on drop-down list.
3. In the Available Columns list, select the following columns and arrange them in order:
• Owner
• Folder
• Name
• Subject Area
• Table
• Column

Note:

The column order must be as above.

4. Click OK.
5. Save the file as webCat_text.txt in a local folder.

Extract RPD Metadata

1. Open the BI Applications RPD using the 11.1.1.7.0 version of Oracle BI Administration Tool.
2. Select Tools > Utilities.
3. In the Utilities dialog box, select Repository Documentation and click Execute.

4. In the Save As dialog box, save the file as rpd_text.txt. Select Tab Separated Values (*.txt) in the Save as Type drop-down list.

Copy to the $DL_HOME directory

In this step, you copy the metadata source files from the local directory on the Windows machine you saved them on to the Data Lineage home directory, where they can be sourced by the Data Lineage Extract and Load load plan. You also copy a Fusion EAR file from its installation location to the Data Lineage home directory.

1. Copy the webCat_dashboard_text.txt, webCat_ text.txt, and rpd_text.txt from the local directory on the Windows machine to $DL_HOME.
2. Copy Fusion EAR files from $ORACLE_BI_HOME/biapps/DataLineage to $DL_HOME.