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

Improving performance with plant data

Improving performance with plant data

Improving plant performance does not always require complete re-automation. For a vulcanization plant producing rubber bellows at the Continental Vahrenwald facility, the engineers decided to keep the controller and improve performance solely through greater data transparency. The prerequisite for this was simple, software-based data access from the SQL database to the controller. Angelo Bindi from Continental explains the solution.
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
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

Switch to SQL4automation Now.

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