Full synchronization of RDB time series to PI Data Archive
- Last UpdatedNov 18, 2022
- 1 minute read
- PI System
- Interfaces
This query keeps events in an RDB table on the floating interval of one day (GETDATE()-1) in sync with events in Data Archive.
SELECT Timestamp, Value, 0 FROM Table16 WHERE Timestamp > getdate()-1;
Configure the target PI point with the following settings:
|
Point attribute |
Description |
Setting |
|---|---|---|
|
Location2 |
First row/all rows |
1 (All rows are processed) |
|
Location3 |
Data distribution strategy |
0 (Single) |
|
Location4 |
Scan class |
1 |
|
Location5 |
Exception reporting |
4 (Enables the full sync mode) |
|
InstrumentTag |
Name of the SQL file |
Example16.SQL |
|
Point Type |
Data type of PI point |
Float32 |
In the RDBMS, create a table formatted as follows:
|
Column name |
Column data type |
|---|---|
|
SQL Server data type |
|
|
timestamp |
DateTime |
|
value |
Real |
The following startup parameters must be specified:
/SYNC_TIME=*-24h,*
/LB