PI AF Attributes in Excel

Discussion created by isolutions on Mar 14, 2012
Latest reply on Mar 16, 2012 by isolutions



For a client we are attempting to leverage AF quite a bit. The scenario of the problem we are trying to demonstrate is the following:


We have a external database table in Microsoft SQL that contains a daily value. We created a table link in AF to this Microsoft SQL database. We then created three attributes that will get the the daily value, approved status, and timestamp from the table link in AF.


What we really want to accomplish is if it is possible to use Excel to connect to the AF database and look at an attribute that will be able to dump a time range of values into the Excel spreadsheet? The idea is to allow users to leverage the AF structure and quickly identify certain attributes to look at.


Maybe this is not possible and we should directly go to the Microsoft SQL database.