Verify the PI SQL Client JDBC installation

PI SQL Client JDBC includes the IPISQL command-line tool, which you can use to validate the installation on Linux, macOS, or Oracle Solaris.

The IPISQL command-line tool is located in the Tools directory of the PI SQL Client JDBC installation. IPISQL works with raw URLs. For more information, see Connection URL format.

1. Open a Terminal window.

2. To verify that the driver was added to the CLASSPATH variable, type echo $CLASSPATH.

3. Use cd to change to the following directory: Tools\IPISQL\bin in the PI SQL Client JDBC installation.

4. Type java IPISQL and press Enter.

   Note: The IPISQL command name is case sensitive and needs to be typed in all capital letters.

   You can specify the URL when you call the tool as follows:

   PIHOME\SQL\SQL Client\JDBC\Tools\IPISQL\bin>java IPISQL -url
   "jdbc:pisqlclient://myAfServer/myAfDatabase;"

   Note: If you do not specify credentials in the URL, the tool uses a trusted connection.

5. If you did not specify the URL, enter the following parameters:

   • PI Asset Framework Server Name

     The name of the PI Asset Framework. This parameter is required.

   • PI Asset Framework Database Name

     The name of the PI Asset Framework database. This parameter is required.

   • Use trusted connection?

     Whether you want to use Kerberos authentication, either Yes or No. The default is Yes. If you enter No, you will be prompted to enter credentials.

If the installation was successful, you should see results similar to the following:

Connected to PI SQL Data Access Server (RTQP Engine) 2018 SP3 Patch 3, 1.8.21196.1
Driver name: PI SQL Client, version: 4.2.22020.1.

Item: AF SDK Version: 2.10.9.593 FriendlyVersion: 2018 SP3 Patch 3
Item: AF Server Version: 2.10.9.593 FriendlyVersion: 2018 SP3 Patch 3
Item: Master Catalog Version: 2 FriendlyVersion: null
Item: Model Schema Version: 3 FriendlyVersion: null
Item: Operating System Version: 6.2.9200.0 FriendlyVersion: Microsoft Windows 10 Enterprise
Item: Query Processor Version: 1.8.21196.1 FriendlyVersion: 2018 SP3 Patch 3
Item: SQL Server Version: 15.0.2080.9 FriendlyVersion: Microsoft SQL Server 2019 (RTM-GDR) (KB4583458) - 15.0.2080.9 (X64)