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