Integration Use case between Dynamics ERP And CPQ BOM Item Definition

Summary:

We need to integrate products between Dynamics ERP and CPQ. We are using OIC to orchestrate this integration, but we were wondering if there are any success use cases in the industry regarding this particular integration.

The main challenge we are having is that Dynamics has a webservice named BillOfMaterialsLinesV2 where they list the BOM definition in a relationship stated by three fields:

BOMId - The primary key that groups all children that are directly part of a BOM branch. It is closely related to CPQ's Parent Variable Name

ItemNumber - The ID of a particular product

SubBOMId - a pointer that, when present, signals that a particular row has child elements to be found, by searching to the BOMId that is equal to the SubBomId.