Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

data lineage for custom OBIA 7964

Received Response
33
Views
5
Comments
User538247
User538247 Rank 4 - Community Specialist
in Oracle Business Intelligence Applications

Hi,

How to generate data lineage document for custom mappings & extension in OBIA 7964?

thanks in advance,

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    basically you have to export/report all of your ETL, DW schema, RPD and Web catalog.  Optionally, you could load these into a database set of tables and build an OBIEE model on it.  The upgraded versions of OBIA 11g have the ODI ETL built in and it has the scenarios to also read in the exported RPD and webcat details.  If you are going to expend the effort ... do it on the whole -- hopefully you followed the Oracle recommended way to customize and extend - if so these are easy to pick out from the larger set.

  • User538247
    User538247 Rank 4 - Community Specialist

    Its OBIA 7964 with customisation , how to export ETL to excel? we do not have metadata manager plugin to export infa mapping data lineage... any other way to export data lineage to excel.

    currently just need ETL data lineage...RPD & web catalog is not required.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    How to export workflows and mappings in informatica through unix shell script? - Toolbox for IT Groups

  • User538247
    User538247 Rank 4 - Community Specialist

    this process exports in xml & i want output in excel

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    you can import XML data into excel ...