Initial Data Load from M3 to ION

Question

Sending the initial data load

During normal processing, BODs are published when a user changes data or completes a transaction. However, when you start a new integration with another application, you must manually generate BODs that pass the current set of data from M3 to the other application, so that the base systems are synchronized. The BODs are placed in the message outbox, from which Infor ION retrieves them and passes them to the other application.

To perform the initial load of M3 data into the BODs that are placed in the message outbox:

1 Take note of the name of the master table for the applicable BOD. See Master tables for initial load on page 111.
2 In M3, open ‘Initial Load.Start’ (EVS005). If Smart Office is used, then specify MFORMS://EVS005, else specify EVS005. The H5 client is the assumed user interface.
3 In Table, specify the master table name, for example MITMAS, to trigger M3BE_Out_ShowItemMaster.
4 In Division, specify the division of the events if applicable. Note that the Division parameter only works if the Division field (DIVI) is a field in the primary key of the table that is specified inTable.
5 Optionally, in From date and To date, specify the registration date range for the data that is to be triggered. Note: The initial loading for large tables takes a long time. You should run only one table a time. You must ensure that there are sufficient resources available in the system at the time of the initial load.
6 Leave the Max no. lines, Search query and Key field fields blank. They are not applicable when sending initial data. Click Next.

Note: For testing purposes, you can limit the number of lines. In the live initial-load scenario, leave the field blank to obtain the full amount of data. The M3BE_Out_Show[Noun Mapping] BOD is triggered. After the initial data load, M3 sends BOD updates when users change certain data or when certain transactions occur in M3.

For a list of the events that generate BODs, see Business events that generate outbound BODs on page 94.

Reference:

Infor M3 Configuration Guide for Infor Operating Service - M3 Business Engine BODs 15.5.0.0

M3 Content Pack for Infor OS and M3 Integrations 4.0

Infor OS 12.x

billy · Answer 1 · 2020-09-04T19:15:55+0000

answered Sep 4, 2020 by billy (13.3k points)

Sending the initial data load

During normal processing, BODs are published when a user changes data or completes a transaction. However, when you start a new integration with another application, you must manually generate BODs that pass the current set of data from M3 to the other application, so that the base systems are synchronized. The BODs are placed in the message outbox, from which Infor ION retrieves them and passes them to the other application.

To perform the initial load of M3 data into the BODs that are placed in the message outbox:

1 Take note of the name of the master table for the applicable BOD. See Master tables for initial load on page 111.
2 In M3, open ‘Initial Load.Start’ (EVS005). If Smart Office is used, then specify MFORMS://EVS005, else specify EVS005. The H5 client is the assumed user interface.
3 In Table, specify the master table name, for example MITMAS, to trigger M3BE_Out_ShowItemMaster.
4 In Division, specify the division of the events if applicable. Note that the Division parameter only works if the Division field (DIVI) is a field in the primary key of the table that is specified inTable.
5 Optionally, in From date and To date, specify the registration date range for the data that is to be triggered. Note: The initial loading for large tables takes a long time. You should run only one table a time. You must ensure that there are sufficient resources available in the system at the time of the initial load.
6 Leave the Max no. lines, Search query and Key field fields blank. They are not applicable when sending initial data. Click Next.

Note: For testing purposes, you can limit the number of lines. In the live initial-load scenario, leave the field blank to obtain the full amount of data. The M3BE_Out_Show[Noun Mapping] BOD is triggered. After the initial data load, M3 sends BOD updates when users change certain data or when certain transactions occur in M3.

For a list of the events that generate BODs, see Business events that generate outbound BODs on page 94.

Reference:

Infor M3 Configuration Guide for Infor Operating Service - M3 Business Engine BODs 15.5.0.0

M3 Content Pack for Infor OS and M3 Integrations 4.0

Infor OS 12.x

Initial Data Load from M3 to ION

Your comment on this question:

Your answer

1 Answer

Your comment on this answer:

Most popular tags