HMI Database Integration

Equipped with easy-to-use database integration, cMT Series HMIs can send machine metrics, production data or recipes to a database system directly without any middleware system. Those data can then be managed in a larger scale using batch database operations. Plus, the built-in database-related viewers enables smooth operations using data on the databases. These features can simplify your processing works and save your precious time.

Collecting machine metrics is always a challenge for integrations. People use USB Drives or FTP Services to retrieve files (Such as CSV Files) from a machine, convert the file formats, and then save them to separate tables or spreadsheets. Those cumbersome work can get complicated once more files or more machine metrics are added to the system. Instead, a better option will be to save machine metrics directly to a database. This has several benefits including simpler batch operations, no more file conversion, more storage options, and spaces, and finally, use intuitive SQL commands to customize your read/write/modify/delete operations on the database.

The cMT built-in database integration can send real-time machine data, alarms and events to databases, and those data can also be displayed on HMIs or cMT Viewer (PC/mobile remote-control app). Those can be done without writing any program code, an easy database solution. After saving the data into databases, IT/MIS Experts can further analyze and make decisions based on those data, such as report generation, energy usage, manufacturing record tracking.

The new SQL Query feature in cMT series provides a more general way to access databases. It can send and change recipes in a database like a shared Recipe Database when multiple machines use the same recipe. Batch recipe change can be applied to all machine at once using databases. SQL Query also accepts customized SQL commands for filtering and statis­tics, such as OEE calculation (Overall Equipment Effectiveness), unit production rate, averag­es of numbers, standard deviations, etc.

With 300+ communication driver support, cMT can help send a huge amount of machine in­ formation to databases. And with the rich integrated features of cMT series, you can connect HMI to barcode readers, IP cameras, make HMI speak with built-in speaker or remotely access the HMI. Those features will not only simplify your work but also increase the values of your product.

Leave a Comment

Your email address will not be published. Required fields are marked *

Need Help? Chat with us!
Start a Conversation
Hi! Click one of our members below to chat on WhatsApp
We usually reply in a few minutes
Scroll to Top