Table of Contents
- Title and Copyright Information
- Preface
- 1 About Oracle Database Actions
-
Part I Development
-
2
The SQL and Data Modeler
Pages
- The Overview Page
- The SQL Page
- The Data Modeler Page
- Creating and Editing Database Objects
-
3
The REST Pages
- About RESTful Web Services
- RESTful Services Terminology
- About the Overview Page
- About the AutoREST Page
- About the REST Search Toolbar
- Creating RESTful Web Services
- Securing RESTful Web Services
- 4 The JSON Page
- 5 The Charts and Dashboards Page
- 6 The Scheduling Pages
- 7 The Liquibase Page
-
2
The SQL and Data Modeler
Pages
- Part II Monitoring
-
Part III Data Studio
- 9 The Data Studio Overview Page
- 10 Python ORDS API for Oracle Machine Learning
-
11
The Data Load Page
- Data Studio Preferences
- Managing Connections
-
Loading Data
- Use OCI Language Service Capabilities in Data Studio
- Use OCI Document Understanding to extract Tables from Images
- Use GeoJSON in Data Load
- Loading Data From Local Files
- Loading Data from Other Databases
- Loading Data from Cloud Storage
- Load Apache Iceberg Tables
- Loading Data from AI Source
- Loading Data from File System
- Loading Data from Share
- Create Live Feed from Data Load
- Linking Data
- Feeding Data
- 12 The Catalog Page
-
13
The Data Transforms Page
- Access Oracle Data Transforms From Data Studio
- Data Transforms Notes
-
Work with Connections
- Supported Connection Types
- Create Custom Connectors
- Create a Data Transforms Connection for Remote Data Load
- Create a Delta Share Connection
- Create an Oracle Business Intelligence Cloud Connector Connection
- Create an Oracle Financials Cloud Connection
- Create and Use an Oracle NetSuite Connection
- Create an Oracle Object Storage Connection
- Create a REST Server Connection
- Create a Data Load
- Run a Data Load
- Work with Data Entities
- Work with Projects
- Create a Data Flow
- Schedule Data Flows or Workflows
- Monitor Status of Data Loads, Data Flows, and Workflows
- Introduction to Workflows
- Create a Variable
- Create and Manage Jobs
- Export Objects
- 14 The Data Insights Page
-
15
The Data Analysis Tool
- Searching and obtaining information about Analytic Views
- Creating Analytic Views
- Working with Analyses
- Viewing Analyses
- Workflow to build Analyses
- Creating Analyses
- Creating Reports
- Run Natural Language Query in the Data Analysis Tool
- Using Calculation Templates
-
Oracle Autonomous Database Add-in for Excel
- Install the add-in on Mac
- Install the add-in on Windows
- Uninstall the add-in
- Using Oracle Autonomous Database Add-in for Excel
- Connection management
- Import a Connection
- Add a connection
- Share a connection
- Run native SQL queries in an Excel worksheet
- Query an Analytic View in an Excel worksheet
- Data Analysis in Excel Sheet
- FAQs for Troubleshooting errors with Excel Add-in
-
Oracle Autonomous Database
- Install and setup the add-on for Google Sheets
- Download Connection File
- Connecting to Autonomous Database
- Generate Client ID and Client Secret using UI
- Authorize Google Sheets to use Autonomous Database
- Data Analysis in Google Sheets
- Run Direct SQL Queries
- Reporting and Analysis in Google Sheets
- Clear Sheet
- Delete all sheets
- About menu
- Share or Publish
- Oracle Autonomous Database Privacy Policy Details
- 16 The Data Share Tool
- Part IV Administration
- A Supported SQL*Plus and SQLcl Commands in SQL Worksheet