How does the PI RDBMS interface know what SQL Query to pick for execution?? In the Interface configuration we just specify the SQL Folder but not the query and Tags have the alias configured in the Extended descriptor.
Please have a look at this video OSIsoft: What is the PI Interface for Relational Database (RDBMS)? - YouTube It should have the answer you are looking for.
If you will be using tag group strategy, please look at the video number 5.
THanks for guiding. The video shows the location of the file, but was curious to know what happens in case of multiple sql files and which one would be picked from the SQL folder.
Instrumenttag point attribute will let you specify different sql file.
There is also distribution strategy to configure PI Interface for RDBMS. Here is the video RETIRED OSIsoft Read RDBMS/SQL data with a Tag Distribution query [PI RDBMS] - YouTube, but for some reason it has a Retired word in it...
The idea is having a distributor tag for each sql file with some target tags. Here is what the configuration look like:
I hope this help.
Retrieving data ...