Before you Begin

This 10-minute tutorial shows you how to create a connection to Oracle Autonomous AI Lakehouse.

Background

As an administrator, you create a connection to Oracle Autonomous AI Lakehouse that enables other users to access data sources and to create datasets for their Oracle Analytics projects.

When using Mutual TLS as the connection's encryption type, you must download a client credentials zip file for the Oracle Autonomous AI Lakehouse instance. The file contains security-related files, including a wallet file with certificates for Secure Sockets Layer (SSL) communication between Oracle Autonomous AI Lakehouse and Oracle Analytics Cloud. SSL is the only type of connection allowed to Oracle Autonomous AI Lakehouse.

You can also use the TLS encryption type when creating a connection to an Oracle Autonomous AI Lakehouse instance.

What Do You Need?

  • Access to Oracle Cloud Infrastructure
  • Access to Oracle Autonomous AI Lakehouse
  • Access to Oracle Analytics Cloud or Oracle Analytics Desktop

Download the Credentials File

In this section, you download the wallet file needed when using Mutual TLS (mTLS) as the encryption type for the connection to Oracle Autonomous AI Lakehouse

If you are planning to use a wallet-free connection with the Transport Layer Security (TLS) encryption type, you can skip this section.

  1. Sign in to your Oracle Cloud instance using your URL.
  2. On the Oracle Cloud My Services page, click Navigator Navigation menu icon. Expand Services and select Autonomous AI Lakehouse.
  3. Click your Autonomous AI Lakehouse region, for example, North America Autonomous AI Lakehouse or EMEA Autonomous AI Lakehouse.
  4. In the Autonomous AI Lakehouse page, click the instance to use for your connection.
  5. In the Oracle Autonomous AI Lakehouse instance, click DB Connection.
  6. In Database Connection, under Download Client Credentials (Wallet), click Download.
  7. In Download Wallet, enter a Password to secure the client credentials file. In Confirm Password, enter the same password, and then click Download.


    Some database clients require that you provide both the wallet and the password to connect to your database, and other clients that auto-login without using the wallet password.

  8. In Opening Wallet, click Save, and then click OK.

    The client credentials wallet zip file is saved to your default downloads location.

Create the Autonomous AI Lakehouse Connection

In this section, you create a connection using the Mutual TLS encryption type.

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create. In Create Connection, click Oracle Autonomous AI Lakehouse, and then click OK.
  3. In Create Connection, enter a Connection Name, for example, MyADW_connection.
  4. In Description, enter a brief description.
  5. From the Encryption Type list, select Mutual TLS.
  6. Click Select next to Client Credentials. In File Upload, select the wallet zip file from your download location.


    The Client Credentials field is populated with cwallet.sso. The Service Name field contains a value.

  7. Enter your Oracle Autonomous AI Lakehouse Username and Password.
  8. From the Service list, select the service for your data, and then click Save.

Learn More