Historian (Vtrin) to SQL Server connection
Hello, In order to cross the data coming from the 800xA with other data from the factory, we want to create a common database. I have successfully exported the OPC values from the 800xA in real time to a SQL Server database. But I would like to be able to read in the Vtrin database (ODBC) to communicate the values of the historian to my SQL Server database. Do you know if this is possible? If yes, how?
thanks,
Kevin
thanks,
Kevin
Answers
I don' know what version of 800xA you are utilizing, however I am basing this response of the latest version, 6.1.
The ABB Ability™ System 800xA 800xA History Administration and Configuration manual, 2PAA107563-610 A, contains a section specifically describing the ODBC interface and how to utilize it for retrieval of both Numeric & Event data from the RTDB database in the 800xA Historian Server. Please refer to section 3.5 for this information.
Regards,
Geof Ledin
The ABB Ability™ System 800xA 800xA History Administration and Configuration manual, 2PAA107563-610 A, contains a section specifically describing the ODBC interface and how to utilize it for retrieval of both Numeric & Event data from the RTDB database in the 800xA Historian Server. Please refer to section 3.5 for this information.
Regards,
Geof Ledin
I've written a little application that reads HDA data and writes it to a SQL Server.
I have scheduled it to run once a day.
It's written in C# and will make it open source if you like.
Disclamer: I'm not a professional C# developer. The code is can be improved, but it works for me.
I have scheduled it to run once a day.
It's written in C# and will make it open source if you like.
Disclamer: I'm not a professional C# developer. The code is can be improved, but it works for me.
Add new comment