X hits on this document





25 / 131

Working with Oracle Data Integrator JDE EnterpriseOne KMs

To use JDE EnterpriseOne with the Oracle Data Integrator JDE KMs, you must:

  • 1.

    Define the Topology

  • 2.

    Set up the Project

  • 3.

    Reverse-Engineer JDE tables

  • 4.

    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:

  • 1.

    Connect to your master repository using Topology Manager.

  • 2.

    Create a data server using the Oracle Server technology. This data server should point to the Oracle database instance that stores the JDE data.

  • 3.

    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.

  • 4.

    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


Document info
Document views486
Page views489
Page last viewedThu Jan 19 11:25:58 UTC 2017