Using DBVisualizer with the PI JDBC endpoints

Document created by kduffy on Oct 1, 2018Last modified by kduffy on May 21, 2019
Version 3Show Document
  • View in full screen mode

KB00912 describes the step by step process of using either the PI SQL Client (JDBC) or PI JDBC Driver within DBVisualizer to connect to the PI System.

 

This is an important tool as it's a free, third party client tool that can be used to test functionality of the PI JDBC drivers and to develop the JDBC URLs that must be used in your own client.

 

PI SQL Commander, however, should still be used for the testing and developing of queries that will be run from the JDBC application (in both cases, the query development would be done using the corresponding OLEDB endpoint)

Attachments

    Outcomes