Exercise: PI JDBC Driver Configuration

Document created by kduffy on Sep 25, 2018Last modified by kduffy on Jul 2, 2019
Version 11Show Document
  • View in full screen mode

Objective: The goal of this exercise is to demonstrate understanding of how to set certain parameters at the connection level for PI JDBC Driver connections. Since the PI JDBC Driver routes its connections through a PI SQL Data Access Server, which then uses either PI OLEDB Enterprise or communicate with an AF Server or the PI OLEDB Provider to communicate with a PI Data Archive, some of the configurations are done at the provider level and some at the JDBC driver level.

 

Approach:

Using the following resource:

  • Not authorized to view the specified discussion 2658

As well as these additional resources:

 

Problem Statement:

Configure a JDBC URL for the following scenarios:

 

1. A Windows application routing through a PI SQL DAS named PISQLDAS01 using exlicit login, connecting to a PI Data Archive named "PISRV01" using explicit login. The PI user is "OledbUsers" and the password is "5q1i5|=v|\|"; the domain username is "DomainOledbUsers" and password "5q1i5|=v|\|".

 

2. A Windows application routing through a PI SQL DAS named PISQLDAS01, connecting to a PI AF Server named "AFSRV01" using Windows explicit login. The Windows domain username is "OledbUsers" and password is "5q1i5|=v|\|".

 

3. A Windows application routing through a PI SQL DAS named PISQLDAS02, connecting to a PI Data Archive named "PISRV02" passing the user's context from start to finish via SSPI, disabling asynchronous PISDK calls.

 

4. A Windows application routing through a PI SQL DAS named PISQLDAS02, connecting to a PI AF Server named "AFSRV02" passing the user's context from start to finish via SSPI, and when an error message is encountered for a value, it's embedded into that cell in the result set instead of erroring the query.

 

Have questions? Ask the community

When you are ready, compare your answers with the Solution: PI JDBC Driver Configuration

Attachments

    Outcomes