Cloudera Docs

Oracle Autonomous Data Warehouse (OAD/ADW)

Learn how to configure Oracle Autonomous Data Warehouse (OAD/ADW) as a metadata source for Cloudera Data Lineage (formerly Octopai).

Tool Permissions Prerequisites

  1. Log into OCI, go to databases.

  2. Select the database you want to connect and click on “Database connection”.

  3. Set the wallet type to “Instance Wallet”, and download the file.

  4. Extract the content of the zip into a folder, it should look like this:

Setting up OAD Metadata Source

Metadata Sources are set on the Octopai Client

How to verify the extracted Metadata File

Access the Cloudera Data Lineage Target Folder (TGT)

  1. Go to the TGT Folder located on the Server where the Octopai Client is installed. By default: C:\Program Files (x86)\Octopai\Service\TGT
  2. Open the zip file having the Connector Name. Example:
  3. Verify its content: Quantity & Quality of inner files

Troubleshoot

Error during the extraction:

  • Check the permissions
  • Send the log with the connector number and name to Cloudera Support - C:\Program Files (x86)\Octopai\Service\log