AnsweredAssumed Answered

Joining SQL and PI-OLEDB data

Question asked by Todd.McQuiston on Jan 22, 2020
Latest reply on Jan 22, 2020 by Todd.McQuiston

I have a user who needs to do a SQL JOIN query between a table on a SQL server and our Production PI server via OLEDB.  Is that even remotely possible? 

 

He's using Tibco's Spotfire for this, but I cannot envision a way to make it work without somehow replicating PI data from OLEDB into a SQL table and going from there.

 

Thanks!

 

Todd

Outcomes