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

[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