Decode historical data saved in SQL server.|OPC UA Standard|Forum|OPC Foundation

Avatar
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
Lost password?
sp_Feed sp_PrintTopic sp_TopicIcon
Decode historical data saved in SQL server.
Avatar
Mads Pedersen
New Member
Members
Forum Posts: 1
Member Since:
10/14/2019
sp_UserOfflineSmall Offline
1
10/16/2019 - 05:25
sp_Permalink sp_Print

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?

Forum Timezone: America/Phoenix
Most Users Ever Online: 510
Currently Online:
Guest(s) 21
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Forum Stats:
Groups: 2
Forums: 10
Topics: 1435
Posts: 4855