4 Replies Latest reply on Apr 12, 2010 4:35 PM by spilon

    Expose data to other system

    formerpigeek

      In PI System, is there any module or application which will allow to export some of the data (selected data)and also to import the same data into the system?

       

      The data to be exposed is TagName and Value.

        • Re: Expose data to other system
          hanyong

          Hi Kavita,

           

          Can you tell us what task that you are tryng to work on here? It will be easier to talk about this if we know the situation better.

           

          Are you trying to export data onto a form or excel spreadsheet? Do you want to import data from a spreadsheet? a text file? or from other systems?

            • Re: Expose data to other system
              formerpigeek

              Hi Han Yong ,

               

              we need to export the data to other systems over a industry standards.

               

              Thanks

               

              Kavita

                • Re: Expose data to other system
                  andreas

                  Kavita,

                   

                  could you say more about "industry standard"?

                   

                  OPC, OLEDB, ODBC, XML, ...

                  • Re: Expose data to other system

                    Kavita Enner

                    we need to export the data to other systems over a industry standards
                    There definitely are various approaches and products to exporting PI data to other systems, using industry standards:

                    • SQL Family: products like PI OLEDB Provider and PI JDBC Driver expose PI as a relational database, allowing you to interact with tools that support these standards (see this webinar for more information)
                    • OPC Specifications: the PI OPC DA/HDA Server exposes PI as an OPC Server, supporting both the OPC DA and OPC HDA specifications. You can also look into the PI OPC UA Server, which is currently available as a Community Technology Preview (CTP) to the vCampus community (see this webinar, that other webinar and this blog for more information)
                    • Web Services: there are various ways to expose PI via web services (SOAP/XML), including the PI Web Services product that's also available as a CTP to the vCampus community (see this webinar and this blog for more information)

                    I also invite you to post questions in the relevant discussion forum on the Discussion Hall - there are forums that pertain to every one of these technologies. I will actually move this discussion thread to the PI System Integration forum as this is not exactly a PI SDK question...

                     

                    Hope this helps!