Work with Database Connections and Resources

Before You Begin

Ensure that:

You selected the target Oracle Cloud Infrastructure region and compartment.
You have OCI permission to inspect, use, or manage Autonomous AI Database resources.
You have the administrator password or database user name and password required to connect to the database.
The Database Actions URL is available when you add an external or existing database connection.

Create a new database or connect to an existing database when the workflow that you want to use requires one.

View Available Databases

Click Databases in the left navigation panel to open the Databases page. It displays the available databases and their connection and lifecycle status. This page opens and you can browse even when no database is connected.

The Cloud provider indicates whether a database belongs to Oracle Cloud Infrastructure or a multicloud environment, such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform. Use the search field to locate a database.

Create an Autonomous AI Database

Open the Databases page and do the following:

Click Create Autonomous AI Database and specify the following:
- Database name
- Administrator password
Under Advanced options, you can review or change additional settings, such as the compartment, workload type, and compute resources. For Workload type, select Transaction Processing or Lakehouse.
Click Create to provision a new database.

The page displays the database state as provisioning progresses. When the State displays Available, the new database is ready to use.

For more information, see Provision an Autonomous AI Database Instance.

Connect to a Database

Data Studio provides different ways to connect to your database, such as:

the Choose Database option in the header
the Databases page
the Catalog page

If no database is selected, Data Studio displays an option to connect when you open a workflow that requires a database.

Open the Databases page and do the following:

Select the database that you want to connect to.
Click the three dots for the selected database to open the Actions menu.
Select Connect to open the schema credentials window.
Enter the database user name and password.
Click Connect to connect to the database.

After the connection succeeds, the header displays the selected database.

Add a Database Actions URL

You can use a Database Actions URL to connect to a database, for example, to work with an on-premises database.

Open the Databases page and do the following:

Click the Cloud button next to Create Autonomous AI Database.
Enter a valid Database Actions URL in the provided space.

An Oracle REST Data Services (ORDS) URL usually ends with /_sdw/.
Click Save to store the URL.

After you add the connection, the page displays the connected database.

Disconnect a Database

You can disconnect from a database in the following ways:

Click the database name in the header and select Disconnect.
Go to the Databases page, hover over the database name, and select Disconnect.

Lifecycle Operations

In Data Studio you can perform basic lifecycle operations for a database.

On the Databases page, click the three dots for the selected database to open the Actions menu and select the operation to perform.

Connect: To connect to the selected database.
Start: To start the database instance.
Stop: To stop the database instance.
Restart: To restart the database.
Clone: To clone the selected database.
Manage Resources: To manage the resource configuration, for example compute, storage, and so on.
Change admin password: To modify the password. The password must meet the required validation criteria.
Terminate: To stop and delete the database.

Note:

Use caution when you select Terminate because the database and its data are permanently deleted.
Open in OCI Console: To open the database in the Oracle Cloud Infrastructure Console to perform advanced operations that are not available in Data Studio.

For more information, see Manage Lifecycle Operations.