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©).
09
.
04
.
2026
The transferred data records are used for statistical evaluation for quality management. If the measured semi-finished product is OK, a production release is granted to the production line. Control is carried out using a Simatic S7-315 PN/DP.
Workflow:
- Operator login using a magnetic keycard. The PLC generates an SQL query to the SQL database "Employee Master Data." The query result includes the employee's last name, first name and authorization level (Operator, Setup, Service).
- Selection of the current product via the HMI panel, alternatively via the employee number (the ERP system knows which employee is currently manufacturing which product).
- Loading the target values and tolerances for the current product number.
- Inserting the semi-finished product and releasing the device for operation.
- Capturing actual values and writing the data to a QDAS database (date, time, employee, product number, actual values (dimensions, ambient temperature, status (OK, NOK), etc.).
- If semi-finished products are OK, then production release is granted.
Technical data:
- Controller: Siemens Simatic S7-315 PN/DP
- SQL4Connector V2.x
- Connection to 3 databases (personnel database, production database, quality database)
Download document for the article
Dive deeper into the content of this article with a compact document available for download. Ideal for sharing with your team or for later use in projects.
More News
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
Database as automation hub
When Huba Control produces sensors, orders ranging from batch size 1 to thousands of parts can be processed without any problems. This is made possible by a flat automation structure with an SQL database as the central hub. The SQL4automation Connector ensures fast and reliable communication between the controller and the database.
Learn more
Conveyor technology target selection
One of our standard applications is conveyor lines where a product is identified by barcode or similar means and transported to the respective production equipment according to a target query.
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.