Set the RKM options as follows: JDE_CENTRAL_OBJECTS: Specify the Oracle Schema storing the JDE Central objects JDE_DATA_DICTIONARY: Specify the Oracle Schema storing the JDE data dictionary JDE_OBJECT_LIBRARIAN: Specify the Oracle schema storing the JDE Object librarian JDE_CONTROL_TABLES: Specify the Control Tables schema
Note: To find the schema required in the options JDE_CENTRAL_OBJECTS, JDE_DATA_DICTIONARY, JDE_OBJECT_LIBRARIAN, and JDE_CONTROL_TABLES you can either ask your application manager or query the table F98611(Data Source Master).
JDE_DATA_TABLES: Set this option to YES to reverse-engineer data tables JDE_Z_TABLES: Set this option to YES to reverse-engineer interface tables (Z-tables)
JDE_MODULES: Indicate the JDE System Short Name, for example 00 for Foundation Environment, 01 for Address Book, and 02 for Electronic Mail.
JDE_LANGUAGE: Indicate the language used for retrieving object descriptions, for example E for English, F for French, and S for Spanish.
Specify the reverse mask in the Mask field in order to select the tables to reverse. The Mask field, in the Reverse tab, filters reverse-engineered objects based on their name. The Mask field must not be empty and must contain at least the percentage symbol (%).
Click Apply, and then click Reverse.
You can follow the reverse-engineering process in the Execution Log.
Note: The reverse-engineering process may take several minutes. Please wait until the reversed datastores appear under the reversed module in the tree of the execution Log.
The reverse-engineering process returns the datastores grouped per module. You can then use these datastores as a source or a target of your interfaces.
Using JDE as a Source in an Integration Interface
After performing a reverse-engineering using the RKM JDE Enterprise One Oracle, you can use JDE data tables as a source of an interface to extract data from the JDE application and integrate them into another system (Data warehouse, other database...). Using JDE as a source in these conditions is the same as using Oracle database as a source in an interface. The standard Oracle KMs can be used for this purpose.
Using JDE Z-Tables as a Target in an Integration Interface
After performing a reverse-engineering using the RKM JDE Enterprise One Oracle, you can use JDE Z- tables as a target of an interface to load data from any system to the JDE application with the IKM JDE Enterprise One Control Append (UBE).
Integrating Data into JDE with the IKM JDE Enterprise One Control Append (UBE)
The integration of data into JDE Enterprise One is performed in two steps: during the first step a set of Z- tables (staging table) is loaded, and during the second step the RunUBE command is launched to integrate the data from these Z-tables into JDE Enterprise One.
Knowledge Modules Reference Guide