Solution: PI OLEDB Enterprise Configuration

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

This document contains the answers to the Exercise: PI OLEDB Enterprise Configuration. The screenshots in this document reference the PI OLEDB Enterprise User Guide (pages 7-10).

 

Note: These answers are very similar to the Exercise for PI OLEDB Provider Configuration because these are OLEDB parameters, which follow the OLEDB protocol.

 

1. Connecting to a PI AF Server named "AFSRV01" using Windows explicit login. The Windows domain username is "OledbUsers" and password is "5q1i5|=v|\|"

answer: Provider=PIOLEDBENT.1;Password=5q1i5|=v|\|;User ID=OledbUsers;Data Source=AFSRV01;Persist Security Info=True

Note: The word "domain" was italicized to point out how unsecure this practice is. The user account's password will be stored in the connection string in plain text.

 

2. Connecting to a PI AF Server named "AFSRV02" passing the user's context via SSPI, enabling level 3 logs to a file named "C:\temp\oledblogs.txt"

answer: Provider=PIOLEDBENT.1;Integrated Security=SSPI;Data Source=AFSRV02;Persist Security Info=True;Log Level=3;Log File=C:\temp\oledblogs.txt

 

3. Connecting to a PI AF Server named "AFSRV03" passing the user's context 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

answer: Provider=PIOLEDBENT.1;Integrated Security=SSPI;Data Source=AFSRV03;Persist Security Info=True; Embed Errors=True

 

4. Connecting to a PI AF Server named "AFSRV04" passing the user's context via SSPI, setting the timezone to UTC

answer: Provider=PIOLEDBENT.1;Integrated Security=SSPI;Data Source=AFSRV04;Persist Security Info=True;Time Zone=UTC

Attachments

    Outcomes