How to configure database (sql lite or SQL server) to save the archive data or timeseries data


We need to save all archive data using data base instead of .d2i files. So please provide the configuration details.
Also we need to maintain separate data base for each devices, which is connected in single openHistorian.

thanks & Regards

I have a feeling that what you’re envisioning is not supported. openHistorian can certainly save historical data in relational databases, but if you do not store your data in the d2/d2i archive file format, nearly all of the existing functionality to visualize and process historical data in openHistorian will not be available to you. There is also no existing functionality for a central historian to manage a distributed set of historical archives, relational or otherwise.