Table of Contents
- Title and Copyright Information
- Abstract
- Preface
-
1
Get Started with Oracle Fusion Data Intelligence
- About Oracle Fusion Data Intelligence
- About Oracle Fusion Data Intelligence Service Level Objective
- About Oracle Fusion Data Intelligence Releases
- About Oracle Fusion Data Intelligence Components
- About Oracle Fusion Data Intelligence Console
- Comparison of Capabilities Between Analytics Cloud Associated with Fusion Data Intelligence and Standalone Analytics Cloud
- Usage Guidelines for Autonomous AI Lakehouse Associated with Oracle Fusion Data Intelligence
- Preview Features
- Generally Available Features
- Third Party Data Connectors
- Region Availability
- Billing Metrics of Autonomous AI Lakehouse Associated with Oracle Fusion Data Intelligence
-
Oracle Fusion Data Intelligence Security Considerations
- Security Setup Tasks
- Oracle Identity Cloud Service Access Management Tasks
- Oracle Fusion Data Intelligence Security Tasks
- Semantic Model Extensions Security Tasks
- Data Augmentation Security Tasks
- Oracle Fusion Data Intelligence Security Automation Tasks
- Audit Security Tasks
- Oracle Analytics Cloud Security Tasks
- Oracle Autonomous AI Lakehouse Security Tasks
- 2 Activate Oracle Fusion Data Intelligence
-
3
Set Up Oracle Fusion Data Intelligence
- Prerequisites for Oracle Fusion Data Intelligence
- Typical Workflow to Set Up Oracle Fusion Data Intelligence
- Set Up User Access to Oracle Fusion Data Intelligence Using Single Sign-On
-
Create an Oracle Fusion Data Intelligence Instance
- About Creating an Instance
- Create a Security Zone for Your Instance Compartment
- Create an Integrated Oracle Fusion Data Intelligence Instance
- Create an Oracle Fusion Data Intelligence Standalone Instance
- Create an Oracle Fusion Data Intelligence Instance Without Oracle Fusion Cloud Applications Source
- Deploy Oracle Fusion Data Intelligence with a Private Endpoint
- Make Preview Features Available
- Enable Generally Available Features
- Manage Alerts
- View Work Requests
- View Subscriptions
- Update the Data Source Connection Details
- Update Your Subscriptions
- Update the Administrator Password for Oracle Autonomous AI Lakehouse
- Rotate the Wallet for the Oracle Autonomous AI Lakehouse
- Reset the Password for OAX_USER and Custom Schemas
- Terminate Instances
- Move the Oracle Fusion Data Intelligence Instance to Another Compartment
- Update the Notification Email
- Scale Up Oracle Autonomous AI Lakehouse
- Change Oracle Analytics Cloud Capacity
- Activate the Universal Credits Subscription
- Provide Your Encryption Key for Oracle Autonomous AI Lakehouse
- Configure Advanced Options
- Configure the Access Control List
- Secure Autonomous AI Lakehouse Associated with Fusion Data Intelligence Using Data Safe
-
4
Configure Oracle Fusion Data Intelligence Data
- Typical Workflow to Configure Data
- About Data Processing Limits
- About Data Pipelines for Functional Areas
- About Pipeline Parameters
- Set Up the Pipeline Parameters
- Create a Data Pipeline for a Functional Area
- Edit a Data Pipeline for a Functional Area
- Activate a Data Pipeline for a Functional Area
- About Reporting Configurations
- Set Up the Global Report Parameters
- Set Up the Reporting Configurations for Enterprise Resource Planning
- Set Up the Reporting Configurations for Human Capital Management
- Set Up the Reporting Configurations for Supply Chain Management
- Deactivate a Data Pipeline for a Functional Area
- Delete a Data Pipeline for a Functional Area
- Refresh a Data Pipeline for a Functional Area
- Reload Data for a Data Pipeline
- Reset the Data Warehouse
- Reset the Cache
- Reset and Reload the Data Source
- Schedule Incremental Data Refreshes
- View the Estimated Data Refresh Time
- View Request History
- View the Audit Log
- View the Data Pipeline Status
- View Records Rejected in Extraction
- Augment the Data
- Create a Dimension Alias
-
Manage Data Connections
-
Connect With On-premises
Sources
-
Set up the Remote Agent to Load Data into Fusion Data Intelligence (Preview)
- Perform Remote Agent Connection Prerequisites
- Configure TLS for Remote Agent Configuration (Optional)
- Run the Remote Agent Docker on Windows
- Configure the Remote Agent Using the Command Line Interface Tool on Windows
- Run the Remote Agent Docker on Linux
- Configure the Remote Agent Using the Command Line Interface Tool on Linux
- Create the Remote Agent Connection
- Load Data from On-premises E-Business Suite into Fusion Data Intelligence (Preview)
- Load Data from On-premises MySQL Database into Fusion Data Intelligence (Preview)
- Load Data from On-premises PeopleSoft into Fusion Data Intelligence (Preview)
- Load Data from On-premises JD Edwards into Fusion Data Intelligence (Preview)
- Load Data from SQL Server into Oracle Fusion Data Intelligence (Preview)
- Load Data from Oracle Database Using JDBC into Fusion Data Intelligence (Preview)
-
Set up the Remote Agent to Load Data into Fusion Data Intelligence (Preview)
-
Connect with Cloud File Storage
Sources
- About OpenCSV Standards
- About Date and Timestamp Formatting for CSV File-based Extractors
- Load Data from Amazon Simple Storage Service into Oracle Fusion Data Intelligence (Preview)
- Load Data from Oracle Object Storage Service into Fusion Data Intelligence
- Load Data from an SFTP Source into Fusion Data Intelligence (Preview)
- Load Data from Azure Storage into Oracle Fusion Data Intelligence (Preview)
-
Connect With Cloud Sources
- Load Data from Azure SQL into Oracle Fusion Data Intelligence (Preview)
- Connect with Your Oracle Eloqua Data Source (Preview)
- Load Data from Oracle Enterprise Data Management Cloud into Fusion Data Intelligence (Preview)
- Load Data from Oracle Enterprise Performance Management into Fusion Data Intelligence (Preview)
- Load Data from EPM Export Data Instance into Fusion Data Intelligence (Preview)
- Load Data from Google Analytics into Oracle Fusion Data Intelligence
- Load Data from MongoDB into Fusion Data Intelligence (Preview)
- Load Data from MySQL Cloud Database into Fusion Data Intelligence (Preview)
- Load Data from Salesforce into Fusion Data Intelligence
- Load Data from Shopify into Fusion Data Intelligence
- Load Data from Oracle Autonomous Database into Oracle Fusion Data Intelligence (Preview)
- Load Data from Snowflake into Oracle Fusion Data Intelligence (Preview)
- Load Data from Taleo into Fusion Data Intelligence (Preview)
- Load Data from Oracle Analytics Publisher into Fusion Data Intelligence
- Load Data from Oracle Transportation Management Cloud Service into Oracle Fusion Data Intelligence (Preview)
- Load Data from Oracle Warehouse Management Cloud into Oracle Fusion Data Intelligence (Preview)
- Load Data from Fusion Supply Chain Planning into Oracle Fusion Data Intelligence (Preview)
- Load Data from QuickBooks Online into Oracle Fusion Data Intelligence (Preview)
-
Connect With On-premises
Sources
- View Notifications and Emails
- Enable Event Notifications (Preview)
-
Schedule Frequent Data Refreshes
- About Scheduling Frequent Data Refreshes
- Schedule Frequent Refreshes of Data with Redesigned Refresh Mechanism (Preview)
- Schedule Frequent Refreshes of Data with Original Refresh Mechanism
- Schedule Reload of Data
- Schedule Frequent Refreshes of Warehouse Tables (Preview)
- Override Data Pipeline Schedules for Functional Areas (Preview)
- Prioritize Datasets for Incremental Refresh (Preview)
- Schedule Data Maintenance
-
Extend Data with Data Applications
- About Extending Data with Data Applications
- Use Data Applications to Extend Data
- Edit a Data Application
- Delete a Data Application
- Perform an Ad hoc Refresh of a Data Application
- Reload Data for a Data Application
- Undeploy a Data Application
- Share Data with External Systems (Preview)
- Capture Data Changes (Preview)
-
Connect to an Autonomous AI Lakehouse
- Configure Autonomous AI Lakehouse Credentials for Oracle Fusion Data Intelligence
- Connect Fusion Data Intelligence to an Autonomous AI Lakehouse with Database Actions (SQL Developer Web)
- Connect Fusion Data Intelligence to an Autonomous AI Lakehouse with Oracle Analytics Cloud
- Connect Fusion Data Intelligence to an Autonomous AI Lakehouse with SQL Developer Desktop Client
- View the Warehouse Refresh Statistics
- About Refreshing Your data
- 5 Validate Oracle Fusion Data Intelligence Data
-
6
Manage Users, Groups, Application Roles, and Data Access
- About Managing Users, Groups, Application Roles, and Data Access
- Typical Workflow to Manage Users, Groups, Application Roles, and Data Access
- Manage Users
- Manage Groups
- Manage Application Roles
-
Manage Data Access
- Apply Existing Fusion Security Assignments
- Create a Security Assignment
- Delete a Security Assignment
- Remove Users from a Security Assignment
- Manage Users for a Security Assignment
- Set Exclusion Rules for Security Assignments
- Update Security Assignments Automatically
- Define and Assign Custom Security Contexts
- Specify Data Access Rules
- Enable AOR-Based Security
- Configure Permissions for Metadata and Front-End Objects
- View Activity History
-
Manage Uploads and Downloads
- About Uploading and Downloading Your Data
- Upload and Download Data Security Assignments
- Upload and Download Financial Categories
- Upload and Download Financial Category Assignments
- Download and Upload Area of Responsibility Data
- Download and Upload Custom Job Roles Mappings
- Download and Upload Data Security Exclusion Rules
- Set Up Custom Security
-
7
Customize Oracle Fusion Data Intelligence
- About Semantic Model Customization
- Recommendations and Tips to Extend the Semantic Model
- Create a Custom Database Schema
- Migrate or Create Database Objects
- Grant Semantic Model Access
- About the Semantic Model Extensions Banner
-
Extend the Semantic Model Using
the Sandbox Framework
- Apply System Extensions
- Manage Your Sandbox
- Prepare Your Sandbox
- Prepare Your Model
- Integrate Your Sandbox
-
Use Cases: Extend the Semantic
Model Using the Sandbox Framework
- Upload Samples for the Semantic Model Extensions Use Cases
- Use Case 1: Extend a Conformed Dimension
- Use Case 2: Extend a Degenerate Dimension
- Use Case 3: Add Custom Dimension to a Prebuilt Fact
- Use Case 4: Add a Custom Fact
- Use Case 5: Add a Degen Custom Fact
- Use Case 6: Add Derived Columns
- Use Case 7: Create Custom Dim with Hierarchy
- Use Case 8: Create a Subject Area Based on an Existing Subject Area
- Use Case 9: Create a Subject Area
- Generate and Download the Sandbox Report
-
Extend the Semantic Model Using
the Branch Framework
- Migrate to the Sandbox Framework for Semantic Model Extensions
- Create a Branch
- Edit a Branch
- Add a Step to a Branch
- Edit or Delete a Branch Step
- Reapply a Branch Step
- Disable and Enable the Disabled Steps
- Copy Steps from One Branch to Another
- View Details of Failed Branch Steps
- Merge the Customization Branches with the Main Branch
- Reorder Steps of Customization Branches
- Delete a Main Branch Step
- Tag the Main Branch's Steps
- Publish the Model
- Load Customization Data to the Autonomous Data Warehouse
- Add Security Configurations
- View Activity History of Semantic Model Extensions
- Move Your Customizations to Another Environment
- Merge Your External Applications
- Manage Frequently Refreshed Data in the Workbooks
-
8
Manage Oracle Fusion Data Intelligence
- Manage Application Updates
- Bundle Your Application Artifacts
- Configure a Virus Scanner
-
Back Up and Restore
- Strategies for Backing up and Restoring Oracle Cloud Infrastructure Identity and Access Management
- Strategies for Backing up and Restoring Oracle Fusion Data Intelligence Console Configurations
- Strategies for Backing up and Restoring Oracle Analytics Cloud
- Strategies for Backing Up and Restoring Oracle Autonomous AI Lakehouse
- Automated Backup for Oracle Autonomous AI Lakehouse
- Custom Backup for Oracle Autonomous AI Lakehouse
- About Disaster Recovery
- About Scaling Resources
- About Licensing
-
9
Use AI capabilities in Oracle Fusion Data Intelligence
-
Access AI Concierge (Preview)
- Perform the Prerequisites for Using AI Concierge
- AI Concierge for Administrators
- Live Information Queries
- Sample Queries
- Tips for Optimal Usage of AI Concierge
- Extend Entities with DA Script
- DA Script Tutor
- DA Script Code Assistant
- AI Concierge for Semantic Model Extensions
- AI Concierge for Consumers
- Access Oracle Fusion Data Intelligence MCP Server (Preview)
-
Access AI Concierge (Preview)
- 10 Frequently Asked Questions
- 11 Troubleshooting
- 12 Certification Information
- A Resolve Common Errors in Semantic Model Extensions
- B Event Types, Attributes, and Attribute Values for Event Rules
- C Conformed Dimensions to Merge External Applications