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
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
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?
Vivek Gautam
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.
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
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?
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.
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…
What kind of non-fusion data you are trying to bring it? does it involve lot of transformations or simple one to one mapping.
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
