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.

Note:

  • 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;

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.

Click Table Hyperlinks to read and access tabular data using table hyperlinks.

Click Data Analysis to query an existing Analytic View and run queries.

Click Natural Language to run Natural Language Queries on Tables.