10/14/2019
I have a OPC UA Server(Beckhoff IPC) which saves historical data in a MSSQL server database.
I would like to access/decode the historical data directly from the sql server, without a OPC client.
The value is saved as a varbinary(4096) in the database.
Sample data from the database, the PLC tag is a UINT16:
0x00053C17000000003C83D501DE5F20853C83D501DE5F20850000000065000000
0x00056E17000000003C83D50133E96B853C83D50133E96B850000000065000000
0x0005A017000000003C83D5016F35B8853C83D5016F35B8850000000000000000
0x0005D117000000003C83D501B75A04863C83D501B75A04860000000000000000
0x00050418000000003C83D50109CE50863C83D50109CE50860000000000000000
0x00053618000000003C83D5016D1A9D863C83D5016D1A9D860000000000000000
0x00059A18000000003C83D501388C35873C83D501388C358700000000EE810B00
0x0005CB18000000003C83D50188B281873C83D50188B281870000000000492F00
Is there any documentation on how to decode this? Or maybe some code samples on how to do this?
1 Guest(s)