SQL Query

In the era of Industrial 4.0, a clothing manufacturer may need to turn its original mass production of the same style of clothing into making a variety of different clothes, in order to meet the needs of different orders and achieve customized production. This requires dispatching the production resources of production lines, such as adjusting the use of different fabrics, dyes and production equipment, which depends on the styles of clothes. It also requires updating the production resume to the ERP system, integrating the data with procurement, sales, shipping departments in order to handle product life cycle completely.


  • For different products, automatically adjust equipment’s parameters and the use of fabrics.
  • The equipment in the factory should be able to upload the manufacturing data to a platform, which can combine with ERP system.
  • The operator needs to adjust the production line depending on the production status.

SolutionsSQL query on Weintek HMI

  • Connect to SQL server by HMI, update the recipe through Ethernet.
  • Combines with ERP system through HMI and SQL server.
  • The operator on site can make SQL query on the HMI. The HMI will update the query to SQL server, and then deploy resources in different production line depending on different production rate.

Update recipe online

After setting the query command on HMI, the HMI can get the recipe in SQL database. The operator will be able to choose the equipment’s parameters, fabrics and dyes on SQL database depending on different orders. The data can be sent to different HMIs on different equipment through Ethernet, and PLC will get the parameters from HMI.


Combination of SQL database and ERP

HMI will gather the production data from PLC, and then upload the production resume to SQL database through SQL query. IT department can easily combines the data into ERP since SQL is very familiar to them.


On site real time dispatching

Operators on site can use SQL query through HMI, deploy production line’s resources based on the actual production rate. For example, there are two lines named A and B. Line B’s production is faster than line A. The operator can deploy more fabrics to line B, and use more carriers to put the products manufactured on line B.

Scroll to Top
Malcare WordPress Security