AnsweredAssumed Answered

Access a PI SQL Table from Linked Server

Question asked by GregMcFarlane on Jan 8, 2020
Latest reply on Jan 13, 2020 by GregMcFarlane

I have searched the question DB and can not find something similar 

I have also reviewed all the Query compendium and nothing strikes me.... 

 

 

We have a SQL table name EquipmentInfo in  our PI Library

I would like to access that through via a LINKED SERVER 

 

I would like to use PI SQL Client if possible

I also have PI Ole DB Enterprise connected 

 

I would think it would be something like 

 

select * from PI_PSC.?.?.EquipmentInfo

                       /\--- linked server name

                                    /\ ?Tables?

                                        /\ ????? 

 

 

any help appreciated

Outcomes