Epicor DMT Load Time Estimator
Whether an Epicor conversion fits the cutover weekend depends on load rate, volume and rework. This estimator turns those into hours per load and shows how much of the cutover window a full live load would use.
Your numbers
Total rows across the object being loaded
From a timed sample in a test system
Your results
An estimate for planning. Real rates depend on BPM directives, hardware, indexing and record size, so replace the defaults with timings from your own test loads.
Hours per full load vs load rate
Sweeps Measured load rate from 20 to 400, holding your other inputs fixed.
Cutover planning help
An optional review of your conversion timings and cutover sequence.
Optional. The tool and every export work without this. No spam.
How to use the estimator
Enter the record count for the object, the load rate you measured on a timed sample, the percentage of rows you expect to be rejected and reloaded, the number of rehearsals and the validation time per load. The result shows hours per full load, total hours across rehearsals and live, and the share of your cutover window consumed.
- Measure the rate, do not guess
- Include reloads
- Add validation time
- Compare to the real window
The formula
Rows reloaded equal records times the rejection percentage. Load minutes equal records plus reloaded rows divided by the load rate. Hours per full load equal load minutes plus validation minutes, divided by sixty. Total hours multiply that by rehearsals plus the live load. It is deliberately simple so you can check it by hand and adapt it for each object.
Reading the chart
The chart sweeps the load rate and plots hours per full load. Gains flatten as the rate climbs, since validation time stays fixed. A low rate can make a load impossible to fit, which points to fixing the cause, such as slow directives or lock contention, instead of simply extending the window.
Common mistakes
Using a rate from a tiny sample overstates speed because larger loads slow down. Forgetting reloads and validation is the other classic error. Sum objects serially unless you have proved they can run in parallel, since many loads depend on earlier ones.
Frequently Asked Questions
How do I measure my DMT load rate?
Load a representative sample of a few hundred or thousand rows into a test environment, record the elapsed time, and divide rows by minutes. Repeat with a larger sample to see whether the rate falls with volume.
Why would my rate be low?
Common causes are BPM directives firing per row, many related tables updated per record, network or database contention and under sized servers. Test with directives disabled in a test system to see how much they cost.
Can I run several loads at once?
Sometimes, if the objects are independent and the system has headroom, but concurrent loads can lock the same tables and slow each other. Test parallel loading in rehearsal before you rely on it in the cutover plan.
What reject percentage should I assume?
Use what rehearsals show. Early loads often reject a large share because of mapping and data quality issues, and later ones fewer. Start with a cautious figure and update it after each rehearsal.
If a load will not fit your window, Netray can help analyse directives, sequencing and data volume.
Related Tools
Epicor DMT Data Load Plan Worksheet
Sequence your Epicor Data Management Tool loads with record counts, rates and estimated run time, then export the plan to Excel.
EpicorEpicor UAT Test Script Worksheet
An editable UAT script for Epicor with expected results, tester, status and defect counts. Track pass rate and export to Excel.
EpicorEpicor BPM Directive Inventory Worksheet
Inventory your BPM directives, score complexity and retest effort, and see total upgrade retest hours. Export to Excel.
EpicorEpicor Customization Change Request Template
A change request form for Epicor customizations that captures the business need, impact, test plan and approvals before anyone opens the tool.
More Epicor tools
See all- Epicor Kinetic Customization Change Request Form Template
- Epicor Kinetic Go-Live Cutover Plan Template
- Epicor Kinetic User Access Request Form Template
- Epicor Kinetic BPM Directive Inventory Worksheet
- Epicor Kinetic Scheduled Task Register Worksheet
- Epicor Kinetic Custom Report Inventory Worksheet
- Epicor Kinetic Data Migration Mapping Worksheet
- Epicor Kinetic Data Load Effort Calculator
- Epicor Business Object Services Reference
New to Epicor ERP? Start with the Epicor ERP guide and toolkit, or plan with Training Path Builder, ERP Certification Study Planner, Upgrade Path Planner.
Keep exploring
Free tools
- Epicor DMT Data Load Time CalculatorPlan DMT load windows by combining record counts, throughput, error rates and fix time into total hours.
- Epicor DMT Load Duration EstimatorEstimate how long your DMT loads will run in a cutover, from record counts, a measured rate, error reloads and overhead per file.
- Epicor DMT Data Load Plan WorksheetSequence your Epicor Data Management Tool loads with record counts, rates and estimated run time, then export the plan to Excel.
ERP fixes and how-tos
- How to import data with Epicor DMT (Data Migration Tool)Step by step guide to Epicor Data Migration Tool (DMT): generating templates, mapping fields, preprocessing steps, running imports, and reading the error log for failed rows.
- How to Complete an Operation in Epicor Kinetic (Plus Time Entry and Corrective Action)Complete an operation in Epicor Kinetic through MES or Labor Entry, plus time and expense entry, customer managed inventory and corrective action, with what to check first.
Integrations
- How to add AI agents to Epicor KineticHow to add AI agents to Epicor Kinetic: a tool layer over the REST v2 API and BAQs, MRP exception triage, PO expediting, and human approval before any write.
- How to add an AI chatbot to Epicor KineticAdd an AI chatbot to Epicor Kinetic: an internal assistant for planners and buyers or a customer portal bot, grounded in BAQs and runnable fully on-prem.