We have a requirement where there is an external SQL server (table) and the data from there needs to be pulled into PI AF Attributes. We have below 3 options in mind -
1) Create AFSDK code and write data to PI AF Table, and have attributes pull data from this table
2) Create AF Table Connection with SQL queries pulling the data directly from the external table and dumping into AF Table (again have AF Attributes read from this table)
3) Create AF SDK code to write data directly to AF Attributes
Which one of these might be the best option from performance perspective and best practice perspective as well ? Will the 2nd option screw up the performance- is AF Table connection performance expensive ?