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 AI and Analytics

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 ?

Top Leaders

mgoswami 45

Govardhana Gurumal 34

Bhavin Desai 17

Victor H 16

Andrew at MKL 2

Top Ideas

Enhancement Request: Data Role and Security Lineage in FDI Query Execution
Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager, Regional Manager, Country, Area of Responsibility (AOR), Organization, and other business-specific access rules. One of the…
Enhancement Request: Data Role and Security Lineage in FDI Query Execution
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager,…
Enable Public Access to Reports and Dashboards in Oracle Fusion Data Intelligence (FDI)
Idea / Enhancement Request Oracle Analytics Cloud (OAC) has introduced the capability to provide public access to analytics content using the BI Public Role, allowing reports and dashboards to be shared with users without requiring authentication. I would like to propose extending similar functionality to Oracle Fusion…
DATA PIPELINES CAPABILITY FOR NON FUSION SOURCES IN ORACLE FUSION DATA INTELIGENCE
hi All, The existing FDI pre-built artifacts/Common Subject Areas give us useful information about data reload and warehouse refresh activities. However, I see a gap when troubleshooting Data Augmentation execution at row level. For example, we have a BI Publisher report returning approximately 1M rows, but the…
Enable the Option to Hide Fusion SCM Content in FDI Reporting Configuration
In Fusion Data Intelligence (FDI) release 26.R3.P4, Reporting Configuration provides options to hide Human Capital Management (HCM) and Enterprise Resource Planning (ERP) content. However, an equivalent option is not available for Fusion Supply Chain Management (SCM) content. SCM content remains visible in the catalog…