This chapter includes the following sections:
JD Edwards (JDE) EnterpriseOne is an integrated applications suite of comprehensive ERP software that combines business value, standards-based technology, and deep industry experience into a business solution with a low total cost of ownership.
The JDE Knowledge Modules for Oracle Data Integrator use mature database-level integration methods for JDE EnterpriseOne, in order to:
Reverse-Engineer JDE EnterpriseOne data structures
Read data from JDE EnterpriseOne (Direct Database Integration)
Write data through the Z-tables to JDE Application (Interface Table Integration)
Oracle Data Integrator provides the Knowledge Modules listed in the below table for handling JDE EnterpriseOne data. These specific JDE KMs provide connectivity and integration of the JDE EnterpriseOne platform with any database application through Oracle Data Integrator.
Table 3-1 JDE Knowledge Modules
Knowledge Module | Description |
---|---|
RKM JDE EnterpriseOne Oracle |
Reverse-engineers the metadata of the applications’ objects such as tables and interface tables from JDE EnterpriseOne installed on an Oracle database. |
RKM JDE EnterpriseOne SQL Server |
Reverse-engineers the metadata of the applications’ objects such as tables and interface tables from JDE EnterpriseOne installed on SQL Server. |
RKM JDE EnterpriseOne DB2 UDB |
Reverse-engineers the metadata of the applications’ objects such as tables and interface tables from JDE EnterpriseOne installed on IBM DB2 UDB database. |
RKM JDE EnterpriseOne DB2 AS400 |
Reverse-engineers the metadata of the applications’ objects such as tables and interface tables from JDE EnterpriseOne installed on IBM DB2 for iSeries server. |
IKM JDE EnterpriseOne Control Append (UBE) |
Integrates data from any source to JDE EnterpriseOne. Integrates data in EnterpriseOne Z-table in control append mode.
|
Make sure you have read the information in this section before you start working with the JDE EnterpriseOne data:
Before performing any installation, you should read the system requirements and certification documentation to ensure that your environment meets the minimum installation requirements for the products you are installing.
The list of supported platforms and versions is available on Oracle Technical Network (OTN):
http://www.oracle.com/technology/products/oracle-data-integrator/index.html.
In order to use the IKM JDE EnterpriseOne Control Append (UBE), the Oracle Data Integrator run-time agent must be installed on the JDE Server where the RunUBE utility is installed.
In order to use the RKM JDE EnterpriseOne DB2 UDB to reverse-engineer tables and Z-tables, the IBM DB2 UDB database should be able to access data stored in different DB2 databases. The following steps describe how to configure the access to DB2 family data sources:
Oracle Data Integrator connects to the database hosting the JDE data using JDBC connectivity. For detailed information on JDBC connectivity with Oracle database, Microsoft SQL Server, IBM DB2 UDB, and IBM DB2 for iSeries, see the following sections in the Connectivity and Knowledge Modules Guide for Oracle Data Integrator:
This step consists of declaring in Oracle Data Integrator the data server, as well as the physical and logical schemas that will be used to store the JDE data.
Depending on the underlying technology, the JDE tables can be stored in an Oracle schema, a Microsoft SQL Server database, an IBM DB2 UDB schema or in an IBM DB2 for iSeries library.
Create a data server for the technology hosting the JDE tables. For more information, see the following sections in the Connectivity and Knowledge Modules Guide for Oracle Data Integrator:
This data server must point to the instance, schema, database, or library (in the subsequent sections, the term schema will be used for all technologies) that stores the JDE data.
Create a physical schema under the data server that you have created in Create a Data Server. Use the standard procedure, as described in Creating a Physical Schema in Administering Oracle Data Integrator.
This schema must point to the schema that contains the JDE tables that you want to reverse-engineer.
Note:
The schema storing the JDE tables should never be defined as a work schema in the physical schema definition. Moreover, this schema must not be used as staging area of a mapping.
Create for this physical schema a logical schema using the standard procedure, as described in Creating a Logical Schema in Administering Oracle Data Integrator and associate it in a given context.
Setting up a project using JDE features follows the standard procedure. See Creating an Integration Project in Developing Integration Projects with Oracle Data Integrator.
Import the following KMs into your Oracle Data Integrator project:
IKM JDE EnterpriseOne Control Append (UBE)
Depending on the technology hosting your JDE tables, import one of the following:
RKM JDE EnterpriseOne Oracle
RKM JDE EnterpriseOne SQL Server
RKM JDE EnterpriseOne DB2 UDB
RKM JDE EnterpriseOne DB2 AS400
In addition to these specific JDE KMs, import the standard LKMs for the technology hosting your JDE tables. For a list of available KMs, see the following sections in the Connectivity and Knowledge Modules Guide for Oracle Data Integrator:
This section contains the following topics:
Create a model based on the technology hosting the JDE tables and on the logical schema created when configuring the JDE Connection using the standard procedure, as described in Creating a Model in Developing Integration Projects with Oracle Data Integrator.
Note:
There is no JDE EnterpriseOne technology defined in Oracle Data Integrator. The data model is created with the logical schema corresponding to the Oracle database hosting the JDE data.
The JDE RKMs are able to reverse-engineer JDE tables. These RKMs retrieve metadata from JDE objects such as tables and interface tables.
To perform a Customized Reverse-Engineering of JDE tables with the JDE RKMs, use the usual procedure, as described in Reverse-engineering a Model in Developing Integration Projects with Oracle Data Integrator. This section details only the fields specific to JDE tables:
The reverse-engineering process returns the datastores grouped per module. You can use these datastores as a source or a target of your mappings.
You can use JDE data tables as a source of a mapping. JDE Z-tables can be used as the target of a mapping.
The KM choice for a mapping determines the abilities and performance of this mapping. The recommendations in this section help in the selection of the KM for different situations concerning loading and integrating JDE data.
After performing a reverse-engineering using the RKM JDE EnterpriseOne <database>, you can use JDE data tables as a source of a mapping to extract data from the JDE application and integrate them into another system (Data warehouse, other database and so forth).
Using JDE EnterpriseOne as a source in these conditions is the same as using an Oracle, Microsoft SQL Server, DB2/400 or an IBM DB2 UDB datastore as a source in a mapping. The generic SQL, Oracle Database, or Microsoft SQL Server, IBM DB2 for iSeries, and IBM DB2 UDB KMs can be used for this purpose. See the following chapters in the Connectivity and Knowledge Modules Guide for Oracle Data Integrator for more information:
After performing a reverse-engineering using the RKM JDE EnterpriseOne <database>, you can use JDE Z-tables as a target of a mapping to load data from any system to the JDE application with the IKM JDE EnterpriseOne Control Append (UBE).
The integration of data into JDE EnterpriseOne is performed in two phases:
During the first phase, data is integrated into a set of Z-tables using several mappings, without calling the RunUBE command. These mappings can use the IKM JDE EnterpriseOne Control Append (UBE) with the JDE_RUNUBE option set to No
.
During the second phase, the RunUBE command is launched to integrate the data from these Z-tables into JDE EnterpriseOne. This is typically done in the mapping loading the last required Z-table. This mapping also uses the IKM JDE EnterpriseOne Control Append (UBE) with the JDE_RUNUBE option set to Yes
.
These mappings should be sequenced in a package.
Oracle Data Integrator can automatically call the RunUBE command to write to JDE. The RunUBE call should be activated in the IKM only after loading all the required Z-table for populating JDE. The capability to load the Z-Tables, as well as the call of the RunUBE command is provided by the IKM JDE EnterpriseOne Control Append (UBE).
To create a mapping targeting JDE:
Create a mapping with Z-tables as target datastores.
Create joins, filters, and mappings as usual.
In the Flow tab, select the IKM JDE EnterpriseOne Control Append (UBE).
Set the standard KM options (INSERT, COMMIT, FLOW_CONTROL).
Set the JDE_RUNUBE option to Yes
.
Specify the JDE_DIRECTORY in which the RunUBE command is executed.
If you want to create a password file, set the password related options as shown in the below table.
Table 3-3 Password Related KM Options
Option | Value | Notes |
---|---|---|
JDE_CREATE_PWD_FILE |
Yes |
To enhance RunUBE security in a Unix or iSeries environment, when the RunUBE command is submitted, the system reads the text file specified in the JDE_PWD_FILE option and uses the JD Edwards EnterpriseOne user ID and password as indicated in the text file. |
JDE_PWD_FILE |
Absolute path of the password security file |
This file contains the user id and password specified in the JDE_USER_ID and JDE_PWD options. |
JDE_DELETE_PWD_FILE |
|
Enter Enter Note that even if the password file is removed after the execution of the command, the file should be kept in a secure location on the server file system. |
JDE_USER_ID |
JDE EnterpriseOne user ID |
The user must have permissions to run the report. |
JDE_PWD |
JDE EnterpriseOne password |
The EnterpriseOne password that corresponds to the user ID. |
Set the parameters for the RunUBE command as shown in the below table.
Table 3-4 RunUBE Command Related KM Options
Option | Value | Notes |
---|---|---|
JDE_ENVIRONMENT |
The JDE EnterpriseOne environment |
|
JDE_ROLE |
The JDE EnterpriseOne role |
|
JDE_REPORT |
The system name of the report that you want to process |
For example: |
JDE_VERSION |
The name of the version of the report that you want to process |
For example: |
JDE_JOB_QUEUE |
The name of the job queue to which the system should route the batch job |
For example: |
JDE_PROCESSING_MODE |
The processing mode |
Enter Enter |
JDE_HOLD_CODE |
The hold code |
Enter Enter |
JDE_SAVE_CODE |
The save code |
Enter The delete option ( |
Limitations of the IKM JDE EnterpriseOne Control Append (UBE)
The TRUNCATE option cannot work if the target table is referenced by another table (foreign key).
When using the RECYCLE_ERRORS option, an Update Key must be set for your mapping.
When using this module with a journalized source table, data is automatically filtered to not include source deletions.
The FLOW_CONTROL and STATIC_CONTROL options call the Check Knowledge Module to isolate invalid data (if no CKM is set, an error occurs). Both options must be set to No when a mapping populates a TEMPORARY target datastore.
The RunUBE command must be executed on the JDE server.
The Oracle Data Integrator run-time agent must be installed on this server.
Besides the information whether the RunUBE command has been started or not, the RunUBE command does not give any further details about the execution of the program. To know more about the execution of the program you can either view the log file created by the JDE server or connect to your JDE application and look for the application View Job Status (Application = P986110
, Form = W986116A
).