ODI - Database Technology

Card Puncher Data Processing

ODI - Database Technology

Steps

Topology

Physical Architecture

  • Right Click a database technology node, create a new Server (for instance Oracle)
  • In the definition pane, enter:
    • a name
    • an instance (for instance ORCL)
    • and the connection parameters
  • In the Jdbc Pane, enter:
    • the Driver: oracle.jdbc.OracleDriver
    • the URL. For instance: jdbc:oracle:thin:@localhost:1521/myServiceName

Odi Orcl Physical Server Definition

  • Create a physical Schema. Fill the following fields with one directory:
    • Directory (Schema)
    • Directory (Work Schema)

Odi Orcl Physical Schema Definition

Logical Architecture

  • Right Click on the logical architecture technology (ORACLE for instance)

Odi Orcl Logical Schema Definition

Designer

  • Model (The description of the whole schema)

Odi Model Database Teechnology

  • Reverse Engineer the whole schema

Odi Model Database Technology Reverse

  • Right click on a table > View Data







Share this page:
Follow us:
Task Runner