Exposing PI AF Data in MS Access

Discussion created by jsilvestre on Oct 9, 2013
Latest reply on Oct 9, 2013 by LMouxDominguez

I had a question around making AF Data available in MS Access and wanted to see if anyone in the vCampus community has had experience with this in the past.  Specifically, I want to make AF data accessible to a variety of end users, therefore I want to make all the data available.  I also want to make this as easy as possible, since many of the end users will be discouraged if there is a large learning curve to get the data into Access.  My question is the following:


Which Data Access Layer would work best here?  MS Access natively supports ODBC connections and Web Services through Data Services.  Unfortunately, AF currently does not support ODBC (at least not until Q2 2014), therefore I’m left with Web Services.  Are there any other alternatives?