Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Data Archive Reference

TABLE OF CONTENTS

PI SQL Subsystem

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedMar 17, 2025
  • 1 minute read

PI SQL Subsystem (pisqlss) prepares and executes SQL statements to be run by Data Archive. The primary users of this subsystem are the PI ODBC driver and the PI SDK. This driver conforms to the ODBC API standards and makes PI data appear to be organized into data tables. PIODBC1.1.2 or later is required to connect to Data Archive.

AVEVA's implementation of SQL gives applications access to the PI Point Database, snapshot, and archive. For supporting information, such as details of AVEVA's implementation of SQL, see the PI ODBC Client User Manual.

TitleResults for “How to create a CRG?”Also Available in