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

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

Logical Architecture

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

Designer

  • Model (The description of the whole schema)

  • Reverse Engineer the whole schema

  • Right click on a table > View Data

Powered by ComboStrap