Initial Load via Events

The initial load via event functionality is used to send the first instance of an M3 BE dataset to an external application using events.

This document describes how to set up and execute this initial load.

Limitations

  • A maximum of 10 selection fields from the primary table can be included in the initial load data.
  • It is not possible to use a key field as a selection field.
  • Data from related tables is not included in the initial load event. These are only used to refine the selection criteria defined for the primary table.

Set up the initial load

  1. Open 'Initial Load Event. Open' (EVS008).
  2. Specify this information:
    1. Primary table from which data should be sent.
    2. Required fields from the primary table, up to a maximum of 10 fields.
  3. Optionally specify if related tables should be used in the selection, up to a maximum of 3 related tables.
    1. If related tables are included, specify the required fields. Note that data from the related tables is not included in the initial load dataset. Related tables are only used to refine the selection criteria defined for the primary table.

Execute or simulate the initial load

  1. To execute the initial load in (EVS008), select related option 11='Run' to open 'Initial Load Event Jobs. Open' (EVS009). If the initial load should be simulated, meaning that no events will be generated, select related option 13='Simulate' instead. The tables and fields for the event name specified in (EVS008) are then listed.
  2. Specify whether the event is REQUEST (default) or a START event, this is done through the Data Lake load parameter on the E-panel.
  3. Specify the filter criteria for the preselected tables and fields using these options:
    • Blank value = only a record containing a blank value for the field will be included.
    • Specific values = a specific value or a comma separated list can be added. Records containing any of the specified values for the field will be included.
    • Range = any records within the range for the field will be included.
    • Ignored = the field is not included.
  4. Click submit to execute the load.

Execute using an existing Event name

  1. Open (EVS008).
  2. Select the required Event name from the list displayed and choose related option 11='Run' to open (EVS009).
  3. Verify that the selection criteria listed satisfies requirements.
  4. Click submit to execute the load.

View initial load event job history

Status and run details for initial loads that are already executed can be viewed in 'Initial Load Event Jobs. Open' (EVS009). (EVS009) can be opened by selecting related option 12='History' in (EVS008). Information such as number of records processed, start time, end time, and selection criteria used is displayed.

It is also possible to create new initial load runs from (EVS009). If initial load with exactly same selection from a previous run, copy the previous run and select if the run is a simulation or not. If new selections are needed, create a new run, select if the run is a simulation in 'Simulation' check box and select the selection as normal.

Related topics