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?
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.
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?
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/
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?
You can review OAC Data Sets and Data Flows, depending on your usecase, it will best if you review the connectors.
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?
FAW is a SaaS Service. Custom data can be brought into FAW using FAW Connectors.
Is there any documentation available on the approach to connect ADW using a custom etl tool?
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 ?
I have a use case for FDI connectors whereby I need to use the EPM Integrator to include planning data in my environment but I have 2 separate EPM environments, one for ERP and one for HCM. Once you create a connection using a connection type, the option to create a new one disappears. This creates an issue where customers…
In the out of the box workbooks, many have default filters for items such as Ledger and Business Unit. Most of these default to the first value alphabetically. This can be incredibly frustrating for users who, when logging in for the first time often get no results or results they are not expecting when they first log in.…
With continuous capabilities being brought into the modern Data Visualisation (DV) experience in OAC and FDI, a native equivalent to the View Selector from Classic Analysis / OBIEE is needed. In Classic reporting, the View Selector allowed users to dynamically swap between different chart types, tables, or analytical views…
OAC saved states are lost when the workbook is moved / migrated to another environment. This feature is intended mostly for personal user preferences but it is also useful for providing preset selecitons for users. If we want to make these presets available for all users , the only way is opening the workbook in the new…
Many organizations need to produce a single employee-level report that combines information from multiple Oracle Fusion Data Intelligence HCM subject areas, including: Workforce Core Goals and Career Development Performance Management Talent Profile Talent Profile Trends A common requirement is to extract, in a single…