Logging to Local MSSQL Database

[gerhardK]

I assume you are using groov EPIC with PAC Control.

Node-RED might still be the best approach for this. Perhaps you have already searched the forums for it:

Sending data from Epic to a MSSQL Database

Hello, I am a .net programmer and I am developing a desktop application that display in a chart data acquired through sensors connected to an epic groov. My application use a SQL Server database to store data before displaying. So I need to send data from Epic every time it makes an acquisition from sensors. I can see there are many way to program the epic system, what is the best way to achieve this continuous communication between the two systems? Regards

How to Update a MSSQL Database with Node-RED

I’m trying to update my MSSQL database using Node-RED. Here is the query which works in the MS SQL Server Management Studio: [image] However when I use Node-RED I get this: [image] Here is the syntax in my MSSQL node: [image] I’m sure it’s some kind of syntax error. I can do an INSERT just fine with the same data. I’ve tried adding single and double quotes around the {{{payload}}} but it doesn’t help. I realize this is a MS SQL Server issue, not an Opto22 one, but since I’m pulling da…

All I/O and PAC Control tags are also exposed via the RESTful API, if that is an option for you to access them from MSSQL database via API calls.