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:
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 Type | Logical Schema Name | Schema Description |
---|---|---|
Oracle | EBS_APPS | Oracle E-Business Suite |
Generic SQL. | PSFT_APPS | PeopleSoft Enterprise |
Generic SQL. | PSFT_HCM | PeopleSoft Human Capital Management |
Generic SQL. | AIF_TGT | ERP Integrator |
Oracle Hyperion Planning | HPL_TGT | Planning |
Oracle Hyperion Financial Management | HFM_TGT | Financial 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. |
Next, use Topology Manager to create the data servers and physical schemas. See Creating Data Servers and Physical Schemas.