Warehouse NAV Inbound Interface

Owned by Natalie Gesin (Deactivated)
Last updated: Sept 29, 2020 by Dmitry Donosiyan (Unlicensed)
1 min read

Overview

Warehouse NAV interface allows to load and update data in the following database table:

HOLDINGDBO.NAV

Stream Logic

EagleML Processing Sequence

Warehouse NAV is loaded into DB via eagle_ml-2-0_default_in_xml_warehouse_preproc in two steps:

  • XSLT transformation. XSLT rule 'eagle_default/in/xml/xslt/wrh_egl_gen_interface3.xsl' is used.
  • Loading data into the database. The 'eagle_default/in/xml/xml-warehouse_v2.xml' rule is used.

To load or update data in Warehouse NAV database tables send an EagleML message into the eagle_ml-2-0_default_in_xml_warehouse_preproc stream.

Required Elements

The following elements are required in the EagleML message:

  • Effective Date: EagleML-2-0/WarehouseTransactionMessage/WarehouseNAV/effectiveDate. Mapped to HOLDINGDBO.NAV.EFFECTIVE_DATE
  • Entity Id: EagleML-2-0/WarehouseTransactionMessage/WarehouseNAV/entityId. Mapped to HOLDINGDBO.NAV.ENTITY_ID
  • Class Level: EagleML-2-0/WarehouseTransactionMessage/WarehouseNAV/classLevel. Mapped to OLDINGDBO.NAV.CLASS_LEVEL
  • Source Name: EagleML-2-0/WarehouseTransactionMessage/WarehouseNAV/sourceName. Mapped to PACE_MASTERDBO.INTERFACES.SHORT_DESC

Security Resolution Logic

<securityAlias> should not be specified in the incoming EagleML message.

Refer to Security Resolution for Warehouse Objects

Entity Resolution Logic

Refer to Entity Resolution for Warehouse Objects