Oracle Fusion Data Intelligence

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

Difference ODI on MP vs OCI - DI

Received Response
145
Views
8
Comments
Vivek_Gautam
Vivek_Gautam Rank 4 - Community Specialist

Hi Team,


We are deciding which ETL tool to suggest to the client for implementing FDIP/FAW. Can someone explain the difference between recommending ODI on MP and OCI-DI?


Thanks & Regards,

VIvek Gautam

Tagged:

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    Hi @Vivek_Gautam09052022,

    FDI/FAW has their own pipelines and doesn't need an separate ETL Tool like ODI. Please refer the below document for more details on pipeline.

    https://docs.oracle.com/en/cloud/saas/analytics/23r4/fawag/data-pipelines-functional-areas.html#GUID-EF84ADFE-DAAA-4436-BAC7-6487B5A6A40C

  • Vivek_Gautam
    Vivek_Gautam Rank 4 - Community Specialist

    Hi @Sumanth V -Oracle,


    For non-fusion data and in some cases, fusion data for which we don't have seeded pipelines, we need to bring data in FAW/FDIP using an ETL tool.


    So wanted to understand when we should recommend ODI on MP and when OCI DI?


    Thanks & Regards,

    Vivek Gautam

  • User_5JGH5
    User_5JGH5 Rank 1 - Community Starter

    We were provided recommendations from our vendor partner and decided to go with OCI DI however we are experiencing a challenge using the template manifest file (we have raised SR). Our use case is to bring data from WMS into the ADW; the current FDIP WMS pipeline has some fixes needed (and it's not GA for some time), and this is our attempted workaround.

  • Debolina-Oracle
    Debolina-Oracle Rank 1 - Community Starter

    On the same discussion, Is there any kind of check list which will help to decide between ODI on MP and OCI DI ? Basically trying to understand major difference between ODI on MP and OCI DI

  • Ambient
    Ambient Rank 4 - Community Specialist

    I've always wanted a good place to ask this question…

    Would it be correct to say that:

    OAC's Data Preparation, FDIP/FAW Pipelines and EPM Cloud's Data Integration are all engines that are built on top of the core OCI DI engine?

  • Vivek_Gautam
    Vivek_Gautam Rank 4 - Community Specialist

    Hi @Ambient. My understanding is that Oracle relies on ODI as the core engine for its tools, such as FDI Pipelines and EPM Cloud Data Integrations.

    I'm not certain about OCI DI, but I personally believe that it also uses ODI as the underlying engine.

  • Ambient
    Ambient Rank 4 - Community Specialist
    edited June 2024

    Hi @Vivek_Gautam09052022,

    This is why I throw this question out there. ODI-MP is obviously the more mature, on-prem based solution, just hosted on OCI.

    It would be telling if you are correct and the internal product teams are still dependent on it…

  • Girish Ka-Oracle
    Girish Ka-Oracle Rank 2 - Community Beginner

    What kind of  non-fusion data you are trying to bring it? does it involve lot of transformations or simple one to one mapping.