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©).
18
.
02
.
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
High-speed test stand for car tires (retrofit)
A new controller (Siemens Simatic S7) was set up in conjunction with a measurement data acquisition system on an existing customer high-speed test stand (up to 400 km/h) for passenger car tires. Various test orders are read from an ERP system and stored in a separate SQL database. From there, the test orders can be loaded into the controller and processed.
Learn more
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
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
Switch to SQL4automation Now.
Connect industrial controllers directly with SQL databases. Field-proven since 2007 for maximum performance and security, completely without middleware.