Electronic shelf labels system (digital price tag) and ERP are independent management systems with their own system structure.Based on common data between the two, such as materials, purchase and storage, sales and delivery, and production orders, how does the ESL system obtain the latest material information of ERP and how does it reflect it efficiently, timely, and correctly on the label?And ensure timely, consistent, and stable delivery of data.The following will be the E E-ink price tags system and ERP docking way to introduce and compare, for reference.
Interface mode is as follows:
1.Web services: The International Open Standard interface is one of the best ways to interface two different systems with low connectivity.
2. Temporary tables: Access by one system to another system's temporary tables is access to another system's database.When the table structure changes and the interface program needs to be modified, there are certain development costs.
3.API interface: In this way, ERP usually provides API interface and ESL system call API interface for data synchronization.Security, rigor, data integrity, and other considerations have been taken into account when designing and developing the API interfaces of each ERP system. This is one of the best ways to connect AN ESL system to ERP.However, not all ERP systems have open API interfaces for a variety of reasons, while large international ERP systems (such as SAP and Oracle ERP) have open apis.
Method 1: Write ESL system temporary table, ERP submits files and output data temporary table at the same time, which can realize real-time synchronization of existing data.Because temporary tables are Shared tables, the ESL system needs to set intervals for continuous access, and the ERP system needs to output the displayed data.If the temporary table structure needs to be changed due to requirements changes and other reasons, the interprogram needs to modify and adjust the field structure of the temporary table.
Approach 2: Tune TO the Epaper display tags system Web service, and THE ERP submits the document and calls TO the ESL system Web service TO synchronize the data TO the ESL system.This way is easy to implement, ERP development workload is very small, the two sides of the system through the Web Service intermediate interface separated, do not affect each other, through the design of flexible Web Service interface to avoid future demand changes when the interface program changes.
Method 3: Read the ERP temporary table, ERP submit the document and write the ERP temporary table.The ESL system has regular and active access to ERP temporary forms.
Method 4: Invoke the ERP Web service.When an ERP submits a document, the data is temporarily stored in a temporary table.The ESL system makes regular calls to Web services, and WebSerice implements querying data from temporary tables.The two systems are separated by a Web Service intermediate interface that does not affect each other.Flexible Web services interfaces are designed to avoid changing the interface program in the future when requirements change.More temporary table processing is written to ERP presentation files, but the impact is small at the same system speed.
Based on the above docking methods, the SERTAG ESL (E-Ink tag) management system can provide multiple docking methods to support docking between different systems and data types, such as HTTP (WebAPI, WebSvc), FTP (Excel, CSV) and database (SQL).