openHistorian as TimeSeries DB

GPA Products openHistorian
1

Hi,

I’m studying openHistorian for use with our transactional applications that deals with huge timeseries datasets in relational databases (e.g. SQL Server).

My goal is move timeseries data (tables) from SQL Server to openHistorian. To make this happen I have 2 doubts:

  1. How to migrate data?
  2. How can I change my apps to write ditectly to OH.

What’s the best approach to do this? STTP? I searched for examples on how to write data in OH through STTP, but I only found examples to read from OH.

Thanks in advance!

2

You can use the openHistorian API, for example, here’s the one in Python:

openhistorian · PyPI