1. Administrator's Guide
  2. Using FDMEE
  3. Configuring Oracle Data Integrator With FDMEE
  4. Setting up Physical Schemas

Setting up Physical Schemas

To update a physical schema:

  1. Access the Oracle Data Integrator Console.
  2. Select the Browse tab.
  3. Expand Schemas.
  4. Expand Physical Schemas.
  5. Select the schema to update, and then click Edit.

    For example, select EBS_DATA_SERVER or PSFT_FMS_DATA_SERVER.

  6. In Schema Name, enter the schema name in uppercase characters.
  7. Click Save.

Caution:

Extensive problems can occur if you switch the Enterprise Resource Planning (ERP) system connection information for the Physical Schema in the Oracle Data Integrator Topology Manager after you have completed initial configuration. For example, extensive problems can occur if you start using one physical schema (ERPTEST) pointing to ERP Test Instance1 in the Oracle Data Integrator Topology Manager, and then change to a connection information in this physical schema to point to ERP Test Instance2 without first creating a new context in Oracle Data Integrator. The correct procedure is to create two physical schemas (ERPTEST1 and ERPTEST2) each pointing to a different ERP instance. Then, create two contexts and associate the appropriate physical schema to the logical schema in the context.