Oracle ODI

Learn how to configure Oracle ODI as a metadata source for Cloudera Data Lineage (formerly Octopai).

Tool Permissions Prerequisites

  1. Open Server Port for each ODI databases repositorie
  2. Existing/New Oracle user for each database with grant read permission for the following dictionary tables:
    • SNP_MAP_CONN
    • SNP_MAP_CP
    • SNP_MAP_ATTR
    • SNP_MAP_EXPR
    • SNP_PACKAGE
    • SNP_MAP_REF
    • SNP_TABLE
    • SNP_COL
    • SNP_DEPLOY_SPEC
    • SNP_EXEC_UNIT_GRP
    • SNP_LOAD_PLAN
    • SNP_EXEC_UNIT
    • SNP_PHY_NODE
    • SNP_PHY_EXPR
    • SNP_MAP_EXPR_REF
    • SNP_MAP_PROP
    • SNP_SCEN
    • SNP_SCEN_FOLDER
    • SNP_MAPPING
    • SNP_SEQUENCE
    • SNP_MODEL
    • SNP_FOLDER
    • SNP_PROJECT
    • SNP_MAP_COMP

Setting up ODI Metadata Source

Metadata Sources are set on the Octopai Client

Connection Name: Giving a meaningful name to the connection will be useful for future references.

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.