How to Install PI SQL Commander

Document created by kduffy on Oct 5, 2018Last modified by jkim on Nov 8, 2018
Version 3Show Document
  • View in full screen mode

PI SQL Commander is a very important tool for developing and testing PI SQL queries.


As it's not a standalone download, the following download kits contain the application:

  • PI SQL Client
  • PI OLEDB Enterprise
    • Note: This installation kit also includes PI OLEDB Provider
    • Note: PI OLEDB Enterprise 2016 R2 and earlier require the installation of Visual Studio Shell for PI SQL Commander. This dependency was dropped in PI OLEDB Enterprise 2017.
  • PI ODBC Driver


Note: The standalone PI OLEDB Provider installation kit does not include PI SQL Commander

  • It instead includes the PI OLEDB Provider MMC Snap-in, which we will not cover in this course
  • We therefore recommend that PI OLEDB Provider customers install PI OLEDB Enterprise; this installation kit includes both OLEDB providers (Provider and Enterprise) as well as PI SQL Commander.