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 | ARCHIVE, ELEMENT, and EVENT_FRAME tables. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | check | |
| Authorization via API | check |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
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.