Logging to Local MSSQL Database

[jacksonlance02]

Hi all, I am wanting to get some community knowledge on the best way to log from Opto22 to an MS SQL Server. Currently we are doing it through OPC UA and having an OPC UA client on a system on the local network that is archiving the data to an MS SQL Server which is also on the local network.

Is there a more direct way of storing this data? We do not want to use the Opto22 system as storage, we just want to find a fast way to pass the data on from Opto22 into a database system. We have used Node-RED previously in the past however OPC UA seems to be more reliable.

The goal is to log sensor data in the most direct/efficient way possible to an MS SQL Server hosted on the local network.

[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.

[Norm_Freeman1]

Node-RED is a great way to go. We have many systems using it and it has been very reliable.

[Beno]

@jacksonlance02

We have used Node-RED previously in the past however OPC UA seems to be more reliable.

That’s really interesting… Can you expand on this a bit?
We’ve found that OPCUA is pretty heavy on the CPU vs Node-RED.
I have a personal project that is moving 300 to 500 tags per minute into SQLITE with Node-RED and had zero issues for years. (Node-RED also drives the select statements on that db which holds around 1.5 million records and returns the data in about 2 seconds).