Oracle Autonomous Database for Excel
The Oracle Autonomous Database for Excel integrates Microsoft Excel spreadsheets with the Autonomous Database to retrieve and analyze data from Analytic Views in the database. You can also directly run SQL queries to view their results in the worksheet.
- The Download Microsoft Excel/Google Sheets add-in is available to you under the Downloads menu of your Database Actions instance only if you have the
ADPUSER
role. - You require ADMIN privileges to grant roles.
- To grant yourself an
ADPUSER
role, you must log into your Database Actions instance and enter the following command in the SQL worksheet area displayed in the SQL tab under Development tools present in the Launchpad:Grant ADPUSER to USER;
- Install the add-in from Microsoft AppSource
The Oracle Autonomous Database for Excel is available in Microsoft AppSource. - Install the add-in from Database Actions
You can install the add-in from Database Actions. This is accessed by users with Oracle Account. - Uninstall the add-in
The following section describes the steps to uninstall the Oracle Autonomous Database add-in. - Using Oracle Autonomous Database for Excel
After you install the add-in, a new ribbon tab, Oracle Autonomous Database appears in MS Excel. - Connection management
Each time you start the add-in for Excel, you must create a connection. - Log Settings
The Settings icon enables you to set the log levels using the Excel add-in. - Run Direct SQL queries in an Excel worksheet
The Oracle Autonomous Database for Excel lets you run Direct SQL queries to work with your data in an Excel worksheet. - Reporting and Analysis in Excel
You can view Reports and Analytic Views or visualizing data for analysis purpose using the Analysis and Reports menu. - Query an Analytic View in an Excel worksheet
The Query Wizard menu enables you to query an Analytic View and retrieve the results in an Excel Worksheet. Once the wizard retrieves the data, it becomes local to Excel. You can further edit the data in Excel but not write back to the Autonomous Database. - Data Analysis in Excel Sheet
The Data Analysis tool enables you to analyze data in the Autonomous Database by running SQL queries or querying an Analytical View using an intuitive drag-and-drop interface. You can also write custom queries to be run. You now can dynamically apply filters to the result set retrieved using the new faceted search capability on specific columns. - Natural Language in Excel Sheet
You can use Natural Language Query to query the Oracle Autonomous Database using the Natural Language menu in the Oracle Autonomous Database for Excel . - FAQs for Troubleshooting errors with Excel Add-in
If you experience issues with Oracle Autonomous Database for Excel, refer to frequently asked questions in this section to identify and resolve issues. - Oracle Autonomous Database for Excel Privacy Policy Details
This topic covers details for writing policies to control access to Autonomous Database resources.
Parent topic: The Data Analysis Tool
Using Oracle Autonomous Database for Excel
After you install the add-in, a new ribbon tab, Oracle Autonomous Database appears in MS Excel.
You can connect to multiple Autonomous Databases, work with Analytic Views, tables, and Views, and view the data in the worksheet.
This ribbon provides buttons that let you connect to the Autonomous Database.
Click Connections to connect to an Autonomous Database. You must Refer to the Connection management for more details.
Click Settings to view the logging level settings of the Excel Add-in. You can also clear the logs or export the log files by copying the logging information to the clipboard.
Click About to view the Add-in and the supported Excel versions. The About window also displays whether the spreadsheet is connected to the database. It also shows version information for the database and Oracle Rest Data Services.
Click Direct SQL to run custom SQL queries. See
Click Data Analysis to query an existing Analytic View and run queries.
Click Natural Language to run Natural Language Queries on Tables.
Parent topic: Oracle Autonomous Database for Excel