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.
18
.
02
.
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

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
Device for quality monitoring of semi-finished products in the manufacturing process

Device for quality monitoring of semi-finished products in the manufacturing process

This application is a device that checks semi-finished products in manufacturing for geometric dimensional accuracy and stores the measured actual values in a quality database (Q-DAS©).
Learn more
Data exchange: Standard instead of custom-built

Data exchange: Standard instead of custom-built

For Bahmüller's Turbox folding carton gluers, controller data should be made available for production data acquisition with as little effort as possible. Technical Director Electrical Engineering Armin Haag is impressed by how easily this works with the SQL4automation Connector.
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.

Compare VersionsTry for free now