DataXchange ERP Integration 

ERP Integration

In order to share the data with a third party software, the DataXchange API Console Application is a sample application written in C#. It utilizes the Scytec DataXchange API to retrieve data and place the data in a CSV file.

Included with the Console Application is an Excel spreadsheet that passes information into the Console application. Once the CSV output file is created, the Excel spreadsheet will automatically import the data from the CSV file and display the data in another worksheet.

Features

Before we begin, what exactly are ERP and MRP systems? What other manufacturing software systems can be compared to them? Let’s review:

  • Enterprise Resource Planning (ERP)
  • Material Requirements Planning (MRP)
  • Manufacturing Execution System (MES)
  • Product Lifecycle Management (PLM)
  • Manufacturing accounting
  • Production planning or production scheduling

For now, we will focus strictly on ERP integration. When ERP and machine monitoring bond, Common Data Fields you can share between DataXchange and ERP systems are:

  • API Call/Key
  • Service URL
  • File Location
  • Start/Stop Date Times
  • Equipment Lists
  • Shift Lists
  • User Groups
  • Company Groups

ERP Systems

If you have any of the ERP systems listed below, contact us for integration information!

  • E2 Shop System
  • JobBoss
  • Infor Visual ERP
  • IQMS
  • Global Shop Solutions
  • EPICORE
  • Oracle
  • Plex
  • Quickbooks
  • Syspro
  • ShopTech
  • Many more!

How it Works

How does machine monitoring integrate with ERP systems? The answer varies.

The best answer depends on the equipment, size and production needs of the manufacturer looking to consolidate these technologies.

Different methods to integrate these software systems are:

  • Web Services & APIs
  • Customized Sensors
  • IIoT Hardware

Overview

“An ERP handles end-to-end manufacturing processes and integrates them into a common loop,” states an article from ERP Focus. The system helps to organize Order Management, Inventory Control, Production Scheduling, Financial Accounting, Sales Management, and other shop floor productivity concerns.

Some reasons why you would want to integrate machine monitoring with your ERP system:

  • The ERP prioritizes and schedules orders
  • CNC utilization info sent to the ERP updates inventory levels & work orders
  • The ERP system can combine with a Manufacturing Execution System (MES) to help further the productivity cycle on your shop floor

For more information from the #1 reseller of DataXchange, please call (877) 611-5825