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		All tables except the `ARCHIVE`, `ELEMENT`, and `EVENT_FRAME` tables.
History mode
Custom data
Data blocking		Column level, table level, and schema level
Column hashing
Re-sync		Table level
API configurable		API configuration
Priority-first sync
Fivetran data models
Private networking		AWS PrivateLink with self-configuration support Azure Private Link with self-configuration support Google Cloud Private Service Connect with self-configuration support
Authorization via API

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.

Follow our step-by-step AVEVA PI setup guide to connect AVEVA PI with your destination using Fivetran.

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.

This schema applies to all AVEVA PI connections.