Connect to Oracle Autonomous AI Lakehouse

You can create a connection to Oracle Autonomous AI Lakehouse and use the connection to access data.

You can connect to Oracle Autonomous AI Lakehouse using security certificates downloaded from Oracle Autonomous AI Lakehouse to a wallet (known as mTLS, or Mutual Transport Layer Security), or without a wallet (known as TLS, or Transport Layer Security). See About TLS Authentication. The credentials wallet file secures communication between Oracle Analytics and Oracle Autonomous AI Lakehouse. The wallet file (for example, wallet_ALKC1.zip) that you upload must contain SSL trusted certificates, to enable SSL on your Oracle AI Database connections.

Tutorial icon Tutorial

  1. Before you create connections to Oracle Autonomous AI Lakehouse, you must obtain the client credentials zip file containing the trusted certificates that enable Oracle Analytics to connect to Oracle Autonomous AI Lakehouse.

    See Download Client Credentials (Wallets) in Using Oracle Autonomous AI Database Serverless.

    The credentials wallet file secures communication between Oracle Analytics and Oracle Autonomous AI Lakehouse. The wallet file (for example, wallet_ALKC1.zip) that you upload must contain SSL certificates, to enable SSL on your Oracle Database Cloud connections.

  2. On your home page, click Create then click Connection.
  3. Click Oracle Autonomous Data Warehouse.
  4. For Connect Using, select Basic or Resource Principal.
    For information about using Resource Principal, see topic "Use Resource Principal to Access Oracle Cloud Infrastructure Resources" on Oracle Autonomous AI Database Serverless or Autonomous Database on Dedicated Exadata Infrastructure.
  5. Enter a user-friendly Connection Name and Description.
  6. For Encryption Type:
    • To connect without a credentials wallet file, select TLS as the Encryption Type, enter a Connection String, then enter a Username and Password of a user in Oracle Autonomous AI Lakehouse.
    • To connect using a credentials wallet file, select Mutual TLS as the Encryption Type, then click Select and browse for and select the Client Credentials wallet file that you downloaded from Oracle Autonomous AI Lakehouse (for example, wallet_ALKC1.zip), then enter a Service Name. The Client Credentials field displays the cwallet.sso file. See Selecting a Service Name for Oracle Autonomous AI Lakehouse.

      Tip: If you define the Oracle Autonomous AI Lakehouse connection using an instance wallet, the high service name is selected by default. Change the name to low or medium to avoid limiting the number of concurrent connections.

  7. In Client Credentials, then click Select to navigate to and select your client credentials ZIP file.
  8. Under Authentication, specify how you'd like to authenticate the connection:
    • Always use these credentials - Oracle Analytics always uses the login name and password you provide for the connection. Users aren’t prompted to log in.
    • Require users to enter their own credentials - Oracle Analytics prompts users to enter their own user name and password for the data source. Users can only access the data for which they have the permissions, privileges, and role assignments.
  9. Click Save.
You can now create datasets from the connection.