Automatic spray system for mixed production

In the "8-axis universal handling machine" application, various product types are automatically treated (sprayed) with solvent according to process specifications.
09
.
04
.
2026
Automatic spray system for mixed production

Products are conveyed to the machine on a conveyor belt in mixed-mode operation. There, they are identified by barcode and weighed. The weight (quality characteristic) is written to a database together with the barcode. Based on the barcode, the manufacturing parameters are read from a database and the 8 axes are positioned to achieve an optimal spray pattern.

Workflow:

  • Transport and identification of the product (barcode)
  • Weighing the product and sending the weight to the QM database
  • Reading the manufacturing parameters from the production database
  • Positioning the 8 axes according to manufacturing parameters
  • Spraying the product

Technical data:

  • Controller: Simatic S7-315 PN/DP
  • SQL4Connector V2.x
  • Connection to 3 databases (ERP production database, recipe database with manufacturing parameters, quality database)

Note:

These applications are examples intended to demonstrate the possibilities of a PLC/SQL database connection. Modified solutions are always possible. For data protection reasons, images and process-specific details have been omitted. However, we are happy to answer any questions.

More News

Energy from waves: Data analysis with SQL4automation at sea

Energy from waves: Data analysis with SQL4automation at sea

CorPower has developed a completely new type of wave energy converter for use at sea. Beckhoff TwinCAT controllers are used for monitoring and continuous system optimization. Data is collected and analyzed in SQL databases. The SQL4automation Connector transfers data easily from the controller to the database. Jakob Sagatowski from CorPower explains the solution.
Learn more
Maximum data transparency with SQL4automation

Maximum data transparency with SQL4automation

Exchanging production data between PLCs, robot controllers and databases simply, quickly and flexibly — this was previously hardly possible with large volumes of data without significant effort or performance losses. The SQL4automation Connector achieves this with just a few clicks, providing easy access to production data.
Learn more
V5.2.0.3 is here!

V5.2.0.3 is here!

New in SQL4automation: DNS-Based PLC Authentication. Previously, SQL4automation stored the IP address of the PLC on the first request. All subsequent requests had to come from exactly that IP. Now, a DNS name can be stored instead.
Learn more

Switch to SQL4automation Now.

Connect industrial controllers directly with SQL databases. Field-proven since 2007 for maximum performance and security, completely without middleware.