This setup should take about 5 minutes.
Permissions: If you would like Foundational to track data anomalies you will need to provide read-only access.
You can also complete the setup without read-only access to the data, and just allow access to the metadata (in which case, data anomalies feature will be disabled)
This guide will walk you through the process of setting up access to your database in Oracle Autonomous Data Warehouse for Foundational.
Preparations in Oracle Autonomous Data Warehouse
Create a new database user in Oracle Autonomous Data Warehouse:
Log in to your Oracle Cloud account and navigate to your Autonomous Database instance.
Create a new user by following the instructions here.
Note: The user should have read-only access to all the tables in the DB if you would like to track data anomalies.
If you are not interested in tracking data anomalies, then read-only access to
SYS.DBA_*
tables is sufficient.
Important: The database password you set during these steps is required for the Foundational connection. Store it securely as you cannot retrieve it later.
Set up Oracle Wallet
Oracle Wallet needed to set up Mutual TLS (mTLS) communication to Oracle Autonomous Data Warehouse.
In the Oracle Autonomous Data Warehouse instance, click DB Connection.
In Database Connection, under Download Client Credentials (Wallet), click Download.
In Download Wallet, enter a Password to secure the client credentials file. In Confirm Password, enter the same password, and then click Download.
In Opening Wallet, click Save, and then click OK.
Important: The wallet password you set during the download is required for the Foundational connection. Store it securely as you cannot retrieve it later.
Fill in the relevant information in Foundational
Go to Foundational product, and in the Connectors page, click on Oracle Warehouse to configure the following:
Database service: Usually
<dbName>_low
.Database username: The username you created above.
Database password: The password you set up for the user above.
Wallet File: Upload the ZIP file you downloaded from Oracle Cloud.
Wallet Password: The password you set when downloading the wallet.