Connect to

The following procedure describes how to connect to PI AF server using PI SQL Client ODBC through PI SQL Commander Lite. You can use a DSN to establish this connection. For more information, see the PI SQL Commander Lite User Guide.

1. To open PI SQL Commander Lite, click Start > All Programs > PI System > PI SQL Commander Lite (64-bit).

2. In the Object Explorer pane, expand ODBC Data Sources, right-click PI SQL Client and click Connect.

3. In the PI SQL Client ODBC Login window, in the AF Server field, type the name of your PI AF server machine.

4. In the AF Database field, type the name of the PI AF database or select one from the drop-down list.

   Note: The drop-down list in the AF Database field is available only if PI Web API Core Services is installed.

5. In the Authentication area, provide credentials for a Windows user account or select Trusted Connection to use your Windows credentials to connect to PI AF server.

6. Optional: Click the Advanced tab to specify additional connection parameters such as the initial catalog, command timeout, or protocol order.

   

   Note: To access the various PI AF data sources, PI System data references, and so on, you must enter login information for an account with valid permissions for the machine that runs PI AF server.

   For more information, see the topic "Firewalls and PI AF Security" in the PI Asset Framework (PI AF) Installation and Maintenance Guide available at the AVEVA Customer Portal Products page.

7. Click OK.

   A green arrow next to the data source icon indicates that the connection is successful.

   Note: Installation of PI SQL Data Access Server (RTQP Engine) requires you to connect to the PI SQL Client. For more information, see the PI SQL Data Access Server (RTQP Engine) Administrator Guide.

If PI SQL Data Access Server (RTQP Engine) is not installed or the PI AF Server machine is not accessible, you should see an error similar to the following: