OPC UA connection to a database|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
OPC UA connection to a database
Avatar
Viorel Stan
New Member
Members
Forum Posts: 1
Member Since:
03/04/2022
sp_UserOfflineSmall Offline
1
03/04/2022 - 10:16
sp_Permalink sp_Print

Hello,

My company bought 2 variovac production machines that uses OPC UA. The issue is the downtime for those machines is more than expected.

I would like to save in real-time the data(log or history or what do you recommend) from the OPC UA servers to an SQL database and use PowerBI to build some reports. Production per Hour taking into consideration down time and standard production without down time.

I can handle the PowerBi reports but I do not know how to save the data from the OPC UA server to a database.

Is there a software? Is it free? Can I configure the OPC UA server to save the data directly to database without using anything else?

Avatar
Randy Armstrong
Admin
Forum Posts: 1451
Member Since:
05/30/2017
sp_UserOfflineSmall Offline
2
03/04/2022 - 13:25
sp_Permalink sp_Print

There are many historian products that do this.

https://opcfoundation.org/products

Keyword 'historian'

Forum Timezone: America/Phoenix
Most Users Ever Online: 510
Currently Online: Svein Folkeson
Guest(s) 22
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Forum Stats:
Groups: 2
Forums: 10
Topics: 1354
Posts: 4583