Technologies

The Microsoft ERP ecosystem, from the database up

Dynamics 365 Finance & Operations sits at the centre of a wider platform — X++ and .NET for code, SQL underneath, Azure and APIs for integration, Power BI for analytics and Power Platform for automation. This is how we use each of them.

01 · ERP platform

ERP platform

The core of everything we do. We work on Microsoft's enterprise ERP from the database up, across the Dynamics AX and Dynamics 365 generations.

Dynamics 365 Finance & Operations

Microsoft's cloud ERP for finance, supply chain, manufacturing and projects.

Finance, Supply Chain Management, Project Operations and the shared application platform underneath them. Delivered as a Microsoft-operated cloud service with continuous service updates, so customisations have to be built as extensions that survive every update.

  • Finance
  • Supply Chain Management
  • Project Operations
  • Service updates
  • Environments & ALM

Used in D365 F&O Solution Architecture ERP Implementation & Configuration Support & Managed Services

Dynamics AX

The on-premises predecessor — AX 2009 and AX 2012 — still running in many businesses.

Years of AX work mean we read legacy overlayered code, data models and batch setups fluently. That matters when you are stabilising an AX 2012 estate, or planning the move to D365 F&O where overlayering must be replaced by extensions and data has to be upgraded.

  • AX 2009
  • AX 2012 R3
  • Overlayering → extensions
  • Data upgrade

Used in Digital Transformation Consulting Custom Software Development

02 · Engineering

Engineering

Where functional requirements turn into code. Good X++ and good SQL are the difference between an ERP that scales and one that slows down every month-end.

X++

The platform language for extensions, business logic, services and batch processing.

Chain of Command and event-handler extensions, data entities, SysOperation batch services, custom services and workflow. We write set-based X++ (insert_recordset, update_recordset), design caching deliberately and keep business logic out of form code.

  • Chain of Command
  • SysOperation framework
  • Data entities
  • Custom services
  • Best-practice checks

Used in Custom Software Development Performance Optimization

.NET / C#

Libraries, Azure Functions and services that sit next to the ERP.

C# libraries referenced from X++, Azure Functions for integration logic, and supporting tools such as file processors or API adapters — kept small, testable and deployed through the same pipeline discipline as the ERP code.

  • C# class libraries
  • Azure Functions
  • API adapters
  • Unit testing

Used in Custom Software Development Integration & API Development

SQL Server & Azure SQL

The database underneath every form, report and batch job.

Query plans, index design in the application metadata, statistics, blocking and data volume. In the cloud the production database runs on Azure SQL, so analysis works through the platform's performance tooling and query history rather than direct production access.

  • Query plans
  • Index design
  • Blocking & locking
  • Data volume & cleanup

Used in Performance Optimization Power BI & Business Intelligence

03 · Cloud & integration

Cloud & integration

No ERP runs alone. Integrations decide whether orders, invoices and master data move reliably between D365 F&O and the rest of the business.

Microsoft Azure

Integration and hosting services around the ERP.

Logic Apps, Functions, Service Bus and API Management for integration; Key Vault for secrets; storage and data services for exports and analytics; Azure DevOps for source control, builds and release pipelines.

  • Logic Apps
  • Service Bus
  • Functions
  • API Management
  • Azure DevOps

Used in Integration & API Development D365 F&O Solution Architecture

APIs & integration patterns

OData, custom services, business events and recurring integrations.

Choosing the right pattern per flow: OData for transactional reads and writes, custom services for logic-heavy calls, business events for outbound notifications, and recurring data-management jobs for high-volume batch exchange — with retries, idempotency and monitoring designed in.

  • OData
  • Custom services
  • Business events
  • Recurring integrations
  • Dual-write

Used in Integration & API Development

Data entities

The contract layer for imports, exports, integrations and migration.

Standard and custom entities for the data management framework, OData and Excel. Entity design affects throughput directly — set-based processing, staging validation and sensible field mapping matter as much as the business rules.

  • Data management framework
  • Custom entities
  • Data migration
  • Staging & validation

Used in Integration & API Development ERP Implementation & Configuration

04 · Analytics

Analytics

Reporting is where ERP data quality becomes visible. We build analytics on top of a data path that is designed, not improvised.

Power BI

Semantic models, dashboards and embedded analytics on F&O data.

Semantic models and DAX measures over finance, supply chain and project data; row-level security aligned with ERP roles; and a deliberate choice of data path — exports to a data lake or Microsoft Fabric rather than ad-hoc queries against the transactional system.

  • Semantic models
  • DAX
  • Row-level security
  • Data lake / Fabric
  • Embedded workspaces

Used in Power BI & Business Intelligence

05 · Automation

Automation

Low-code works best for the edges of the process — approvals, notifications and focused apps — while the ERP stays the system of record.

Power Apps

Focused apps on Dataverse, connected to D365 F&O.

Canvas and model-driven apps for scenarios the ERP client does not serve well — field data capture, simple requests, mobile checklists — connected through the F&O connector, virtual tables or dual-write, depending on the data and latency involved.

  • Canvas apps
  • Model-driven apps
  • Dataverse
  • Virtual tables

Used in Power Platform Applications

Power Automate

Approvals, notifications and event-driven flows.

Flows triggered by D365 F&O business events or schedules: approvals, notifications, document routing and hand-offs to other systems — with error handling and ownership defined so flows do not become invisible production dependencies.

  • Business-event triggers
  • Approvals
  • Notifications
  • Governance

Used in Power Platform Applications Integration & API Development

Not sure which technology a requirement needs?

That is often the most valuable question to ask before building anything. Describe the requirement and we will tell you how we would approach it on D365 F&O — and what we would avoid.