The large majority of specs in USA asks for MS SQL as historian DB. I know that the Oracle and HDB are the standard historian DB in WinCCOA, but is there any way to use MS SQL instead ? What limitations/ problems are we going to face ? What could it be a viable solution ?
Any advise is very welcome.
MS SQL
- zscriven
- Posts:21
- Joined: Tue Jul 05, 2016 11:03 pm
Re: MS SQL
There is no way to use MS SQL as the historian database.
However, you can connect to MS SQL server. I am doing this on a project right now. You can write queries against this database to store and retrieve data. It works extremely well.
*The caveat is you need to write all these queries yourself.*
The time series data can not be stored here without writing the scripts yourself to do so. The oracle DB logging is a setting and checkbox, and all of logistics are handled for you.
Depending on the logging requirements you could implement your own logging system fairly easy. However you would then need to develop scripts to trend, view, report on this data.
However, you can connect to MS SQL server. I am doing this on a project right now. You can write queries against this database to store and retrieve data. It works extremely well.
*The caveat is you need to write all these queries yourself.*
The time series data can not be stored here without writing the scripts yourself to do so. The oracle DB logging is a setting and checkbox, and all of logistics are handled for you.
Depending on the logging requirements you could implement your own logging system fairly easy. However you would then need to develop scripts to trend, view, report on this data.
- Gertjan van Schijndel
- Posts:634
- Joined: Mon Aug 02, 2010 10:37 am
Re: MS SQL
If you do not want to write these queries yourself, then you can use the DBLogger (Online help -> Special functions -> DBLogger).
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: MS SQL
Hello,
the WinCC OA Add-On DBLogger only writes information to the selected database.
Which data shall be written needs to be configured in the panels for the DBLogger. Writing values to the database is not made when an _archive-config is defined. The _archive config is only used when writing data to one of the WinCC OA standard databases (Value archive/HDB or Oracle/RDB).
Also the DBLogger cannot be used to save alert information in an MS SQL database.
If you want to read data from an MS SQL database you have to write the functions on your own, using the CTRL functions to access external databases, see WinCC OA help CONTROL --> Types of functions --> Database functions.
Best Regards
Leopold Knipp
Senior Support Specialist
the WinCC OA Add-On DBLogger only writes information to the selected database.
Which data shall be written needs to be configured in the panels for the DBLogger. Writing values to the database is not made when an _archive-config is defined. The _archive config is only used when writing data to one of the WinCC OA standard databases (Value archive/HDB or Oracle/RDB).
Also the DBLogger cannot be used to save alert information in an MS SQL database.
If you want to read data from an MS SQL database you have to write the functions on your own, using the CTRL functions to access external databases, see WinCC OA help CONTROL --> Types of functions --> Database functions.
Best Regards
Leopold Knipp
Senior Support Specialist