Defining Physical Schemas, Logical Schemas, and Contexts

In order to access or populate data, ODI needs to know where that data resides. The physical locations and connection criteria for servers and the Physical Schemas are defined in the Topology Navigator, under the Physical Architecture. The connection details of the servers and schemas will vary from environment to environment (development environment, testing environment, production environment, and any other environment you have) but the data on these servers will be organized the same way. To shelter developers from these implementation variations, developers will only have to know about one name for all environments, called the Logical Schema (think of it as an alias for all physical connections). A Context will be created for each environment, so that when needed, the Logical Schema can point to the appropriate physical connection. We will now see these elements in more detail.

Defining physical data servers

Once we have connected...