Data Lineage :Setting Up Data Lineage

Overview

When you set up data lineage, prebuilt data lineage warehouse tables in the OBAW are populated by an ETL package which loads lineage metadata from five sources:

1. Oracle BI Applications Configuration Manager
2. Oracle Data Integrator (ODI) Work Repository
3. Oracle BI Presentation Catalog
4.   Oracle BI metadata repository file (RPD)
5. Oracle Fusion OLTP tables

One-time preliminary setup steps include preparing metadata from and access to these sources for load of data lineage information into the prebuilt data lineage warehouse tables. Metadata and data refresh can then be performed on an ongoing basis.

List of Steps for Setting Up Data Lineage

To install and set up data lineage dashboards, you must complete the following tasks, in order. Each high-level task breaks down into a list of detailed steps.

1. Configure the environment to support data lineage,
2. Configure the WebLogic Server heap size,
3. Optionally, disable the Fusion step if you are using other BI Applications sources,
4. Create data lineage warehouse tables
5. Extract metadata using Windows OBIEE clients
6. Execute the data lineage load plan in ODI to load the data lineage warehouse tables,