Creating Logical Schemas

After the master and work repositories are defined, enter logical schema names for each related technology type. You must enter the schema names exactly as defined below for a successful ERP Integrator configuration.

  To create ERP Integrator logical schemas:

  1. Launch Oracle Data Integrator Topology Manager.

  2. Select Logical Architecture.

  3. Expand Technologies.

  4. For each of the following technologies, right-click and select Insert Logical Schema. Enter the schema names exactly as shown in the table below. (All are required, even if a source or target is not being used.)

    Note:

    Oracle Data Integrator is packaged with several technologies. After you enter the logical schemas, select the option to hide unused technologies so that the list shown is shorter. The technology types listed below are specific to Oracle Data Integrator. For information on source systems that ERP Integrator supports, see the Oracle Hyperion Enterprise Performance Management System Certification Matrix.

    Technology TypeLogical Schema NameSchema Description
    OracleEBS_APPSOracle E-Business Suite
    Generic SQL.

    PSFT_APPS

    PeopleSoft Enterprise
    Generic SQL.PSFT_HCMPeopleSoft Human Capital Management
    Generic SQL.

    AIF_TGT

    ERP Integrator
    Oracle Hyperion Planning HPL_TGTPlanning
    Oracle Hyperion Financial Management HFM_TGTFinancial Management

    When finished, six logical schemas should be created.

    Note:

    For Essbase applications, ERP Integrator uses Essbase rules files to load metadata and data so the Oracle Data Integrator logical schema is not required.

  5. Next, use Topology Manager to create the data servers and physical schemas. See Creating Data Servers and Physical Schemas.