5 Replies Latest reply on Jun 18, 2015 7:36 PM by viveks

    AF Table as a data source

    viveks

      Hi All,

       

      I created an AF table - Table 1 , importing it from an access data source

      Is it possible to create another AF Table with Table 1 as source ?

      Also, where are these AF Tables stored physically?  Am I able to access them through the PI OLEDB or PI OLEDB ENT providers??

       

      Thanks.

      Vivek

        • Re: AF Table as a data source
          David Hearn

          If you create an AFTable by importing, then the table is stored internally within the AF Server as a snapshot of the original table's data. If you create an AFTable by linking, then the source of the table remains as the external source and is queried to obtain the table's contents. So you can create 2 different AFTables both created from the same original source, but you cannot use another AFTable as the source.

          2 of 2 people found this helpful
            • Re: AF Table as a data source
              dng

              Hi Vivek,

               

              To add on to what David has mentioned, you cannot access the AF Tables via PI OLEDB Enterprise currently. We do have an enhancement request for this functionality in a future release.


              Can you let us know what information you would like to get from the tables, and why you'd like to use PI OLEDB Enterprise to access them? Also, how big are these tables? Depending on your use case, there can be a few workarounds:

              1. Build attributes with Table Lookup DataReference, and access the values via the attributes.
              2. If you are building PI OLEDB Enterprise queries in an external application, you can query the data source directly from your external application.
              3. You can take the AF Table and export it to a view definition containing the literal table data. This might work if the dataset is small.
              1 of 1 people found this helpful
                • Re: AF Table as a data source
                  viveks

                  Hi Daphne,

                  The external table contains some maintenance information about the assets that updates periodically.  Basically we would like combine the AF Tree element data and maintenance data. For eg, maintenance details of Well 1, Well2 individually and aggregated information of the production unit that comprises well 1, well 2.

                   

                  I have tried the option 1 and 2  it helps to an extent.

                   

                  @Eugene,

                  I tried that option as well. I am able to access the AFTable data and manipulate it through AFSDK application. But wanted to do the processing within AF/AFTable rather than through SDK.

              • Re: AF Table as a data source
                Eugene Lee

                Hi Vivek,

                 

                One more thing is that you can use AF SDK to access them if your application allows.

                 

                Please find a reference here.

                 

                AFTable.Table Property

                • Re: AF Table as a data source
                  viveks

                  One relief I found was the AFTable can access the SQL Views also , that gives some flexibility.