nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

User interface to upload data to FAW

Avishek3D

We have a current state where manual files can be submitted.

We are looking to implement FAW and move a few of reporting cubes to FAW. Does FAW allow any functionality or an user interface where users can submit/ upload data directly into FAW?

Find more posts tagged with

Delivered

Status: Delivered

Comments

Krishna Prasad Kotti-Oracle

Please review Connectors in FAW which can be used to load data from files in to FAW ADW Tables.

Below are some blogs and documentation links.

https://docs.oracle.com/en/cloud/saas/analytics/23r3/fawag/oracle-fusion-analytics-warehouse.html#GUID-A94F24B7-5BE8-4210-B05F-92D184751FE5

https://blogs.oracle.com/analytics/post/configure-secure-file-transfer-protocol-connector-in-fusion-analytics

https://blogs.oracle.com/analytics/post/loading-data-from-oss-into-oracle-fusion-analytics

Avishek3D

Thanks a lot Krishna. For the Oracle Object Storage, does it come entitled with FAW subscription, or we need to register/ procure a different subscription from Oracle?

Krishna Prasad Kotti-Oracle

Oracle Object Storage is part of OCI. It does not come with FAW Subscription.

It comes as part of your OCI Cloud Account setup (either pay as go or UCC)

https://www.oracle.com/cloud/universal-credits/

Avishek3D

Thanks much Krishna. 1 additional question I have on this is - is there any feature or interface through which files can be added to OAC semantic/ reporting layer?

Krishna Prasad Kotti-Oracle

You can review OAC Data Sets and Data Flows, depending on your usecase, it will best if you review the connectors.

Avishek3D

Thanks again Krishna for this.

Wanted to check on something on a side note -

Are the integrations with ADW in FAW for custom sources done through REST APIs?

Krishna Prasad Kotti-Oracle

FAW is a SaaS Service. Custom data can be brought into FAW using FAW Connectors.

Avishek3D

Is there any documentation available on the approach to connect ADW using a custom etl tool?

Avishek3D

Hi Krishna, hope you are well.

I wanted to check on this please -

After reviewing some of these options, regarding usage of OAC data sets - does the data get loaded to ADW after user submits in OAC? or its more just at the OAC/ semantics layer ?