Systems it reads

The systems you already run, read where they are

VERUS connects with a read-only login your team creates, one per system. It has no way to write, and every statement it sends is checked to be a single plain read first.

Three ways in

A read-only database login

SQL Server, which most on-premises ERPs run on (Dynamics AX, Epicor, SYSPRO and many others), PostgreSQL, MySQL and MariaDB, Oracle, IBM Db2 including IBM i (AS/400), and cloud warehouses: Snowflake, BigQuery, Redshift, Databricks, Azure Synapse and Microsoft Fabric.

A vendor's web service, through a read-only API user

Cloud HR, CRM, maintenance and ERP products, for example ADP Workforce Now, Paycom, UKG Pro, Workday, Salesforce, HubSpot, Dynamics 365 Sales, Zoho CRM, IBM Maximo, Limble, UpKeep, eMaint and Dynamics 365 Business Central.

Files

CSV and Excel exports from a folder, an SFTP server or a network share, read-only. Plans and budgets come in the same way.

A system not named here is usually still readable through one of these three. Product names are the trademarks of their owners and are named only to describe the systems VERUS can read; no endorsement is implied.

Where real plants differ

Several ERPs, companies and plants in one installation. A system replaced partway through its history. Huge tables. Custom fields. Codes nobody documented. Several currencies. Shifts that cross midnight. Schedules kept outside the ERP. Each of these is handled as a setting, never as custom code for one customer.

The calendar and the shift

Fiscal calendars (calendar months, 4-4-5, 4-5-4 or 5-4-4) are a setup choice. Every site has its time zone, and VERUS knows whether each system stores times in UTC or in local time. It will not assign an event to a shift until both are known, because getting that wrong is the most common silent error in plant reporting.

Three integrity rules

  • On-time delivery is measured against the promise made when the order was entered, not the promise as it stands today.
  • Build completion uses the schedule as it stood at the start of the day.
  • Any breakdown by cause code comes with a check on how concentrated the codes are.

When one of these is in doubt, it is the first thing the answer says. On the demonstration, 1,252 order lines had their promise date moved to the ship date after shipping. VERUS measures against the original promise and says why.

What your IT team does to connect each one is on Connecting VERUS, and what can and cannot leave your network is on Security.