I want my Arduino to connect to the MS SQL database. my idea is to get an alert (not email or SMS) something like a sound alarm. below I explain the usage.
let's assume that we have a database with data regarding (the number of pieces that employees should work). in apparel sector, each team has to maintain their WIP to a minimum level of pieces. if that count goes down it needs to be alerted to the employees that WIP is below the minimum number.
Glad I don’t work there. You need to think about how employees will enjoy such a system , I guess you could automatically electric shock them , or link to the system making up their pay if they fall below target .
You need to look from the PC end as to how you get data into the database .
The Arduino has serial connections you can use .
The other hard part , as said , is how you get data from the work place .
Arduino is not powerful enough to run an MS SQL database, as I'm sure you know. Some more powerful device will need to do that. If there is a more powerful device available, what is the need for an Arduino?
Also, reading your description, why is an MS SQL database needed to achieve it?
this is basically an alert to the group leader that says "There are no more pcs to make production".
that means that the group leader must fill the basket with new cut panels to support the production operations.
there is an application developed by us to monitor and collect data from the beginning (cutting fabric panels according to the order we received) to the end (shipping, making cartons from those products which were finished by the sewing operators, according to the buyer requirements).
so once the cutting was done, cutting dpt creates bundles in the application according to the physical qty available.
then that qty was transferred to the sewing team physically and through the systems also at the same time.
as the sewing operators do their operation, that quantity decreases from time to time. before it reaches zero. the group leader must fill the basket with new cut panels. ( a database that holds the data WIP qty)
for that, I need to set the alerts to that point. it will make it easy for the leaders to fill the basket.
The easy way - if you are married to M$ that is: create a glue application that runs on your server that talks to M$ SQL on one hand and presents itself as a HTTP server on the other. Use JSON as data format. Implement the commands you need. On the Arduino side: Use an ESP32 for the ease of operation.