Skip to main content
CONSENSO
Bucherer

Automated data migration from Oracle legacy ERP to Microsoft Dynamics 365 F&O

For Bucherer, CONSENSO TECH supported the migration of core master data from an Oracle-based legacy ERP database to Microsoft Dynamics 365 F&O. Extensive SQL migration scripts were developed, legacy data was cleansed, and the existing data structures were conceptually mapped onto the new D365 data model.

Back to case studies

At a glance

Starting point

  • Migration from an Oracle-based legacy ERP database
  • Complex mapping onto Microsoft Dynamics 365 F&O
  • Data structures grown over time, with data quality issues
  • Migration of various master data objects such as customers, suppliers, products and product attributes
  • A need for repeatable, controllable migration runs

Solution

  • Development of extensive SQL migration scripts
  • Extraction and transformation of legacy data
  • Conceptual mapping onto the D365 F&O data model
  • Integration of data cleansing steps into the migration process
  • Structured preparation of the data for import into D365 F&O
  • Alignment between business departments, data model and technical implementation

Result

  • Repeatable and controllable data migration
  • Improved data quality ahead of import into the target system
  • Reduced manual migration effort
  • A clear mapping between the legacy data structure and the D365 F&O target model
  • A stable foundation for the global ERP rollout

As part of Bucherer's global ERP transformation, core master data had to be transferred from the existing Oracle-based legacy system to Microsoft Dynamics 365 F&O. The challenge lay not only in the technical extraction of the data, but above all in the conceptual mapping between legacy structures grown over many years and the target model of D365 F&O.

CONSENSO TECH supported Bucherer in building extensive SQL migration scripts to extract data from the Oracle database, transform it and prepare it for migration. Data quality and cleansing concerns were integrated directly into the migration process.

The focus included customers, suppliers, products, product attributes and further ERP-relevant master data. By closely connecting the technical implementation with business-led conceptual data modelling, the migration could be built in a structured, traceable and repeatable way.

More case studies

Bucherer

Product Master Data Suite for Bucherer

View case study
Bucherer

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

View case study
DentaCore

Azure data platform with Databricks lakehouse and Power BI

View case study