About Oracle Fusion Analytics Warehouse
Oracle Fusion Analytics Warehouse empowers you with industry-leading, AI-powered, self-service analytics capabilities for data preparation, visualization, enterprise reporting, augmented analysis, and natural language processing. It is a Cloud application that delivers best-practice Key Performance Indicators (KPIs) and deep analyses to help decision-makers run their business.
Oracle Fusion Analytics Warehouse is built on top of Oracle Analytics Cloud, and is powered by Oracle Autonomous Data Warehouse. This packaged service starts with Oracle Applications Cloud, and you can deploy rapidly, personalize, and extend it. The service extracts and loads data from your Oracle Applications Cloud into an instance of Oracle Autonomous Data Warehouse. You can then use Oracle Analytics Cloud to customize existing dashboards and create 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. You can customize the pre-built content as defined in the Customize Oracle Fusion Analytics Warehouse section.
- System Settings
- Users and Roles
- Snapshots
- Connections
- Virus Scanner
- Social
You must configure the included semantic model only with the embedded Oracle Fusion Analytics Warehouse tools and deployed only on the Oracle Fusion Analytics Warehouse service instance. You mustn’t configure the included semantic model with non-Oracle Fusion Analytics Warehouse tools including Oracle Analytics Client Tools, Oracle Analytics Administration Tool, or APIs.
Oracle Fusion Analytics Warehouse runs on Oracle Cloud Infrastructure and is integrated with many infrastructure services. Before you begin using Oracle Fusion Analytics Warehouse, you should become familiar with Oracle Cloud Infrastructure. See Welcome to Oracle Cloud Infrastructure.
Region Availability
Oracle Fusion Analytics Warehouse is available in the following regions currently:
| Region Location | Region Name | Region Key |
|---|---|---|
| Ashburn, VA | us-ashburn-1 | IAD |
| Dubai, UAE | me-dubai-1 | DXB |
| Frankfurt, Germany | eu-frankfurt-1 | FRA |
| Jeddah, Saudi Arabia | me-jeddah-1 | JED |
| London, United Kingdom | uk-london-1 | LHR |
| Phoenix, AZ | us-phoenix-1 | PHX |
| Sao Paulo, Brazil | sa-saopaulo-1 | GRU |
| Sydney, Australia | ap-sydney-1 | SYD |
| Toronto, Canada | ca-toronto-1 | YYZ |
About Oracle Fusion Analytics Warehouse Releases
Updates to Oracle Fusion Analytics Warehouse are mainly released as Application and Platform releases with major features and minor, security, and emergency patches.
- Platform Releases:
- Platform Releases contain updates to your service; for example as security patches and updates to the Console accessible to administrators.
- You'll receive "System Maintenance" notification emails in advance where an update is planned (usually on a Friday or Saturday evening) and you'll experience downtime.
- You don't need to make any selection or take any action. These updates include operating system and security patches and are applied for all customers on the same day.
- Because these releases don't change the data model or content, business users aren't affected.
- You can expect a major release every quarter, a minor patch every month, and emergency fixes as patches.
- Application Releases:
- Application Releases contain updates to the data model and new content when available.
- You'll receive notification emails about these releases.
- You'll find the release numbers listed in the Release Updates tile of the Console, where you can view the available releases and apply them as appropriate.
- You'll notice an "auto-update" target date for major releases. If you don't update your service to the release by the target date, then your service is automatically updated on that date. You can schedule an earlier date on which you'd prefer to update your service.
- You can expect a major release every quarter and optional updates or emergency patches. Each patch is cumulative. For example, if you choose to apply the 22.R1.P3 patch, then the previous patches (such as 22.R1.P1 and 22.R1.P2) are also applied with the 22.R1.P3 patch. You won't see the older patches listed in the Release Updates tile of the Console as available releases when the release changes to the current one (such as 22.R1.P3).
About Oracle Fusion Analytics Warehouse Components
Oracle Fusion Analytics Warehouse has ready-to-use components that Oracle manages and extensible components that you can manage.
- Data pipeline to Oracle Applications Cloud.
- Data model.
- Semantic model.
- Best practice content like KPIs, dashboards, and reports.
All this is built using the platform services of Oracle Analytics Cloud and Oracle Autonomous Data Warehouse that you can use to customize and extend with self-service analytics and with a more govern approach.
- Add external data sources into the same Oracle Autonomous Data Warehouse as the Oracle Applications Cloud data.
- From a more govern approach, use any ETL tool or the robust Oracle Data Integrator with its many connectors to load data into the custom schemas and tables in the same Oracle Autonomous Data Warehouse repository.
- Connect to data using more than the 30 self-service connectors rather than loading data into Oracle Autonomous Data Warehouse.
- Import Microsoft Excel files or spreadsheets.
- Extend the semantic model with an easy-to-use utility.
- Create KPIs, dashboards, and reports.