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
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.
