Infor VISUAL Private AI Layer Blueprint Generator
This generator turns a few facts about your Infor VISUAL system into a written architecture plan for a private AI assistant that runs on your own infrastructure. It is meant for the first conversation between IT, the ERP owner and security.
Fill in
Infor VISUAL Private AI Layer Blueprint Generator
Context
Company: Acme Precision Ltd Infor VISUAL version: VISUAL 8.0 Database: SQL Server 2016 Hosting: On-prem server Named users: 90 across 2 site(s) GPU: None yet Target go-live: 2027-03-31
Purpose: add a private AI assistant to the existing Infor VISUAL system without moving data outside the site.
Use cases
Ask about open orders, work order status, stock and purchase delays; find drawings and certs; draft supplier follow-ups and quote text.
Data that must stay on site
Cost and pricing data, customer drawings under export control, employee data.
These classes are excluded from any external service. The model, retrieval index and logs run on On-prem server infrastructure only.
Components
| Component | Design for Infor VISUAL |
|---|---|
| Data access path | Read-only SQL reporting copy of the VISUAL database; VISUAL API Toolkit for approved writes |
| Retrieval index | Local embeddings over attachments, drawings and file shares with permission metadata |
| Model serving | Open-weight model on vLLM or Ollama on local GPUs |
| Tool server | MCP or tool server with named parameterised read actions |
| Identity and permissions | SSO to VISUAL user; site, entity and function security applied |
| Audit | Append-only log of prompt, tool call, query and answer |
Security controls mapped to your inputs
| Control | How it applies |
|---|---|
| Network | Hosting is On-prem server; the model server has no outbound internet route; only the tool server reaches Infor VISUAL (SQL Server 2016) |
| Data classes | Excluded or masked before indexing: Cost and pricing data, customer drawings under export control, employee data. |
| Access | SELECT-only service account, site and entity filters, cost data behind explicit grants, no free SQL |
| Scale | 90 named users across 2 site(s); capacity checked against the GPU position: None yet |
| Write-back | Disabled in phase 1; later only through supported Infor VISUAL interfaces with named-user approval |
Rollout
| Phase | Scope | Exit criterion |
|---|---|---|
| 1. Read-only questions | Named read actions and document search for the use cases above | Answers match Infor VISUAL screens on a test set, no cross-permission leaks |
| 2. Drafts | Assistant drafts emails, notes and change proposals for a user to review | Users accept most drafts with light edits; audit log reviewed |
| 3. Approved actions | Selected writes through supported interfaces after explicit approval | Zero unapproved writes; rollback tested; target go-live 2027-03-31 |
Open questions for IT
1. Which VISUAL version and database are in use, and is a replica possible? 2. Which sites or entities and cost-visibility rules must be mirrored? 3. Where do drawings and certs actually live? 4. Who owns the audit log and how long is it retained? 5. Which identity provider issues the user identity the tool server will use?
Approvals
This is a starting plan, not a design guarantee. Object names, endpoints and versions vary by installation; confirm them with your Infor VISUAL administrator before building. Sizing figures come from the companion calculator.
Review my Infor VISUAL AI blueprint
Optional: an engineer reviews your generated plan and flags gaps in permissions, sizing and rollout.
Optional. The tool and every export work without this. No spam.
How to use the generator
Fill in the company, Infor VISUAL version, database, hosting model, user and site counts, use cases, data that must stay on site, GPU position and target date. The document updates as you type and exports to PDF or Word for circulation.
- Be specific about use cases: lookups, document search and drafts are cheap, actions are not.
- List data classes, not systems, under what must stay on site.
- Choose air-gapped only if no component may reach the internet at runtime.
- Treat the open questions as the agenda for the first IT meeting.
What the plan contains
The plan lists six components for Infor VISUAL: data access path, retrieval index, model serving, tool server, identity and permissions, and audit. It maps security controls to your inputs and sets out a three-phase rollout from read-only questions to approved actions.
- Read-only first, writes later through supported interfaces only.
- One tool per approved read action, never free SQL from the model.
- Permissions mirrored from Infor VISUAL so the assistant cannot show more than the user could see.
How to read the result
Check that each component has an owner and that the rollout exit criteria are testable. If the GPU position is none, run the sizing calculator before ordering hardware. If your hosting is private cloud rather than on-prem, confirm contractually that the GPU nodes are single-tenant or logically isolated.
Common mistakes
Teams often start with write actions, skip the audit log, or give the assistant a service account that sees every site. Another frequent issue is forgetting documents: much of the value is in drawings, certs and procedures, not tables. This plan puts documents and permissions in the first phase on purpose.
Frequently Asked Questions
Does this plan require a cloud service?
No. All components can run on your own servers, including air-gapped, with open-weight models served locally. A private cloud option is available if you prefer to host there.
Is the plan specific to Infor VISUAL?
The components table and controls name Infor VISUAL access mechanisms and permission models. Version-specific object names must still be confirmed on your system.
Can I edit the document after export?
Yes. The Word export is editable, and you can change fields and re-export at any time. Nothing is sent anywhere; the tool runs in your browser.
How do I size the GPUs?
Use the companion sizing and value calculator, which estimates concurrent requests, tokens per day and GPU count from your user numbers and an assumed tokens-per-second figure.
If you would like a second pair of eyes on the plan for your Infor VISUAL environment, Netray builds private and air-gapped AI on top of ERP systems and can review it with you.
Related Tools
Infor VISUAL AI Assistant Sizing and Value Calculator
Size the GPUs and estimate the monthly value and payback of a private, on-prem AI assistant for Infor VISUAL.
On-Prem AIGPU Sizing Calculator for LLM Inference
Work out how many GPUs you need to serve a given open-weight model to your user base, based on memory footprint and token throughput.
On-Prem AIOn-Prem AI ROI Calculator
Turn hours saved per employee into annual net benefit, payback months, and 3-year ROI for an on-prem AI investment.
On-Prem AIOn-Prem AI Deployment Checklist
A 30-point pre-deployment checklist covering use cases, hardware, security, model operations, and rollout for self-hosted enterprise LLMs.
More Other ERPs tools
See all- Infor VISUAL Work Order Status and Structure Reference
- Infor VISUAL Manufacturing Scheduling Checklist
- Infor XA (MAPICS) Period End Close Checklist
- Infor VISUAL Database Table Reference
- Infor XA (MAPICS) Application Module Reference
- IBM i Commands for Infor XA Administrators Reference
- Acumatica Generic Inquiry Design Template
- Acumatica Manufacturing Edition Setup Checklist
- Sage X3 Import Template Worksheet
Keep exploring
Free tools
- Infor VISUAL AI Assistant Sizing and Value CalculatorSize the GPUs and estimate the monthly value and payback of a private, on-prem AI assistant for Infor VISUAL.
- Infor VISUAL Manufacturing Scheduling ChecklistA practical checklist for finding why VISUAL schedules do not match the floor: calendars, resource data, routings, lead times and release habits.
- Infor VISUAL Database Table ReferenceA searchable lookup of the main VISUAL Manufacturing tables, what each holds and the usual join keys, for report writers and analysts.
ERP fixes and how-tos
- Private AI Layer for Infor VISUAL On-Prem: Reference ArchitectureReference architecture to add a private AI assistant to Infor VISUAL on-prem: data access paths, retrieval, permissions, sizing and rollout, no cloud needed.
- Infor VISUAL report builder: build a custom work order reportHow to build and customise reports for Infor VISUAL using Crystal Reports and SQL, with a worked work order report example and the common tables involved.
- Infor VISUAL query tool and shop resource maintenanceHow to query Infor VISUAL data safely with SQL or the built-in query options, and how shop resources are defined and maintained for scheduling and costing.
Runs with your ERP
- 1 EDI Source EDI Integration with Infor VISUALHow 1 EDI Source connects Infor VISUAL to trading partners for EDI orders, invoices and ship notices via ION or direct API: setup, pitfalls and private AI.
- Infor VISUAL Shop Floor Mobile for Labor TrackingHow Infor VISUAL Shop Floor Mobile captures clock-ins and labor data from shop-floor devices directly into VISUAL: data flow, setup, pitfalls and private AI.
- VISUAL Time & Attendance and Infor VISUAL: labor, job costing and payrollHow VISUAL Time & Attendance captures clock-ins and job labor, feeds VISUAL job costing and exports earnings to payroll, with setup, pitfalls and AI ideas.
Integrations
- How to use ChatGPT with Infor VISUALHow to use ChatGPT with Infor VISUAL data: exports, custom GPT actions over a small API, enterprise data controls, and when a private model is the better fit.
- How to add an AI chatbot to Infor VISUALHow to build an AI chatbot on Infor VISUAL data for planners, buyers and customers, grounded in the SQL Server database and able to run fully on-prem.