1. Oracle Polska
  2. Database

Oracle Database Tools Service

Oracle Database Tools Service is a managed offering in Oracle Cloud Infrastructure (OCI) that enables you to create connections to any Oracle Database in OCI that can be reused by multiple users, resources, and services. Once a connection is established, use the web-based SQL Worksheet for direct SQL access or use the connection in a SQLcl session via the OCI Cloud Shell. Sensitive information such as passwords and Autonomous Database client credentials are stored securely and encrypted in your OCI vault and never viewed when connections are being used.

Learn all about the Database Tools Service (23:32)

Oracle Database Tools Service features

Providing you with the tools to make Oracle Cloud Infrastructure cloud database connections secure, easy, and reusable for development, DevOps processes, and SQL access.

Database connections

Database connections are resources that contain the necessary information for accessing an Oracle Database in OCI. Connections are created by simply providing information about where the database is and what type it is (Autonomous, VM, or Exadata). The connection also contains the user used to access the database as well as the location of the password that is stored in the OCI vault.

Creating database connections is simple using the guided user interface. Select the OCI database type and the innovative connection builder automatically discovers databases 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 disruptions. Share database connections, not passwords, among groups and users.


SQL worksheet

The SQL Worksheet utilizes the database connections you create with the service to enable you to run SQL commands and scripts from the OCI Console. Scripts used in the SQL Worksheet can reside in either OCI Object Storage or on your local drive. Using the Connection selection menu, you can quickly change the connection that the SQL Worksheet is using.


Private endpoints

Many Oracle Cloud Infrastructure services are protected by multiple layers of network security. For the Database Tools Service to access these database services, a path into a customer's virtual cloud network (VCN) must exist. Private endpoints give the database tools network access to these databases through a customer’s virtual cloud network, which in turn allows you to access these databases from the SQL Worksheet or via SQLcl from the OCI Cloud Shell. One private endpoint can service multiple database in the same virtual cloud network.


APIs and events

The Database Tools Service has many APIs for you to use with your favorite application development platform. Our GitHub repository has many examples for all the latest development languages to help you get started with the Database Tools Service APIs. The service also has events you can subscribe to in OCI that enable you to create automation based on changes such as creation or updating of a connection.


Oracle Database Tools Service key benefits

  • Easy Access to any Oracle Cloud Database

    In just a few simple guides steps, create a connection to any Oracle Database in Oracle Cloud Infrastructure to instantly start using via SQLcl or the web bases SQL Worksheet.

    Create a connection

  • Share database connections

    By utilizing groups and policies, share database connections, not passwords, among services, applications, or users.

    Database tools policies

  • Web-based tools

    No client software to download, configure or install. Use the database connections in either the web-based SQL Worksheet or SQLcl via the Cloud Shell.

    Using the SQL Worksheet

Oracle Database Tools Service resources

Documentation

Oracle Database Tools Service documentation

Learn about the service, read up on best practices, and see what APIs are available.

related content

Additional resources

Related products

Oracle REST Data Services

REST Access for your Oracle Database

SQLcl

A modern command-line for Oracle

SQL Developer

The database development environment

Data Modeler

Simplify data modeling tasks

Get started with Database Tools Service


Watch an overview of Oracle Database Tools Service

See a complete walkthrough of the service.

Watch the video (23:32)

Best Practices for Oracle Database Tools Service

Learn how to get started with our best practices guide.

Best practices

Contact us

Chat live with sales or support.

Get in touch