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

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

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

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.

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