Perform these tasks for initial and ongoing loading and refreshing of data lineage dashboards and their required metadata.
Note:
You must perform the tasks in this section in the sequence described in Setting Up Data Lineage.Extract Presentation Catalog (webcat) and repository metadata into files sourced during load of the Data Lineage warehouse tables.
Prerequisites:
Oracle BI EE 11.1.1.6.0 and 11.1.1.7.0 client installations on a Windows machine are a prerequisite to extract Oracle BI EE metadata.
You use Windows-based Oracle BI EE clients from release 11.1.1.6.0 or 11.1.1.7.0 to generate the following files:
WebCat_dashboard_text.txt
WebCat_ text.txt
rpd_text.txt
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.
WebCat_dashboard_text.txt
, WebCat_ text.txt
, and rpd_text.txt f
rom the local directory on the Windows machine to $DL_HOME
.$ORACLE_BI_HOME/biapps/DataLineage
to $DL_HOME
.Execute the Data Lineage Extract and Load load plan in ODI. This load plan uses the sources and extracted metadata files you have configured and generated as sources to load and refresh the prebuilt data lineage warehouse tables.