Oracle (DWH)

Learn how to configure and manage Oracle (DWH) metadata sources using Cloudera Data Lineage (formerly Octopai).

Tool Permissions Prerequisites

  • Open Server Port for each Oracle Database Connection
  • Existing/New Oracle user for each database with 'READ’ permissions for the following dictionary tables:
    • DBA_INDEXES
    • DBA_SOURCE
    • DBA_DEPENDENCIES
    • DBA_CATALOG
    • DBA_VIEWS
    • DBA_TAB_COLUMNS
    • DBA_IND_COLUMNS
    • DBA_SYNONYMS
    • DBA_MVIEWS

Setting up Oracle Metadata Source

Metadata Sources are set on the Octopai Client

Figure 1. New Metadata Source wizard

Verify extraction results

After a successful run, confirm the metadata archive in the target folder. See Verify extracted metadata files.

Troubleshoot

If an error occurs during the extraction, see Troubleshoot connector extraction failures.