Accessing Physical Tables in OAC for Advanced SQL Use Cases

Question

Hi all,

I've successfully established a connection from OAC to Oracle Applications and can access the logical tables (Subject Areas) from the Fusion Cloud environment. However, I would also like to work with the physical tables to meet more complex requirements using SQL.

Is this possible, or is there a recommended workaround for accessing the underlying physical data structures?

Best regards,

Loboo

Loboo55 · Answer

Following our review, we have identified that FDI is also in use within our environment.

Could you please share any best practice documentation or guidance on how FDI has been successfully implemented in similar use cases?

We’re particularly interested in approaches that have proven effective and could support a successful deployment for our specific scenario.

Thank you in advance!

Gianni Ceresa · Answer

If you mean the "Data Replication" option Gayathri mentioned, it is this:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/overview-data-replication.html

It doesn't give you access to physical tables, it doesn't replicate physical tables, it does export PVOs to ADW, and from there you can do whatever you want with those database tables.

The details about the PVOs (what means what, what is where etc.) are part of Fusion, it isn't really an analytics feature. That topic is covered in the parallel forum Cloud Customer Connect:

https://community.oracle.com/customerconnect

Loboo55 · Answer

Thank you for the information, is there a guidline how i can replicate physical tables to the Oracle ADW?