How does ESL system docking with other system

Time:2020.09.06     Author:sertag

   ESL system(digital price tag) and ERP are independent management systems and have their own system structure. Based on the common data between them, such as materials, purchase and storage, sales and delivery, and production orders, ETC., HOW does the ESL system get the latest material information of ERP, and how to efficiently, timely and correctly reflect it on the label? And ensure the timely, consistent and stable delivery of data. The following will be the ESL system and ERP docking way to introduce and compare, for your reference.
Interface mode is as follows:
   1.Web Service: The international open standard interface is one of the best interface ways to connect two different systems with a low coupling degree.
   2. Temporary table: the access of one system to another system's temporary table is the access to another system's database. When the table structure changes and the interface program needs to be modified, there is a certain development cost.
   3.API interface: In this way, ERP generally provides API interface and ESL system calls API interface to achieve data synchronization. When designing and developing THE API interface of each ERP system, the safety, rigor, data integrity and other aspects have been fully considered, which is one of the best ways for THE CONNECTION between ESL system and ERP. However, due to various reasons, not all ERP have an open API interface, while large international ERP such as SAP and Oracle ERP have an open API.
   Method 1: Write ESL system temporary table,ERP submits documents and outputs data temporary table at the same time, which can realize real-time synchronization of existing data. Since the temporary table is a Shared table, the ESL system needs to set intervals for continuous access, and the ERP system also needs to output the displayed data. If the temporary table structure needs to be changed due to requirements change and other reasons, the interface program needs to make modifications and adjust the field structure of the temporary table.
   Method 2: Tune to ESL system Web Service, ERP submits documents and calls TO ESL system Web Service to synchronize data to ESL system. This way is simple to implement, ERP development workload is 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 submits documents and writes ERP temporary form. ESL system accesses ERP temporary form regularly and actively.
   Method 4: The ERP Web Service is called. When ERP submits documents, the data is stored temporarily in the temporary table. The ESL system calls the Web Service regularly, and WebSerice realizes the query of data from the temporary table. The two systems are separated by the intermediate interface of Web Service, which does not affect each other. Flexible Web Service interface is designed to avoid the change of interface program when future requirements change. ERP presentation documents to write more temporary table processing, but in the same system speed has little impact.
   Based on the introduction of the above docking methods, SERTAG ESL(e-ink tag) manangement system can provide multiple docking methods,enabling docking between different systems and data types, such as HTTP(WebAPI 、WebSvc),FTP(Excel、CSV)and Database(SQL).