Overview of the Project
A lift-and-shift would move the complexity, however manual translation meant slowing the speed of change. Hunter and Xoriant chose a more intelligent path — using Microsoft Fabric to unify the foundation, Claude to accelerate analysis and transformation, and human experts to validate the meaning behind every critical output.
About Hunter Industries
Hunter Industries is a global manufacturer of irrigation and outdoor lighting solutions, supporting customers across markets worldwide. As part of its data modernization journey, the organization sought to establish a unified foundation for OpEx reporting across JD Edwards and Oracle Fusion, leveraging Microsoft Fabric and Power BI as its target analytics platform. The key challenge was to modernize its reporting ecosystem while preserving the business logic, data accuracy, and continuity that stakeholders depended on for informed decision-making.
Two ERPs, one trusted view — without breaking what already worked
Operating expenses reporting depended on JD Edwards data, SSAS cubes, and SQL-based logic. With Oracle Fusion entering the landscape, both ERP environments had to work as one without breaking the Power BI experience or the rules behind it. Key requirements included:
One Trusted View
Bring JD Edwards and Oracle Fusion data together.
Reporting Continuity
Keep existing OpEx reports working as expected.
Scalable Architecture
Create a governed Fabric architecture to scale beyond use case.
Business Logic Intact
Carry SSAS and SQL rules into the new foundation.
Quality by Design
Reconcile data, calculations, and report outputs.
The right expertise for an AI-assisted transformation
Hunter required a unified data model for OpEx reporting, dimensional modelling, historical handling, currency conversion, and row-level security alignment:
Microsoft Fabric Unified Platform
OneLake, pipelines, notebooks, Lakehouse, semantic models, and Power BI provided an integrated modernization foundation.
AI-Assisted Engineering
Claude with the Microsoft Fabric MCP Server supported iterative analysis, validation, and transformation of legacy logic.
Xoriant Data Expertise
Data engineering, dimensional modelling, Power BI, and migration capabilities combined in one delivery approach.
Quality Assurance
Validated data, calculations, and report parity through reconciliation and iterative refinement.
A structured migration approach, with AI in the loop
Combining Microsoft Fabric expertise with AI-assisted engineering, Xoriant delivered a structured migration approach for modernizing Hunter's legacy analytics assets and supporting the ERP transition.
Connect Both ERP Worlds
Built metadata-driven incremental pipelines for JD Edwards and Oracle Fusion, with data validation, reconciliation, logging, and error handling.
Translate Logic with AI in the Loop
Used Claude and the Fabric MCP Server to analyze SSAS and SQL logic. Xoriant engineers validated the rules before implementing Fabric notebooks.
Engineer for Reuse with Medallion
Structured data processing across Bronze, Silver, and Gold layers, supporting dimensional modelling, historical handling, currency logic, and reusable transformations.
Protect Governance with Power BI
Reconnected the OpEx report to the new semantic model while preserving functional and data parity, Microsoft Entra access, and row-level security.
Faster modernization, without trading away accuracy
Hunter proved that faster modernization need not trade away accuracy, continuity, or governance:
Development Effort — Claude assisted analysis, validation, and transformation across refinement cycles.
Anomalies — automated anomaly detection reduced failures substantially.
ERP Analytics — harmonized JD Edwards and Oracle Fusion data for OpEx reporting.
and Maintainable Platform — layered architecture improved separation, reuse and maintainability.
Legacy Transformation — AI-assisted analysis streamlined conversion of SSAS and SQL logic.
Business Accuracy — iterative validation preserved analytical requirements and report parity.
Human judgment kept the transformation true. Applied AI with Microsoft Fabric helped it move further and faster, giving Hunter a foundation for what comes next.
"Xoriant's use of Claude during our data platform modernization POC for the Operational Expenses use case helped accelerate the migration of legacy analytics assets while maintaining business accuracy and quality. AI-assisted development approach enabled faster delivery, improved productivity, and demonstrated a scalable, maintainable path for modernizing our OpEx analytics on Microsoft Fabric."
Ruslan Bikkulov Principal Data and Analytics Architect, Hunter Industries