Oracle Cloud Infrastructure Documentation

Overview

Database Tools is a fully managed Oracle Cloud Infrastructure (OCI) service that simplifies database access and management. It provides secure HTTPS access to Oracle Database and MySQL Database. Use this service to:

  • Manage connection resources to provide the required connectivity details to access your databases. The connection resources enable the use of the Database Actions web application that provides development, data tools, administration, and monitoring features.
  • Leverage Private Endpoint resources for secure access to databases in private networks.
  • Manage identity resources to enable the use of OCI resource principals to access OCI resources from an Oracle Database. You can provision multiple identity resources for the same database, and you can grant an identity resource to multiple database users.
This image provides an overview of the Database Tools service.

Creating database connections is simple using the guided database connection builder user interface. Select the OCI database type (Oracle Autonomous Database, Oracle Database (Bare Metal, VM, Exadata), MySQL Database, and Oracle Exadata on Oracle Public Cloud) and the innovative connection build automatically discovers databases you have access to and assists in creating the connection. Database credentials are stored in the OCI vault and retrieved only when accessing the database. If the credentials change, you can quickly and easily update them in the vault, minimizing any interruptions.


This image provides an overview of the working of Identity with Database Tools service.

The SQL Worksheet allows you to interact with any Database Tools database connection you have access to in one location. You do not need to search for connection details or use multiple web apps to access different databases. You use a single select list on the SQL Worksheet.