Quick Summary

This support is provided for customers who have updated the Dynamic Planning application to ESM 2.0, which was released in November 2018, and is enabled by default for all new customers after April 2019.

In PCR, External Source Model is provided as a Load Item in Data Load Rules. When ESM is selected, all the ESMs are listed in the Load Sub-Item drop-down. These items are found in Maintenance, DLR, Data Load Rules.

This support is applicable to File, Web Services, and Copy/Paste Load Types. Existing Web Services APIs (Boomi), Clear Data, Load Data & Transfer Data are extended to External Source Models.

Data Integration User security for users and user groups is honored for ESM data load rules. If a user or group does not have access to a DLR, they will not see it in the grid.

ESM data loads support Comma & Dot for Thousand & Decimal separator, respectively.

The Number of Source Columns and their mappings are automatically updated in the Data Load Rule based on the external source model selected. A maximum of 100 columns can be loaded via Data Load Rule.

Formula and Constant type of fields are not included in the Data Load Rule because they are derived automatically during the data load.

A maximum of 4000 characters are allowed on each field when loaded via Data Load Rule.

You can also use the Include in Clear Data functionality with External Source Models. You can choose include or exclude specific fields and, based on the clear data definition, any existing data in the model is cleared prior to loading the updated data.

The Data Load History is updated at the conclusion of the data load. Select Maintenance > Audit > Data Load History.