How to connect from ODI 12c to Oracle cloud Fusion Financials(FITC)

Tejaviswa394

Summary

How to connect from ODI 12c to Oracle cloud Fusion Financials(FITC)

Content

Hi ,

 

I am using ODI 12C and need to connect to Oracle cloud Fusion Financials database to get the tables and data . But , I am not finding any way to get that to connect . Can someone in this group help us . I am not sure if someone is using it . But if anyone knows please help .

Richard Williams-16119

You can't.

There's no way to connect directly to the Fusion cloud DB itself.

If you're looking to extract data - then look at the BI Cloud Connector.  This can be scheduled to create extracts, which ODI can then consume.

https://docs.oracle.com/en/cloud/saas/applications-common/r13-update17d/biacc/dialog-box-reference-orientation-topic.htm…

Tejaviswa394

If we load that into Oracle Universal Content Management (UCM) server . Would those be stored in Tables , Just as in FITC Cloud. Currently we extract data from OTBI and get the XML files out from those . But OTBI is not efficient enough to get the full data from the XML file . So we are having issue . If you can guide me more that could be really helpful.

user10503016

Hi Richard,

Is there any option or utility to load the BICC extract from UCM to a database ?

Or

ODI has any UCM direct adapter to transfer these files for loading into a DB?

Thanks