Hi to everyone!
is there a possibility to have an automatic connection to PI server with PI DataLink in Excel??
Do you mean auto update?
My Excel/Data Link automatically connects if I press auto update after opening a Excel sheet.
Do you get a logon promt for PI user? If so, it's not possible to save these credentials so inorder to both secure your environment and get SSO I'd reccomend configuring windows authentication. Another workaround would be to configure a PI trust.
my question was refer to logon promt for PI use!
But if i understood well this is not possible...
We strongly recommend you to use Windows Authentication as it is more secure. Please refer to Tip 2 and 3 in this article.
KB00833 - Seven best practices for securing your PI Server
Explicit login need to use pop up dialog to login.
In PI DataLink 2015, it is not pop up. Go to Settings > Connection Manager... to connect PI Server by Explicit login.
KB00766 - PI DataLink Explicit Login and Default User Behavior
In these days, OSIsoft doesn't recommend using Explicit login because of security as Eugene Lee says.
I can think following way to connect PI Data Archive without prompt.
Create PI Mapping for everyone. (PI SMT > Security > Mappings & Trusts > Mappings) (Like Everyone = pidemo)
Or create PI Trust for everyone. (Like 192.168.1.1 NetMask 255,255,0.0 It means if Client machine's IP is 192.168.X.X then this PI Trust is used)
I know it works for some customers, but there is obviously security issue on this settings.
Retrieving data ...