How do you connect to Epicor? Choosing the connection path
"Epicor" covers several different ERPs. Kinetic, Prophet 21, BisTrack, and older Epicor releases each offer different ways in, and hosting changes the picture again. Picking the right path in week one saves rework later.
Epicor connection paths we evaluate in week one. What's available depends on your product, release, and hosting.
| Path |
Good for |
What we check first |
| Epicor's REST services (Kinetic) |
Creating and updating customers, orders, and parts with Epicor's own business rules applied |
Your release, and whether the service you need exists for it |
| Saved queries (BAQs) exposed as services |
Reading a shaped set of data, like stock by warehouse or open invoices |
Query run time on large tables at busy hours |
| Custom logic inside Epicor |
Steps Epicor should run itself, such as pricing or credit checks |
Who maintains that logic through Epicor upgrades |
| Prophet 21 and other product APIs |
Distribution flows on Epicor products outside Kinetic |
Which endpoints your version exposes |
| Read-only database access over VPN |
Older or on-premise releases without the service you need, like the BisTrack build above |
Read-only credentials and a schedule that spares the ERP |
We write to Epicor only through its own services where they exist, so Epicor's validation rules still apply to every record. Direct database access stays read-only. That keeps Epicor in charge of its own data, even when the faster route would be to write straight into a table.
Which system owns each record in an Epicor integration?
Each record has one owner. Only the owner changes it. Every other system reads it, and a disagreement raises a flag rather than an overwrite.
| Record |
Owner |
Read by |
| Prospect, deal, quote draft |
CRM |
Epicor when the deal is won |
| Customer, ship-to, terms |
Epicor once it buys |
CRM, store |
| Parts and price lists |
Epicor |
CRM, store |
| Stock by warehouse |
Epicor |
CRM, store |
| Orders, shipments, invoices |
Epicor |
CRM, warehouse |
| Returns and warranty cases |
Service desk |
Epicor for credits |
What breaks in Epicor integrations, and how do you stop it?
These four show up in most of the Epicor links we're asked to repair. Each one fails quietly.
- Upgrades that change a service. A new Epicor release renames a field or changes a service, and records stop flowing with no visible error. We test each flow against the new release in your test environment before you upgrade production.
- Branch-level customer copies. Each branch created its own customer record, so one buyer has several IDs. We agree a match rule and a parent account before any data moves.
- Heavy queries at the wrong time. A stock query that runs every minute against a large table slows the counter at 8 a.m. We schedule reads around your busy hours and pull only changed records.
- A dropped VPN tunnel. When the network link to an on-premise server goes down, nothing syncs. Our monitoring checks the tunnel and alerts when it fails, then the queue catches up.
Which Epicor flows should sync in real time?
Run fast where a customer or a rep is waiting, and batch everything else. An on-premise Epicor server serves the branch counter first, so the integration should never compete with it at the busiest hour.
| Flow |
Timing |
Why |
| Won deal to sales order |
Within minutes |
Production and picking start from the order |
| Web and portal orders |
Within minutes |
Buyers expect a same-day confirmation |
| Stock by warehouse |
Every 15 to 30 minutes |
Close enough for quoting, light on the server |
| Price lists |
When they change |
Price updates are rare but must be exact |
| Invoices and balances |
Hourly or daily |
Reps check them before calls, not mid-call |
| Warehouse loads |
Nightly |
Reports run on closed days |
These are starting points. We set the final schedule in week two, after measuring how long your Epicor queries take at busy and quiet hours.
What sets the price of an Epicor integration?
We give one fixed price after discovery. These five factors move it the most.
| Factor |
Lighter |
Heavier |
| Product and hosting |
Cloud Kinetic on a current release |
Older on-premise release behind a firewall |
| Branches and companies |
One company, one site |
Many branches or companies in one database |
| Custom fields |
Standard fields |
Many user-defined fields and tables |
| Systems |
One CRM |
CRM, store, finance, and warehouse |
| History |
Open orders only |
Years of closed orders and invoices |
What should you have ready before an Epicor project starts?
Bring these and discovery moves a week faster.
- Your Epicor product, release, and where it's hosted.
- Who in IT can set up a VPN and a service account.
- The user-defined fields and tables your team relies on.
- How branches identify the same customer today.
- One owner in operations and one in IT.