Working with Oracle Data Integrator JDE EnterpriseOne KMs
To use JDE EnterpriseOne with the Oracle Data Integrator JDE KMs, you must:
Define the Topology
Set up the Project
Reverse-Engineer JDE tables
Use JDE datastores as sources or target in an integration interface
Defining the Topology
The steps to create the topology in Oracle Data Integrator, which are specific to projects using Oracle Data Integrator JDE KMs, are the following:
Connect to your master repository using Topology Manager.
Create a data server using the Oracle Server technology. This data server should point to the Oracle database instance that stores the JDE data.
Create a physical schema under this data server. This schema points to the Oracle schema database that contains the JDE tables you want to reverse-engineer.
Create a logical schema for this physical schema in the appropriate context.
You can now perform a JDE Reverse-Engineering.
Note: The Oracle schema storing the JDE tables should never be defined as a work schema in the physical schema definition. Moreover, this schema or database must not be used as staging area for an interface.
Setting up the Project
Import the following KMs into your Oracle Data Integrator project: IKM JDE Enterprise One Control Append (UBE) RKM JDE Enterprise One Oracle
Import in addition the standard Oracle LKMs and CKMs to perform data extraction and data quality checks with an Oracle database. See the Oracle Database section of this guide for a list of available KMs.
For more information about importing a KM, please refer to the Oracle Data Integrator User’s Guide.
Reverse-Engineering JDE Tables
The RKM JDE Enterprise One Oracle is able to reverse-engineer JDE tables. This RKM retrieves metadata from JDE objects such as tables and interface tables.
To perform a JDE Reverse-Engineering:
1. Create a model based on the Oracle Technology, and on the logical schema created when configuring the JDE Connection.
In this Model, select the Reverse tab and:
1. 2 .
Select Customized Select the RKM JDE Enterprise One Oracle from the KM list
Knowledge Modules Reference Guide