Connect to PI Data Archive using PI OLEDB Provider

In PI SQL Commander Lite, verify that the Object Explorer pane is visible. If it is not, restart PI SQL Commander Lite.

1. In the Object Explorer pane, double-click PI OLEDB Provider to expand the list of available PI Data Archives.

2. Optional: Manually add more PI Data Archives.

   1. Right-click PI OLEDB Provider and click Add PI Data Archive.

   2. In the Add PI Data Archive window, enter the name of a Data Archive and click OK.

3. Do one of the following:

   • Double-click a Data Archive in the list.

   • Right-click a Data Archive in the list and click Connect.

     

4. In the PI OLEDB Provider Login window, provide credentials for a Windows user account, or select Use Windows NT Integrated security to use your Windows credentials to connect to Data Archive.

5. Optional: Click Options to specify additional provider options such as a log file, log level and extended properties, and additional PI SQL options such as time zone.

   For more information about setting configuration options, see the PI OLEDB Provider User Guide available at the AVEVA Customer Portal Products page.

6. Click OK.

   An arrow next to the server icon indicates that the connection is successful.