Exercise: Connect to PI System from DBVisualizer using PI SQL Client (JDBC)

Document created by kduffy on May 21, 2019Last modified by kduffy on May 21, 2019
Version 2Show Document
  • View in full screen mode

Objective: The goal of this exercise is to demonstrate connectivity to the PI System using a third party Java client.



The important point here is not that it's DBVisualizer in specific, but that it's something more functional than IPISQL and has a UI. We also know that the PI SQL Client (JDBC) will work with it, and OSIsoft Tech Support is capable of providing a small amount of guidance with it, which is not necessarily true of any arbitrary Java client that may be used. DBVisualizer also forces you to do more work than IPISQL in order to connect, so it's good practice for your Java Client.


Problem Statement:

1. Install DBVisualizer on a machine with the PI SQL Client (JDBC) installed

2. Follow Using DBVisualizer with the PI JDBC endpoints to gain a connection to an AF Server

3. Execute a query of your choice and confirm that the results are shown in the output tab


Have questions? Ask the community

When you are ready, compare your answers with the Solution: Connect to PI System from DBVisualizer using PI SQL Client (JDBC)