Difference ODI on MP vs OCI - DI

Vivek_Gautam

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

Sumanth V -Oracle

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

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

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

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

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

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

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

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