ODI - Database Technology
Table of Contents
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