Table 3-4 RunUBE Command Related KM Options Option Set the standard KM options (INSERT, COMMIT, FLOW_CONTROL). In the Flow tab, select the IKM JDE EnterpriseOne Control Append (UBE). The capability to load the Z-Tables and the call of the RunUBE command is provided by the IKM JDE EnterpriseOne Control Append (UBE).Ĭreate a mapping with Z-tables as target datastores.Ĭreate joins, filters, and mappings as usual.
The RunUBE call should be activated in the IKM only after loading all the required Z-table for populating JDE. Oracle Data Integrator can automatically call the RunUBE command to write to JDE. These mappings should be sequenced in a package. This mapping also uses the IKM JDE EnterpriseOne Control Append (UBE) with the JDE_RUNUBE option set to Yes. This is typically done in the mapping loading the last required Z-table. These mappings can use the IKM JDE EnterpriseOne Control Append (UBE) with the JDE_RUNUBE option set to No.ĭuring the second phase, the RunUBE command is launched to integrate the data from these Z-tables into JDE EnterpriseOne. The integration of data into JDE EnterpriseOne is performed in two phases:ĭuring the first phase, data is integrated into a set of Z-tables using several mappings, without calling the RunUBE command. The KM performs integration into JDE EnterpriseOne with a RunUBE batch commandĪfter performing a reverse-engineering using the RKM JDE EnterpriseOne, 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). Integrates data in EnterpriseOne Z-table in control append mode.ĭata can be controlled: invalid data is isolated in the Error Table and can be recycled Integrates data from any source to JDE EnterpriseOne. IKM JDE EnterpriseOne Control Append (UBE) Reverse-engineers the metadata of the applications’ objects such as tables and interface tables from JDE EnterpriseOne installed on IBM DB2 for iSeries server. Reverse-engineers the metadata of the applications’ objects such as tables and interface tables from JDE EnterpriseOne installed on IBM DB2 UDB database. Reverse-engineers the metadata of the applications’ objects such as tables and interface tables from JDE EnterpriseOne installed on SQL Server. Reverse-engineers the metadata of the applications’ objects such as tables and interface tables from JDE EnterpriseOne installed on an Oracle database. Table 3-1 JDE Knowledge Modules Knowledge Module