# MachineMetrics Connector for Infor VISUAL

> Source: https://netray.co/stack/machinemetrics-infor-visual-connector
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Stack

## Short answer

The MachineMetrics Infor VISUAL connector sends active work orders, employees and operations to operator tablets, then writes labor tickets and work order progress back to VISUAL. It uses an edge device with a direct SQL Server connection through a dedicated VISUAL user.

## Erp

Infor VISUAL

## Erp Key

infor-visual

## On Prem

true

## Product

MachineMetrics Infor VISUAL Connector

## Vendor

MachineMetrics

## Category

Labor tracking and machine monitoring

## Integration

**Method:** Edge device with direct SQL Server connection

**Detail:** Per MachineMetrics documentation, an edge device on your network connects to the VISUAL SQL Server database using a dedicated user. It reads open work orders, employees and operations, and writes labor tickets and progress. Because it is direct database access rather than an Infor API, permissions and upgrades need careful handling.

## Data Flows

**From:** Infor VISUAL

**To:** MachineMetrics

**Data:** Active work orders, employees and operations

**Trigger:** Periodic sync from the edge device

**From:** MachineMetrics operator tablet

**To:** Infor VISUAL

**Data:** Labor tickets

**Trigger:** Operator starts or stops an operation

**From:** MachineMetrics

**To:** Infor VISUAL

**Data:** Work order progress such as quantities completed

**Trigger:** Operator or machine data update

## Setup

### Review the connector documentation

**Detail:** Read the MachineMetrics Infor VISUAL connector page and note the required SQL permissions and version support.

### Create a dedicated SQL user

**Detail:** Make a VISUAL user for the edge device with only the access the connector needs.

### Place the edge device

**Detail:** Install it on a network segment that can reach the SQL Server and the plant machines.

### Map machines to resources

**Detail:** Link each machine in MachineMetrics to the correct VISUAL resource or work center.

### Test labor writes in a test database

**Detail:** Confirm labor tickets and progress post correctly before touching production.

### Train operators

**Detail:** Show operators how to select jobs and operations on the tablet.

### Monitor after go-live

**Detail:** Reconcile labor tickets against shift reports for the first weeks.

## Pitfalls

- Direct database writes bypass some ERP business logic, so test posted results carefully, including costing.
- A VISUAL upgrade that changes the schema can break the connector, so test the new version first.
- An overly privileged SQL user is a security risk, and an underprivileged one causes silent failures.
- Operators select the wrong operation, which then appears as actual labor on the wrong routing step.
- Network loss between the edge device and SQL Server delays writes and can cause duplicates on retry.

## Ai Layer

### Labor ticket validation

**Description:** A private assistant compares machine run data with VISUAL labor tickets and flags tickets that disagree with machine activity, for a supervisor to review.

### Progress reconciliation

**Description:** Check work order quantities reported by tablets against VISUAL inventory and shipment transactions.

### Plain-language downtime questions

**Description:** Let planners ask why a job ran late and get an answer drawn from machine data and work order history on your own servers.

## Alternatives

- Infor VISUAL Shop Floor Mobile is a native option for labor capture if you do not need machine monitoring.
- Manual labor entry by supervisors is workable for low volumes, with less accurate data.
- Another MES or monitoring product with an API-based VISUAL integration may avoid direct database access.

## Faq

### How does the connector talk to VISUAL?

**Answer:** MachineMetrics documents an edge device with a direct SQL Server database connection using a dedicated VISUAL user. It reads work orders, employees and operations and writes labor tickets and progress.

### Is it an Infor-certified integration?

**Answer:** Our source is the MachineMetrics documentation page, and it describes direct SQL access. Do not assume Infor certification, and ask both vendors about support for your version.

### Does it suit on-prem VISUAL?

**Answer:** Yes in principle, since the edge device sits on your network next to the SQL Server. Plan network access and security with your IT team.

### What can AI do alongside it?

**Answer:** A model on your own hardware can reconcile machine data with labor tickets and flag anomalies. Any correction to VISUAL should be proposed for a person to approve.

## Source

https://docs.machinemetrics.com/docs/integrations/erp-connectors/infor-visual-connector

## Search terms

machinemetrics infor visual labor ticket integration, machinemetrics visual connector, infor visual machine monitoring, visual erp operator tablet, infor visual sql server integration

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