Skip to main content
Bucherer

Automated master data synchronisation between legacy ERP and D365 F&O

For Bucherer, CONSENSO TECH developed automated data pipelines with Apache NiFi to synchronise master data daily between the existing legacy system and Microsoft Dynamics 365 F&O. The solution supports international parallel operation, where some legal entities already work in D365 while others continue to be run in the legacy system.

At a glance

Starting point

  • Global parallel operation of the legacy system and Microsoft Dynamics 365 F&O
  • Differing rollout stages per country / legal entity
  • A need for consistent master data across several system worlds
  • Recurring daily data transfers
  • Existing SQL migration logic had to be operationalised
  • Complex target structures and import logic in D365 F&O

Solution

  • Construction of automated data pipelines with Apache NiFi
  • Querying of the legacy database
  • Reuse of existing SQL migration logic
  • Transformation of the data into D365-compatible structures
  • Transfer via the OData batch API of Microsoft Dynamics 365 F&O
  • Structured, repeatable and traceable synchronisation runs

Result

  • Consistent master data throughout the international ERP rollout
  • Support for parallel operation of legacy ERP and D365 F&O
  • Automated daily data migrations
  • Reduced manual data transfers
  • Greater stability and traceability of the data flows
  • Reusable pipeline structures for further migration work

As part of Bucherer's global ERP transformation, some countries and legal entities were already running on Microsoft Dynamics 365 F&O while other companies continued to work in the existing legacy system. This created the challenge of keeping core master data consistent across both system worlds.

CONSENSO TECH supported Bucherer in building automated data pipelines with Apache NiFi. The solution queries the legacy system, uses existing SQL migration logic, transforms the data into D365-compatible structures and transfers it to Microsoft Dynamics 365 F&O via the OData batch API.

The data synchronised covered ERP-relevant master data in particular, such as customers, suppliers, products and product attributes. This allowed Bucherer to support the phased international rollout of D365 F&O without interrupting day-to-day operations in the companies not yet migrated. The automated pipelines reduced manual migration steps and made recurring data transfers more stable, more controllable and more traceable.