Introduction to PI SQL Client OLEDB linked server

PI SQL Client OLEDB is part of PI SQL Client. Analogous to PI ODBC Driver and PI JDBC Driver, PI SQL Client OLEDB is a software component interface that offers data access to the PI System through the use of SQL queries.

A linked server represents an OLE DB data source on a remote server. Remote OLE DB data sources are linked to the instance of SQL Server by using the LinkedServer object.

You can configure a linked server in SQL Server Management Studio (SSMS) using PI SQL Client OLEDB as the OLE DB provider and your PI AF database as the remote data source. This configuration allows you to query your PI AF database from SSMS and other SQL Server tools.

For more information about linked servers, see the Microsoft article Linked Servers (Database Engine).