About Oracle Fusion Analytics Warehouse
Oracle Fusion Analytics Warehouse is a family of prebuilt, cloud native analytics applications for Oracle Cloud Applications that provides line-of-business users with ready-to-use insights to improve decision-making.
It empowers business users 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 Oracle Autonomous Data Warehouse. This packaged service starts with Oracle Fusion Cloud Applications, and you can deploy rapidly, personalize, and extend it. The service extracts and loads data from your Oracle Fusion Cloud Applications into an instance of Oracle Autonomous Data Warehouse. Business users can then create and customize dashboards in Oracle Analytics Cloud.
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. Apart from your Oracle Fusion Cloud Applications data, you can load external data from non-Oracle Fusion Cloud Applications sources such as SalesForce or EBusiness Suite into Oracle Autonomous Data Warehouse associated with Oracle Fusion Analytics Warehouse. See About Managing Data Connections.
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 |
| Mumbai, India | ap-mumbai-1 | BOM |
| Phoenix, AZ | us-phoenix-1 | PHX |
| Sao Paulo, Brazil | sa-saopaulo-1 | GRU |
| Singapore, Singapore | ap-singapore-1 | SIN |
| Sydney, Australia | ap-sydney-1 | SYD |
| Tokyo, Japan | ap-tokyo-1 | NRT |
| Toronto, Canada | ca-toronto-1 | YYZ |
| UK Gov London, United Kingdom | uk-gov-london-1 | LTN |
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 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. You can update to a release any time before the predefined date by changing it to a date convenient for you. See Update Your Application. On the predefined date, if you haven't yet updated, then Oracle Fusion Analytics Warehouse automatically updates your data model and content without extending the predefined date.
- 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).
- You aren't impacted by major application releases which have undergone testing to negate the impact to existing business users. Major application releases don't cause service downtime.
About Oracle Fusion Analytics Warehouse Service Level Objective
Oracle Fusion Analytics Warehouse is built on Oracle Cloud Infrastructure and leverages the Oracle PaaS Cloud services.
Oracle Fusion Analytics Warehouse availability is tied to dependent Oracle services such as Oracle Identity Cloud Service, Oracle Analytics Cloud, Oracle Autonomous Data Warehouse, and Oracle Cloud IaaS services, including compute and storage. Each of these services has published service level agreements under Oracle Cloud SLA. See the Oracle PaaS and IaaS Public Cloud Services Pillar Document (PDF).
Oracle Fusion Analytics Warehouse has a service-level objective (SLO) of 99.9%.
About Oracle Fusion Analytics Warehouse Components
Oracle Fusion Analytics Warehouse consists of several core components such as Oracle Cloud Infrastructure Identity and Access Management, Oracle Fusion Analytics Warehouse Console, data pipeline infrastructure, Oracle Autonomous Data Warehouse, and Oracle Analytics Cloud.
- Data pipeline to Oracle Fusion Cloud Applications
- Data model
- Semantic model
- Best practice content like KPIs, dashboards, and reports
- Add external data sources into the same Oracle Autonomous Data Warehouse as the Oracle Fusion Cloud Applications data.
- 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.
- Create KPIs, dashboards, and reports.
Oracle Fusion Analytics Warehouse Console
You must have the Oracle Fusion Analytics Warehouse service administrator role to access the Console and perform administration tasks.
The following table outlines the tasks that you can perform on the Oracle Fusion Analytics Warehouse Console.
| Task | More information |
|---|---|
| Security | Manage users and their access to subject areas and data. See Manage Users, Groups, Application Roles, and Data Access. |
| Release Updates | Decide and apply the application updates except the emergency patches that are deployed automatically. See Manage Application Updates. |
| Virus Scanner | Use the Virus Scanner option on the Console in Oracle Fusion Analytics Warehouse to connect to your virus scanning server. See Configure a Virus Scanner. |
| Advanced Configuration | Advanced data and content configurations will be available in a future release. |
| Data Configuration | Configure connections to source systems Fusion and managed pipelines. Configure pipeline settings, data augmentations and application specific configurations. See Configure Oracle Fusion Analytics Warehouse Data. |
| Semantic Model Extensions | Configure extensions and customizations to the semantic model. Join with custom data objects or import external semantic models. See Customize Oracle Fusion Analytics Warehouse. |
| Data Validation | Validate the data after loading the source data from Oracle Fusion Cloud Applications into your data warehouse. See Validate Oracle Fusion Analytics Warehouse Data. |
| Uploads | Upload and download data related to security and financial categories to your data warehouse using files. See Manage Uploads and Downloads. |
| Promote Objects | Promote changes to the semantic model, security configurations, and customized KPIs from non-production to Production environments. See Promote Your Customizations to the Production Environment. |
| Bundles | Manage snapshots of your application artifacts as bundles. See Bundle Your Application Artifacts. |
| Session and Query Cache | See which users are signed in and troubleshoot report queries. This is also accessible from the FAW console. See Monitor Users and Activity Logs. |
| Issue SQL | Test and debug SQL queries. See Run Test SQL Queries. |
Comparison of Capabilities between Analytics Cloud Associated with Fusion Analytics Warehouse and Standalone Analytics Cloud
As an Oracle Fusion Analytics Warehouse service administrator, you perform certain tasks differently in the Oracle Analytics Cloud associated with Oracle Fusion Analytics Warehouse than the standalone Oracle Analytics Cloud.
Service administrators have access to two console user interfaces, and administrative tasks span both the consoles. The Oracle Fusion Analytics Warehouse console allows administrators to manage central tasks that are common to both users as well as the application. The Oracle Analytics Cloud console allows administrators to configure features that are specific to analytics. Oracle Analytics Cloud associated with Oracle Fusion Analytics Warehouse is directly connected to the Oracle Autonomous Data Warehouse and doesn't support connections to external systems through the Analytics Server. For example, connections to social media platforms isn't supported through the Analytics Server of Oracle Analytics Cloud associated with Oracle Fusion Analytics Warehouse. You can use the Oracle Fusion Analytics Warehouse console to define external connections and extensions to the repository file but you can't directly access the repository (rpd) file.
The following table outlines the tasks that you can and can't perform on the Oracle Analytics Cloud Console that is included with Oracle Fusion Analytics Warehouse. You must have the Oracle Fusion Analytics Warehouse service administrator role to access the Console and perform administration tasks.
| Tasks | More Information |
|---|---|
| Maps | Define how users display their data on maps. See Manage Map Information for Analyses. |
| Extensions | Upload custom visualization types or custom data actions. See Manage Custom Plug-ins. |
| Social | Not available. External connections to social media platforms aren't allowed in Oracle Fusion Analytics Warehouse. |
| Search Index | Set up how content is indexed and crawled so users always find the latest information when they search. See Schedule Regular Content Crawls and Monitor Search Crawl Jobs. |
| Safe Domains | Authorize access to safe domains. See Register Safe Domains. |
| Users and Roles | Not available. Use the Security option on the Console in Oracle Fusion Analytics Warehouse to define users and roles. See Manage Users, Groups, Application Roles, and Data Access. |
| Snapshots | Not available. Use the Bundles option on the Console in Oracle Fusion Analytics Warehouse to manage snapshots. See Bundle Your Application Artifacts. |
| Semantic Model Connections | Not authorized. Additional database connections for the semantic model aren't supported through the Oracle Analytics Cloud Console. Only the connection to Oracle Autonomous Data Warehouse is supported. However, all direct connections from the visualization layer in Oracle Analytics Cloud are supported, because these don't use the Analytics Server. |
| Virus Scanner | Use the Virus Scanner option on the Console in Oracle Fusion Analytics Warehouse to connect to your virus scanning server. See Configure a Virus Scanner. |
| Session and Query Cache | See which users are signed in and troubleshoot report queries. This is also accessible from the Console in Oracle Fusion Analytics Warehouse. See Monitor Users and Activity Logs. |
| Issue SQL | Test and debug SQL queries. See Run Test SQL Queries. |
| Mail Server | Connect to your email server. See Set Up an Email Server to Deliver Reports. |
| Monitor Deliveries | Track deliveries sent by the email server. See Track the Reports You Distribute by Email or Through Agents. |
| System Settings | Not authorized. Oracle directly manages the system settings for each of the Oracle Fusion Analytics Warehouse instances and tunes the instances to provide an optimized user experience. Oracle Fusion Analytics Warehouse doesn't allow configuration of advanced options for Oracle Analytics Cloud. |
| Remote Data Connectivity | Register one or more Data Gateway agents for remote connectivity to visualization workbooks. See Configure and Register Data Gateway for Visualization. |
Usage Guidelines for Autonomous Data Warehouse Associated with Fusion Analytics Warehouse
Oracle Fusion Analytics Warehouse provisions instances of Oracle Autonomous Data Warehouse to store data. As part of the integrated SaaS offering of Oracle Fusion Analytics Warehouse, Oracle doesn't allow or recommend certain Oracle Autonomous Data Warehouse administration tasks.
| Task | More information |
|---|---|
| Database life cycle management | You can't stop, delete, pause, or restart the database. Oracle Fusion
Analytics Warehouse controls these activities for the instance.
Oracle recommends that you don't rename the database and don't use the Start or Stop options in the Scheduled Maintenance feature for the Oracle Autonomous Data Warehouse instance associated with Oracle Fusion Analytics Warehouse. |
| Changes to auto-provisioned resources |
You can scale up resources such as OCPUs for additional capacity or terabytes for additional storage. However, you can't scale down such resources to levels below those automatically provisioned with Oracle Fusion Analytics Warehouse. Auto-scale for OCPUs is turned on by default by Oracle Fusion Analytics Warehouse and you can't turn it off. |
| Autonomous data guard | Even though you can turn on Autonomous Data Guard, this isn't recommended because Oracle Fusion Analytics Warehouse doesn't currently support failover to the instance populated through Data Guard. |
| Restore from backups | Oracle Autonomous Data Warehouse provides daily backups. While restoring to a new instance may be useful to view or copy data from backup, it isn't recommended to restore backups against the Oracle Autonomous Data Warehouse instance associated with Oracle Fusion Analytics Warehouse. Doing so may put the data pipelines and factory content in an inconsistent state. |
| Custom Usage | Guidance |
|---|---|
| Adding data to custom schemas | You can add as many as 50GB of custom data to the service. For more than 50GB, you must scale up the terabytes of storage through the Oracle Cloud Infrastructure Console, which is charged to your Oracle Cloud account. If you intend to do compute intensive queries and transformations on your custom data, then you can scale up additional OCPUs using the Oracle Cloud Infrastructure Console, which is charged to your Oracle Cloud account. See Scale Up Oracle Autonomous Data Warehouse Storage. |
| Adding additional CPUs | Ensure that you have adequate CPUs configured in Oracle Autonomous Data Warehouse (and corresponding sessions) to be able to run custom ETL. For every CPU that was allocated as part of the Oracle Fusion Analytics Warehouse instance creation, you shouldn't exceed 5 low service concurrent sessions for custom ETL. Exceeding this can impact the ETL or reporting performance and hence isn't supported. If you need to run more sessions, then ensure that you've additional CPU added to your Oracle Autonomous Data Warehouse instance. Each additional CPU that you add this way will allow upto 300 low sessions. You must avoid Medium or High sessions in all cases, as they block the ETL pipeline. |
| Adding database connections |
See Tutorial.
Follow these guidelines:
|
Preview Features
Oracle Fusion Analytics Warehouse offers certain functionality as preview features for you to try. Preview features are high confidence features that are design, specification, and implementation complete with roadmap commitment but may change before they become generally available.
Preview features are intended for evaluation and training purposes. You may evaluate the preview features for production use as-is based on your specific parameters. Contact Oracle support if you've questions on feasibility of rolling out a specific preview feature for production use.
To find out about features currently available for preview, see Features Available for Preview.
Preview features are disabled by default. If you want to explore one of the preview features, ask your administrator to enable it for your organization. Administrators can make preview features available for others to try; see Make Preview Features Available.
Features Available for Preview
Preview features enable functional administrators to switch functionality on and off. This way, your organization can evaluate and learn how to use new features before they become generally available.
To enable the preview features, see Make Preview Features Available.
Functional Areas
| Feature | Description |
|---|---|
| AWS S3 |
This feature enables an administrator to connect to data in Amazon Simple Storage Service (AWS S3). See Load Data from Amazon Simple Storage Service into Oracle Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Google Analytics |
This feature enables connecting to a Google Analytics instance and building a complete managed data pipeline with that data. See Load Data from Google Analytics into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle Autonomous Database |
This feature enables an administrator to connect to custom data in Oracle Autonomous Data Warehouse. You can create upto five connections to different Oracle Autonomous Data Warehouse instances and they are denoted as Oracle Autonomous Database 1, Oracle Autonomous Database 2, Oracle Autonomous Database 3, Oracle Autonomous Database 4, and Oracle Autonomous Database 5. See Load Data from Oracle Autonomous Database into Oracle Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle E-Business Suite On-Prem |
This feature enables configuring remote agent, loading data from on-premises Oracle eBusiness Suite (EBS) and building a complete managed data pipeline with that data. See Load Data from On-premises E-Business Suite into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle EPM - Financial Close and Consolidation |
This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle EPM - Planning and Budgeting |
This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle EPM - Profitability and Cost Management |
This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle JD Edwards On-Prem |
This feature enables connecting to the various data sources in the on-premises JD Edwards instance and building a complete managed data pipeline with that data. See Load Data from On-premises JD Edwards into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle Object Storage Service |
This managed pipeline connects to Oracle Object Storage to ingest datasets into Oracle Fusion Analytics Warehouse followed by data augmentation. See Load Data from Oracle Object Storage into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle PeopleSoft On-Prem - Campus Solutions |
This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle PeopleSoft On-Prem - Financials |
This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle PeopleSoft On-Prem - Human Resources |
This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle PeopleSoft On-Prem - Learning Management |
This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Remote Agent |
Remote Agent application helps bring data from the on-premises applications like E-Business Suite and JD Edwards into Oracle Fusion Analytics Warehouse. See Load Data from a Remote Agent into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Salesforce REST |
This feature enables an administrator to connect to Salesforce SaaS source and build complete managed data pipeline with that data. See Load Data from Salesforce into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| SFTP |
This feature enables connecting to a Secure FTP source and building a complete managed data pipeline with that data. See Load Data from a Secure FTP Source into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Shopify |
This feature enables connecting to a Shopify instance and building a complete managed data pipeline with that data. See Load Data from Shopify into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Snowflake |
This feature enables connecting to a Snowflake instance and creating augmentations on that data. See Load Data from Snowflake into Oracle Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Taleo |
This feature enables connecting to a Taleo instance and creating augmentations on that data. See Load Data from Taleo into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| U.S. Bureau of Labor Statistics (BLS) |
This feature enables connecting to publicly available datasets from Bureau of Labor Statistics (BLS) datasets and building a complete managed data pipeline with that data. See Load the Bureau of Labor Statistics Data into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Feature | Description |
|---|---|
| Event Notification | This feature publishes data pipeline events to the Oracle Cloud Infrastructure Audit service. |
| Feature | Description |
|---|---|
| Data Refresh Estimate |
This feature enables prediction of completion time for data refresh. The predicted time is visible under Data Pipeline in the Pipeline Parameters section on the Pipeline Settings page. See About Data Refresh Performance.
Default: Off Restart Required: No |
| Prioritized Data Refresh |
This feature enables configuration of the warehouse tables for prioritized refresh ahead of other data in the regularly scheduled daily refresh cycles. See Prioritize Datasets for Incremental Refresh (Preview).
Default: Off Restart Required: No |
Generally Available Features
Oracle Fusion Analytics Warehouse offers certain functionality as generally available that you must enable using the Console. Generally available features are publicly available features that you can use for production workloads.
To learn about features that are generally available, see Features Generally Available.
Generally available features are disabled by default. Administrators can make these features available for others to use; see Enable Generally Available Features.
Features Generally Available
Generally available features enable functional administrators to switch functionality on and off.
To enable the generally available features, see Enable Generally Available Features.
| Feature | Description |
|---|---|
| Frequent Data Refresh |
This feature enables certain pipeline refresh schedules to be set to a frequency of 4 hours or higher. See Schedule Frequent Refreshes of Functional Area Data.
Default: Off Restart Required: No |
| Scheduled Full Data Reload |
For specific functional areas, an administrator can schedule full refreshes on a weekly, monthly, or quarterly basis. See Schedule Periodic Full Reload of Functional Area Data.
Default: Off Restart Required: No |