I am working on an HMI right now that will need to populate IO fields with string information.
The catch is that this information is stored in a server room (networked to my stations) in a SQL database. I know that it is possible to create a text file with the specific data I need at the SQL server.
The concern I have is how I would go about bringing that text file to the HMI.
Have you guys seen this before? Do I have to target a specific directory and drop txt files in there? Or is it more of a situation where I write a script to go target the SQL database.
I am a little in over my head here.
Thanks in advance, any pointers are appreciated.