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)