Announcing the Oracle Cloud Infrastructure (OCI) Database Tools Service: Introduction & Demo

Database Tools is a managed service 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

Quickly and easily store connection information for any of your Oracle databases in the Oracle Cloud - including your username and passwords (protected by your secret in your Oracle Vault). Then use those connections to launch SQLcl or a SQL worksheet to do your database work, directly in your OCI Console.

Have a database protected by a private subnet in your VCN? No worries, let us spin up a Bastion for you so you can easily connect to your database.

Bookmarks:

1:21 Demo Begins - navigating to the service
1:50 Building a connection from scratch
3:50 Securing your passwords, securely with the OCI Vault
5:13 Databases accesible via Private Subnets via Private Endpoints
7:00 Testing the connection with 'Validate'
7:18 SQL Worksheet demo
8:30 Switching connections in your Worksheet!
9:15 Saving and Loading scripts to and from the Object Store (OSS)
12:00 Connections are now OCI Resources with their own OCIDs
13:50 SQLcl demo
15:40 SQLcl starts up and uses a Bastion to access a database on a private endpoint

OCI DBTools Service Docs:
https://docs.oracle.com/en-us/iaas/Content/Database-Tools/dbtools_topic-overview.htm

Service Announcement Blog Post:
https://www.thatjeffsmith.com/archive/2021/11/announcing-the-database-tools-oracle-cloud-service/

Видео Announcing the Oracle Cloud Infrastructure (OCI) Database Tools Service: Introduction & Demo канала Jeff Smith