Skip to main content
Sharp PI hero illustration for PI SQL Client ODBC: Your Gateway to SQL Access for PI System Data in technical editorial style, showing data storage tanks with flow meters and streaming data pipes.
Data Management
PI System
Data Integration

PI SQL Client ODBC: Your Gateway to SQL Access for PI System Data

Unlock PI System data with SQL! This guide covers downloading, installing, and configuring PI SQL Client ODBC to query PI Data Archive and PI AF using standard SQL tools.

Tunde Okafor

10 min read

Tags

#PI Data Archive
#Data Access
#PI Asset Framework
#ODBC
#SQL
#PI SQL Client ODBC
#connectivity
#developer technologies
#AVEVA Customer Portal

About Tunde Okafor

Expert in PI System implementation, industrial automation, and data management. Passionate about helping organizations maximize the value of their process data through innovative solutions and best practices.

Still have questions?

Try PiChat — PISharp's free AI assistant for PI System professionals. Get instant answers about anything PI.

Try PiChat

Sign in to comment

Join the conversation by signing in to your account.

Comments (0)

No comments yet

Be the first to share your thoughts on this article.

Join the Conversation

Connect with PI System professionals

Join the CommunityBrowse discussions

Developer Hub

Guided tutorials and production-ready code for PI Web API

Stay Updated

Get PI System insights in your inbox

Free · No spam · Weekly

Join 70+ PI professionals

  • Free AI chat assistant
  • Community discussions
  • Expert articles
Create Free AccountAlready a member? Sign in

Related Articles

Unraveling PI System Moving Averages: Interpolation, Stepped Tags, and Accurate Calculations
2 min

Unraveling PI System Moving Averages: Interpolation, Stepped Tags, and Accurate Calculations

Unravel the mystery behind perplexing PI System moving averages, especially with step-like data. Learn how PI Point interpolation and the 'Stepped' attribute impact calculations and best practices for accurate real-time averages.

Megan Tremblay

C# Required Properties: Enforcing Nullability in PI System Applications
1 min

C# Required Properties: Enforcing Nullability in PI System Applications

Learn how to enforce required and non-nullable properties in C# applications for PI System integration, leveraging modern C# 8.0+ features for compile-time validation.

Yuki Tanaka

Calculating Yesterday's PI Tag Averages in PI AF: A How-To Guide
1 min

Calculating Yesterday's PI Tag Averages in PI AF: A How-To Guide

Learn step-by-step how to configure PI AF analyses to calculate and store yesterday's average for any PI Tag, leveraging relative time expressions without creating new PI Points.

Katarina Horvat