AVEVA PI Private Preview
AVEVA PI (AVEVA PI System) is a data management software system used for real-time data collection, storage, and analysis.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | All tables except ARCHIVE, ELEMENT, and EVENT_FRAME tables. |
| History mode | ||
| Custom data | check | All tables |
| Data blocking | check | Column level, table level, and schema level |
| Column hashing | check | |
| Re-sync | check | Table level |
| API configurable | ||
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup Guide
Follow our step-by-step AVEVA PI setup guide to connect AVEVA PI with your destination using Fivetran.
Sync overview
We update a table incrementally only if it contains MODIFIED column.
We update the ARCHIVE table incrementally based on the TIMESTAMP column.
We re-import all other tables in every sync.
Schema information
This schema applies to all AVEVA PI connectors.
To zoom, open the ERD in a new window.