Can you integrate our ERP system with SCADA/MES application? This is the most frequent question we get asked when starting any new SCADA or MES project, and it’s frequent for a reason.
There are several benefits to integrating your ERP into SCADA/MES including real-time production adjustments, more efficient scheduling, change order efficiency and accurate demand forecasts. Often, we’re also asked if we can build an application to directly tie-in to all the functionality of their ERP system.
In the immortalized words of Bob the Builder, “Can we build it? Yes, we can!” This post will introduce you to the top four ways that Vertech approaches ERP integration.
Those top four ways are:
1. Set up an API (Rest or Soap)
Provides a direct network connection between the ERP and the SCADA/MES for real-time, bi-directional information exchange.
2. Stored Procedure or “View"
A stored procedure or “view” is installed in the ERP database for the SCADA/MES application to read and/or modify a specified subset of data from the ERP system.
3. Shared Database Table
A database table is established as a common communication point. The ERP system and the SCADA/MES system use this table to exchange information.
4. Export CSV File (Flat File)
The ERP writes a .csv file to a common location. The SCADA/MES software regularly looks for new files containing needed information. This can work both ways.
In a recent blog titled "The Top 10 ERP Systems for 2020,” Third Stage Consulting Group listed the current top ten ERP systems in use today as:
- Oracle NetSuite
- Microsoft Dynamics 365
- Oracle ERP Cloud
- Sage X3
- SAP S/4HANA
- Infor M3 and CloudSuite
- Service Now
Most of the clients we speak with use one of these ERPs, or something very similar, and ALL of them can be integrated with SCADA/MES software. Our experienced team can help you choose the right method for your situation and work with your IT team to implement a solution.