The OPC Database.NET product provides data logging to databases and Comma Separated Variable text files. The data source can be from local or remote OPC Systems Services of Tag Parameter Values. The logging can be continuous up to 100 nanosecond speed, event driven from a Tag Parameter value, a specific time of day, or based on data change in either wide or narrow table format. The database providers can be SQL Server, SQL Server Desktop (MSDE), Access, Oracle, mySQL, or ODBC. CSV logging is also possible as an output type. You can have the system automatically change the database Server, Database, and/or Table based on Tag Parameter values.
By taking advantage of the OPC Systems.NET communications from service to service you can reliably log remote data from another OPC Systems Service with no data loss. With continuous data logging if the network connection is lost between services there is no data loss with the ability to store the data buffer to disk on either network failure or database engine failure. Use the property Store Data Logging Buffer to Disk under Configure Options to set the data buffer path.
Using remote OPC Systems Services also helps simplify security connections as there will be no remote DCOM setup necessary as all OPC Servers can be connected as local.
Refer to the OPC Systems Configuration-Data Logging section for all properties of the data logging configuration.
Refer to the WinForm Example Code under the Form FormConfigureDataLogging to see how to programmatically define data logging groups.
View the following video for a short introduction to data logging.
View the following detailed video for the basics of data logging.
View the following video on how to update existing records based on a dynamic query.