Introduction

Fusion Analytics Warehouse (FAW) is the latest innovation from Oracle analytics that provides Out-of-the-box pre-loaded KPIs, visualizations and reports for analyzing data in Oracle SaaS Applications such as Oracle ERP Cloud, Oracle HCM Cloud etc. Data is extracted from Oracle SaaS applications and loaded into ADW (Autonomous Data Warehouse), whereas OAC is used to customize existing dashboards and create new dashboards.

This service consists of a data pipeline, data warehouse, semantic model, and best-practice content such as prebuilt KPIs, dashboards, and reports. Oracle manages the service starting with deployment through performance monitoring, upgrades, and maintenance for the pre-built content.

Oracle Fusion Analytics Warehouse is available on Oracle Cloud Infrastructure. When you order Oracle Fusion Analytics Warehouse, you get access to included capacity for Oracle Autonomous Data Warehouse and Oracle Analytics Cloud Subscription. You must have an Oracle Cloud account with Universal Credits to provision Oracle Fusion Analytics Warehouse in one of the regions where the product is available.

Region Availability

Right now Oracle Fusion Analytics Warehouse is available in the following regions.

Region LocationRegion NameRegion Key
Ashburn, VAus-ashburn-1IAD
Dubai, UAEme-dubai-1DXB
Frankfurt, Germanyeu-frankfurt-1FRA
Jeddah, Saudi Arabiame-jeddah-1JED
London, United Kingdomuk-london-1LHR
Sao Paulo, Brazilsa-saopaulo-1GRU
Sydney, Australiaap-sydney-1SYD
Toronto, Canadaca-toronto-1YYZ

 

Prerequisites

  • If you want another user (Other than Admin) to provision FAW service, then add Administrator privilege to that user.
  • Identify your Oracle Applications Cloud instance from North America or EMEA location. Ex: https://xxxx-test.login.us6.oraclecloud.com
  • Reset FAWService user password under Oracle Applications Cloud. The FAWService user is a predefined user provisioned in Oracle Applications Cloud and is used by the data pipeline functionality in Oracle Fusion Analytics Warehouse. This user account has the appropriate data security privileges granted on the Oracle Applications Cloud view objects to bulk extract data from Oracle Applications Cloud into the data warehouse.

Creating Fusion Analytics Warehouse Instance

Sign in to the Oracle Cloud Infrastructure Console.

Oracle Cloud Infrastructure |Tangenz Corporation

Open the navigation menu. Under Analytics & AI, click Analytics, and then click Fusion Analytics Warehouse.

Fusion Analytics Warehouse | Tangenz Corporation

Select a compartment from List (Or) Create a custom compartment for FAW instance. If you create a custom compartment make sure you grant permission the compartment to create services in it.

Fusion Analytics Warehouse | Tangenz Corporation

Now click on “Create Instance” under instances page.

Analytics & AI | Tangenz Corporation

On the Instance creation page fill the following details.

  • Enter a display name for the service. (This name needn’t be unique and can contain alphanumeric and special characters.)
  • Enter a name for the instance. (This name should be unique in your tenancy. Also, this name can contain only alphanumeric characters without spaces.)
  • Enter a description for the service. (Optional)
  • Since this is your first instance, Select Development/Test as your Intended use.
  • If you are not doing it in a trial account, Enable Subscription configuration.

Fusion Analytics Warehouse | Tangenz Corporation

  • In Fusion Application Connection, provide the Oracle Applications Cloud URL (not the Login URL) and credentials of the default FAWService user from your Oracle Applications Cloud instance.

FAW Service |Tangenz Corporation

  • Click Test Connection to check the connection to the Oracle Applications Cloud instance and confirm whether the credentials are valid.

  • In Autonomous Data Warehouse Administrator Credentials, provide an administrator password for the Oracle Autonomous Data Warehouse that’s provisioned in your tenancy to store the transformed data.

Data Warehouse | Tangenz Corporation

  • The email address for notification is pre-populated from the user name. If the user name isn’t an email address, then provide a valid email address for notifications. Finally Click Create Instance.

  • Oracle sends an email to the designated email address when your service is ready. Alternatively, you can display the Activity page to check the current status. When the status changes from CREATING to ACTIVE, the service is ready to use.

Data Warehouse | Tangenz Corporation

 

Validate your Instance

When your FAW instance is Ready, follow below instructions to validate your Instance.

  • Sign in to the Oracle Cloud Infrastructure Console. Navigate to Analytics & AI under Analytics Click on Fusion Analytics Warehouse.

Analytics & AI | Tangenz Corpotaion

  • Click on the newly created service instance.

  • Click on Analytics Application URL to launch your FAW console.

Ex: https://XXXXXX-tangenzfaw-prod.data.analyticsapps.us-ashburn-1.ocs.oraclecloud.com/ui/oax

  • Click on Analytics Cloud URL to launch OAC console.

Ex: https://XXXXXX-ax8jyqhsezkk-ia.analytics.ocp.oraclecloud.com/ui/dv

 

If you need any help with your Fusion Analytics Warehouse (FAW) Implementations, Please drop a line here. Our FAW experts will contact you promptly.