Connection to PI AF Server

PI SQL Client ODBC allows applications to access the PI System through ODBC. Applications can be the iPiSql test application provided with the PI SQL Client ODBC installation, a third-party application such as Microsoft Excel, or an application you have developed.

You can define the ODBC connection using the following methods:

• Data Source Name (DSN)

• Connection string

The type of connection needed is determined by the application that you are using.

To test the connection do one of the following:

• Click Test Connection when you configure the DSN.

• From a third-party application, select the DSN. If you are not using integrated security, you will be prompted to enter the user name and password for the connection.

• Use a connection string. For example, you can use a connection string with the iPiSql test application.

The TrustedServersOnly registry key, located at HKLM\SOFTWARE\PISystem\PI SQL Client, enables or disables HTTPS connection to a server with an untrusted certificate. For backward compatibility, the TrustedServersOnly key is set to 0 by default, which allows connections to servers that use a certificate that is not in the trusted certificates list of the client machine. As a security best practice, OSIsoft recommends that you set it to 1 to prevent these connections.