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 Studio.

  2. Click on the Topology Manager tab.

  3. Under the Topology tab, click Logical Architecture.

  4. Expand Technologies.

  5. 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.

    Table 1. Logical Schema

    Technology TypeLogical Schema NameSchema DescriptionOptional or Required
    Generic SQLAIF_TGT ERP IntegratorRequired
    OracleAIF_TG_ORACLEERP IntegratorRequired if using Open Interface or SAP Adapter
    FileAIF_FILE Required
    Oracle EBS_APPS Oracle E-Business SuiteRequired if integrating with EBS / Peoplesoft / Fusion. Provide a dummy physical connection information if integrating with Peoplesoft or Fusion.
    OracleFUSION_APPSOracle Fusion FinancialsRequired if integrating with EBS or Peoplesoft or Fusion. Provide a dummy physical connection information if integrating with EBS or Peoplesoft.
    Generic SQL. PSFT_APPS PeopleSoft EnterpriseRequired if integrating with EBS or Peoplesoft or Fusion. Provide a dummy physical connection information if integrating with EBS or Fusion. integrating with PeopleSoft or Fusion.
    Generic SQL. PSFT_HCM PeopleSoft Human Capital ManagementRequired if integrating with PeopleSoft HCM.
    Oracle Hyperion Planning HPL_TGT PlanningRequired if integrating with Hyperion Planning
    Oracle Hyperion Financial Management HFM_TGT Financial ManagementRequired if integrating with Hyperion Financial Management
    SAP

    (Also see the installation guide provided by Bristlecone),

    		SAP_SOURCESAPRequired if integrating with SAP

    Associate a physical schema with AIF_TGT and AIF_FILE in the GLOBAL context in addition to other contexts required for integration.

    Clear the Table Alias Separator for the Generic SQL Technology in the Logical Architecture.

    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.

  6. Next, use Topology Manager to create the data servers and physical schemas.

    See Creating Data Servers and Physical Schemas.