# Dynamics AX 2012 Private AI Layer Blueprint Generator

> Source: https://netray.co/tools/dynamics-ax-2012-private-ai-layer-blueprint-generator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Fill in your AX 2012 environment and get an architecture plan for a private AI assistant, with components, controls, a 3-phase rollout and open questions for IT.

## Category

on-prem-ai

## Erp

Microsoft Dynamics AX 2012

## Audience

- CIO
- IT manager
- ERP architect
- AX administrator

## Tool

**Kind:** template

**Output:** document

**Fields:**

#### Company name

**Key:** company

**Type:** text

**Default:** Northfield Precision Ltd

#### AX version

**Key:** version

**Type:** select

**Options:**

- AX 2012 RTM
- AX 2012 R2
- AX 2012 R3

**Default:** AX 2012 R3

#### Database engine

**Key:** db

**Type:** select

**Options:**

- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017 or later

**Default:** SQL Server 2016

#### Hosting

**Key:** hosting

**Type:** select

**Options:**

- On-prem server
- Private cloud
- Air-gapped

**Default:** On-prem server

#### Named users

**Key:** users

**Type:** number

**Default:** 180

#### Legal entities or plants

**Key:** sites

**Type:** number

**Default:** 4

#### Main use cases

**Key:** usecases

**Type:** textarea

**Default:** Open sales order status, item availability by warehouse, vendor delivery history, search of quality documents and work instructions.

#### Data that must never leave the site

**Key:** neverleave

**Type:** textarea

**Default:** Customer pricing, bills of material, defence program data, bank details.

#### GPU available

**Key:** gpu

**Type:** select

**Options:**

- None yet
- One 24 GB class GPU
- One 48 to 80 GB class GPU
- Two or more GPUs

**Default:** One 48 to 80 GB class GPU

#### Target go-live

**Key:** golive

**Type:** text

**Default:** Q2 2027

**Blocks:**

#### Private AI Layer Blueprint: {{company}}

**Body:** System: Dynamics {{version}} on {{db}}, hosting: {{hosting}}.
Scale: {{users}} named users across {{sites}} legal entities or plants.
Target go-live: {{golive}}.

#### Context and use cases

**Body:** {{usecases}}

Objective: give users natural-language access to AX 2012 data and documents without moving data outside {{company}} infrastructure.

#### Components

**Table:**

**Columns:**

- Component
- Design for {{company}}
- Notes

**Rows:**

**0:** Data access path

**1:** Read-only SQL replica of the AX business database, curated views by SELECT-only login; AIF and X++ services for logic-bound reads

**2:** Include DATAAREAID and PARTITION in all joins

**0:** Metadata map

**1:** SQLDICTIONARY table and field names, enum integer to label map, legal entity list

**2:** Test the enum map on status fields

**0:** Retrieval index

**1:** Attachments (DocuRef, DocuValue), item text, work instructions, SSRS report text

**2:** Incremental refresh from the replica

**0:** Model serving

**1:** Open-weight model on vLLM or Ollama, GPU: {{gpu}}

**2:** Size from users and questions per day

**0:** Tool server

**1:** MCP server exposing named read actions with parameter validation and row limits

**2:** No free-form SQL from the model

**0:** Identity and permissions

**1:** Map Windows user to AX user, read security roles and legal entities, apply as filters

**2:** Re-check XDS policy tables

**0:** Audit

**1:** Log user, question, tool calls, queries and answers locally

**2:** Retain per your policy

#### Security controls mapped to your inputs

**Table:**

**Columns:**

- Requirement
- Control

**Rows:**

**0:** Never leaves site: {{neverleave}}

**1:** Inference and index run inside the {{hosting}} boundary; no external API calls; egress blocked at the firewall

**0:** Least privilege

**1:** Assistant SQL login limited to curated views; no write rights to AX tables

**0:** Role fidelity

**1:** AX roles and legal entities enforced in every tool call

**0:** Write-back

**1:** Drafts only, human approval, posted through AIF or X++ services

**0:** Traceability

**1:** Every answer links to the query or service call behind it

#### Three-phase rollout

**Table:**

**Columns:**

- Phase
- Scope
- Exit criteria

**Rows:**

**0:** 1. Read-only questions

**1:** 10 to 20 pilot users, curated views, document search

**2:** Accuracy on a 50-question test set agreed with business owners

**0:** 2. Drafts

**1:** Assistant drafts purchase requisitions, notes and summaries for review

**2:** Reviewers accept most drafts without rework

**0:** 3. Approved actions

**1:** A short list of actions through AX services with approval

**2:** Audit log reviewed by IT and finance

#### Open questions for IT

**Body:** 1. Can a readable SQL secondary or restored copy be provided, and how fresh must it be?
2. Which AOS service accounts and AIF ports can the tool server use?
3. Are XDS policies in use on tables the assistant will read?
4. Where are attachments stored (database or file share)?
5. What is the AX retirement or upgrade timeline, so views can be designed to be repointed?
6. Who owns model updates, evaluation and patching after go-live?

**Signatures:**

- Prepared by
- IT architect
- Business owner
- Security reviewer

**Notes:** A starting plan, not a design guarantee. Confirm table names, services and security behaviour against your own AX 2012 build and customisations before implementation.

## Content

**Intro:** This generator turns your AX 2012 facts into a blueprint you can hand to IT, security and the business. It covers data access, retrieval, model serving, permissions, audit and a phased rollout for an assistant that runs entirely on your own servers.

**Sections:**

#### How to use the generator

**Body:** Fill in the version, database engine, hosting model, user and legal entity counts, and the use cases you want first. List the data that must never leave the site in plain words; the security table repeats it so reviewers see the link between requirement and control. Export to PDF or Word and circulate the draft before any hardware is ordered.

**Bullets:**

- Be specific in the use cases field
- Name the data classes that are restricted
- Pick the GPU option you actually have
- Review the open questions with your DBA

#### The design behind the plan

**Body:** The pattern is a read-only replica, curated SQL views, AIF and X++ services where business logic matters, a local retrieval index, a tool server that exposes only approved read actions, and an open-weight model on local GPUs. It is chosen because AX 2012 stores everything in one SQL Server database with legal entity and partition columns, and because AX security is role based with optional record-level policies.

#### Common mistakes

**Body:** Teams often point the assistant at the production database, skip DATAAREAID in joins, or give the model raw enum integers. Another frequent error is to plan write-back first. The blueprint puts read-only answers first, drafts second and actions last, because accuracy and permission fidelity must be proven before anything is posted.

**Cta:** If you want a second opinion on this plan or help building it on your AX 2012 estate, Netray can review the blueprint with your IT team.

**Faq:**

#### Is this tool tied to any vendor?

**Answer:** No. It produces a generic, vendor-neutral architecture plan that you can adapt. Nothing is sent anywhere; the document is built in your browser.

#### Can I use it for an air-gapped site?

**Answer:** Yes. Choose air-gapped hosting and the plan keeps inference, index and logs inside the boundary, with a note about controlled transfer for model files.

#### Does it cover Dynamics 365?

**Answer:** No. It is specific to AX 2012 data paths. The principles apply elsewhere, but table names and services differ.

#### How accurate are the component details?

**Answer:** They reflect common AX 2012 structures. Always verify against your build, customisations and security setup before relying on them.

## Search terms

AX 2012 AI architecture, Dynamics AX 2012 AI plan template, AX 2012 private LLM blueprint, on-prem AI architecture document, AX 2012 AIF AI integration, air-gapped Dynamics AX AI, AX 2012 retrieval index design

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json