Setup takes about 5-10 minutes.
Introduction
Connecting Oracle Autonomous Data Warehouse to Foundational allows Foundational to read metadata, build lineage, and track data anomalies in your warehouse.
To make the connection, you need to:
Create a database user in Oracle Autonomous Data Warehouse
Download and secure the Oracle Wallet for mTLS
Connect your warehouse to Foundational using the database user and wallet credentials
Prerequisites
Ensure you have:
Access to the Autonomous Database instance in Oracle Warehouse
Permission to create database users
Permission to download and manage the Oracle Wallet
Added Foundational IP addresses to the allowlist, see the article Allowing IP access to Foundational.
Access permissions
The permissions listed in the table enable Foundational to build lineage and track anomalies.
Tables | Product Feature | Technical Justification |
SYS.DBA_* | Lineage and Catalog | Grants read-only access to the metadata tables (but not to the actual data) to get schema information and compute lineage. |
All Tables | 1. Data observability (monitor data anomalies)
2. Lineage and catalog | Grants read-only access to all your tables. This allows Foundational to track data anomalies and also to get schema information and compute lineage. |
Create a new database user
Log in to your Oracle Cloud account and open your Autonomous Database instance.
Create a new user using Oracle’s instructions and assign read-only permissions:
SYS.DBA_*: Grants permission to extract metadata for lineage only.
All tables: Grants permission to extract metadata for lineage and to monitor and track anomalies.
Enter a password and store it safely because you can’t retrieve it. You’ll need it to set up the connection.
Download and set up the Oracle Wallet
Oracle Wallet enables Mutual TLS (mTLS) communication with Autonomous Data Warehouse.
In your Autonomous Database instance, click DB Connection.
In Download Client Credentials (Wallet), click Download.
Enter a password to secure the wallet and confirm it. Store the wallet password safely. You’ll need it to set up the connection.
Download and store the ZIP file. You’ll need it to set up the connection.
Connect Foundational to Oracle Warehouse
In Foundational, open the Connectors & Integrations page.
In Warehouses, select the Oracle Warehouse card and click Connect.
The initial setup screen opens. Click Start Setup.
The Setup New Connection screen opens.
Enter the details:
Database service: Usually
<dbName>_low
Database username: The user you created
Database password: The user’s password
Wallet file: Upload the ZIP file you downloaded
Wallet password: The wallet password
Click Next.
The final setup screen opens. To complete the connection, click Save.
That’s it. Foundational is now connected to your Oracle Warehouse.