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

OBIAPPS 7.9.6 ETL Customization (DAC/Informatica)

Received Response
1
Views
3
Comments
MC CU
MC CU Rank 2 - Community Beginner
in Oracle Business Intelligence Applications

Hi All,

I'm looking for some advice as to best practice around customizing a BI Apps ETL.  This is BI Apps 7.9.6, so the ETL is DAC and Informatica (no ODI).  We've been experiencing ETL failures and raised an SR with MOS.  As a fix, MOS have advised changing the SQL in an Infa Source Qualifier.  We want to create a folder in Informatica to hold customized workflows and the component objects, the idea being any patching/upgrade wont overwrite our customization's.  Having created the customized Informatica objects how do we update the DAC to use the new Informatica workflow?  MOS have not been able to answer this question, other than referring me to the documentation.  However the documentation does not cover how to customize the DAC or Informatica.

Any help or advice would be gratefully received

Thanks

Answers

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Hello There,

    BIAPPS document looks good starting point and while following suggested steps if you face any issue then you can seek help in community or MOS

    Below is the link and I guess same was shared with you before

    https://docs.oracle.com/cd/E35287_01/bia.7964/e35272/anyinstadmcustomizing.htm

    Document also clearly state at the begining as following:

    Customizing Oracle BI Applications is a multifaceted process. Before implementing customizations, you should have a thorough understanding of the following:

    • Oracle BI Applications
    • Oracle Business Analytics Warehouse
    • Your source systems
    • Informatica PowerCenter
    • Oracle Business Intelligence Data Warehouse Administration Console (DAC)
    • Oracle BI Foundation (BI Server metadata model, Administration Tool, Answers, and dashboards)

    Thanks,

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Once you have modified the workflow/mapping  in your custom folder in Informatica, you add them to DAC. How to do the latter is in the DAC documentation.

    Customizing ETL Processes - 11g Release 1 (11.1.1)

    pastedImage_1.png

  • MC CU
    MC CU Rank 2 - Community Beginner

    Thanks both, Also found the following doc, should anybody be interested chapter 8 has some information about customizing DAC

    Oracle® Business Intelligence Data Warehouse Administration Console User's Guide E12652-02