Does Historian need the d2 file archive when used with an SQL database?

GPA Products openHistorian
1

Hi all

I am using OpenHistorian with a Postgress SQL database and a small number of PMUs.

The d2 file archive is taking a lot of space as I am using historian to store a number of power system parameters in high resolution (100/frame).

My question is whether openhistorian needs the d2 file archiving too when used with a database. I just want to be able to retrieve data for a couple of power system parameters from a couple of PMU devices and export it to CSV for historical time periods using the web interface of historian. Is the archiving needed for this?

Thanks in advance for any advice.

Stavros

2

Hi Stavros,

Yes, in order to export to CSV using the openHistorian web interface, you will need to use the local historian which archives your data in the .d2 files you mentioned. The web interface interacts with the local historian to retrieve data from the archive and put it in the exported CSV files. If you were to use a PostgreSQL database instead, you would need to develop your own process to get the data from there into a CSV file.

Thanks,
Stephen

3

Hello!

So, I have a question that’s related to this topic.

I just configured openPDC and openHistorian so that openPDC is getting data from a PMU and it’s distributing it to openHistorian (SQL Server database). I couldn’t find out how to export the data in .d2 files to csv using the web interface or how to retrieve the data at all. How do I do that? And I also don’t know if the data is actually being archived in this file, since I don’t know what’s inside. How do I make sure my data is being recorded?

4

Hey!
Just some updates.
I used GEPDataExtractor and HistorianView and i think my application is not recording any data. I can see in the graph measurement on openPDC and also on openHistorian, but the data is not being recorded. That’s my main problem now

image
image1920×1038 259 KB

5

In openHistorian Manager, navigate to Outputs > Historian Instances in the menu. By default, you should have a historian instance called PPA of type openHistorian.Adapters.LocalOutputAdapter. Unless you changed it, archived data should go to C:\Program Files\openHistorian\Archive. If your openHistorian instance is not archiving data, that folder would be empty.

Thanks,
Stephen

6

Okay, I think the problem was on the PPA, just as you said. Now it’s working, thank you!!