Option 1: RDBMS Interface :-)
Option 2: How often do you refresh the table lookup? How often does the remote table update? Do you want want to update on demand (adhoc) or on a schedule or when remote table updates?
Thanks for the response.
I should have mentioend in question that answer should be except RDBMS interface .
I'm interested more in option 2:
How often do you refresh the table lookup? How often does the remote table update?
Let's take 2 cases here :
Case 1: Remote table updates every minute/second, i.e., fast refresh
Case 2: Remote table updates every day/hourly, i.e., slow refresh
Do you want want to update on demand (adhoc) or on a schedule or when remote table updates?
I would like to update whenever remote table updates in almost all cases. Would like to know your thoughts on how can I update table on demand ?
2 of 2 people found this helpful
What I usually do is model two separate attributes: one with a Table Lookup Data Reference, and another with a PI Point Data Reference. Usually my structure looks something like this:
Then, in I will create an AF Analysis that simply takes the Table Lookup value and writes it to the PI tag:
It is recommended to set the AF Analysis to run periodically with this approach.
Thanks for the detailed reply.
I usually follow the same practice. I was just thinking that has somebody made or found any workaround for this rather than create analysis for assignment, because it's tedious process for more # of attributes.