AnsweredAssumed Answered

Best way to pull data into PI from a SQL server

Question asked by vankudrea on Sep 10, 2019
Latest reply on Oct 2, 2019 by vankudrea

Hi,

 

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 ?

 

Regards,

Amit Vankudre

Outcomes