Archiving phasor data to portgresql(pgAdmin 4) database from openPDC

[BALAJI_TS]

Greetings for the day,

I am new to openPDC and historian concepts, I am facing issues to understand data archiving from openPDC. I am having a PMU connected to openPDC and I can view the PMU measurements in openPDC. Now I want archive or send this phasor measurements to postgres(pgAdmin 4) database. Can some one tell me how to do this, help me with configuration steps to do this.

Thank You.

Regards,
Balaji

[ritchiecarroll]

You can certainly add a time-series library (TSL) adapter, e.g., the AdoAdapters, that will archive measurements to a database. Do be aware that this will be very limiting, especially for streaming synchrophasor data, on the volume of data that can be stored effectively - however, for just a few PMUs you should be fine.

For larger scale archiving, we recommend a system like the openHistorian which was designed to archive large volumes of streaming measurement data at high speeds.

For guidance on setting up the AdoAdapters to archive data, I suggest starting here:
openHistorian Historian data to be saved into RDBMS (Oracle/Sql Server) using AdoAdapters - GPA Products / openHistorian - GPA Product Discussions (gridprotectionalliance.org)

Then searching for other discussions related to AdoAdapters and/or database archiving.

Thanks,
Ritchie

[BALAJI_TS]

Thank You for the response Ritchie,

Currently I am trying to archive data to SQLite database by reffering the link provided by you and the below link.

openPDC with external database

Thank you so much for your answers and suggestions. These are very important points we need to test. The idea on our side it to have an external database of “pure” phasor data to be processed later (in a way that we don’t define yet, just want to store the data). Now we are at the proof-of-concept level and that is why we focus on SQLite. We will test your suggestions asap. Thanks again, Anna

I have configured my connection string as given in the above links. And this is my connection string.

BulkInsertLimit=500; DataProviderString={AssemblyName={System.Data.SQLite, Version=3.43.1,
Culture=neutral, PublicKeyToken=db937bc2d44ff139};
ConnectionType=System.Data.SQLite.SQLiteConnection;
AdapterType=System.Data.SQLite.SQLiteDataAdapter}; DbConnectionString={Data
Source=D:\OpenPDC_database\MeasurmentDB.db}; InputMeasurementKeys=9f5526ee-5d8b-44f6-9fc1-c42540d82665;
TableName=TimeSeriesMeasurement; IDFieldName=SignalID; TimestampFieldName=Timestamp;
ValueFieldName=Value; SourceIDs=PPA

I am using SQLite Version 3.43.1 in my system and i have created MeasurementDB.db file D:\OpenPDC_databse folder. And I have created a table named TimeSeriesMeasurement in SQLite database.

After all the configuration, when I click Initialize button I am getting the below error. What might be the reason for this error?

And I have few doubts related to database and connection string.

1. Do we need to keep sqlite3 file in MeasuremntDB.db folder and create table in that place using sqlite command line? Or how it should be done?

2. In Connection string what does SourceIDs=PPA this element indicate?

3. And in openPDC-> Historian Instances. Do we need to configure Primary Phasor Archive part also?

Thank You.

Regards,
Balaji TS