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;
- Use the Microsoft Edge browser for the best compatibility and performance.