3 Replies Latest reply on Jan 28, 2015 11:50 AM by FranzK

    Is it possible to access AF custom table in AF SQL Server database ?

    ashish.thakur

      Hello Experts !!

       

      I created a custom table in  AF using System Explorer but wanted to know if this table could be accessed in the PIFD database using.

       

      Thanks,

       

      Ash

        • Re: Is it possible to access AF custom table in AF SQL Server database ?
          Karl.Hodgkiss

          Hi Ash,

           

          From the User Guide if it helps:

           

          PI AF saved library

          The PI AF saved library provides a collection of application or domain specific objects that you

          can import into a PI AF database. Saved libraries typically include categories, element

          templates, enumeration sets, reference types, tables, and the unit-of-measure Database.

          However, when you save a library, you have the option to include other objects, such as

          elements and notifications. While the UOM Database is not shown within the Library tab in the

          Navigator Pane, it is always included as part of saved libraries.

          Note:

          Libraries are stored as XML within the AF SQL Database. This is very different from the

          Export to File option, which exports an entire database as an XML file.

           

          .

          1 of 1 people found this helpful
          • Re: Is it possible to access AF custom table in AF SQL Server database ?
            FranzK

            If you want to access the Data of the AF Table (Library->Tables) with MS-SQL e.g. Stored Procedures... you can find the informations in the SQL-Table dbo.AFTableVersion. In the row datatable you find the DataSet (xml encoded like Karl did already mention).

            e.g. i did configure a Table "Proben1":

            2015-01-28_12-46-48.jpg

             

            in SQL Management Studio it looks like this:

             

            2015-01-28_12-49-30.jpg

             

            Regards

            Franz

            1 of 1 people found this helpful