Cloudera Docs

Oracle ODI

Learn how to configure Oracle ODI as a metadata source for Cloudera 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 Cloudera Octopai Client

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

How to verify the extracted Metadata File

Access the Cloudera Octopai Target Folder (TGT)

Access the Cloudera Octopai Target Folder (TGT)

  1. Go to the TGT Folder located on the Server where the Cloudera 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