7 Replies Latest reply on Oct 19, 2016 1:27 PM by chuck

    Connect to AF from Open VMS

    Christian.hetu

      There is any way to connect to the AF Database from an Open VMS Application?

      Can I connect directly to the SQL Database to query the table directly from ODBC and where I can find the AF Database model to do so?

        • Re: Connect to AF from Open VMS
          andreas

          You can *not* connect to the SQL database directly. I can see only two options:

           

          - If you are able to consume a webservice from Open VMS (Unfortunately my Open VMS experience is quite outdated, so I don't know)

           

          - If you are able to connect to a MS SQL Server from your OpenVMS machine you might be able to use a linked server via PI OLEDB Enterprise.

           

          Just out of curiosity, running on VAX, Alpha or Itanium?

          1 of 1 people found this helpful
            • Re: Connect to AF from Open VMS
              Christian.hetu

              We are running it on Alpha.

                • Re: Connect to AF from Open VMS
                  chuck

                  OSIsoft support for it's products on OpenVMS platforms is ending during 2016.  Customers should consider moving applications from OpenVMS to other platforms, such as Windows and then develop new applications and connections to PI using developer technologies such as AF-SDK or PI Web Services. 

                • Re: Connect to AF from Open VMS
                  chuck

                  Unfortunately there probably isn't an ODBC or Web Service application available for OpenVMS.  This  based on the fact that most PI System users are operating OpenVMS versions like 6.x or 7.x.  There may be third party open source support for Web Service or ODBC, but OSIsoft has not tested any of these applications. 

                   

                  Most customers with application needs like this usually write some code on the OpenVMS side of things to connect to other applications on the Windows side of things.  On the Windows side of things PI-SDK or AF-SDK calls are used to get/put data. 

                • Re: Connect to AF from Open VMS
                  SPaquinAgro

                  An OpenVMS application is a standalone executable (not talking about PI on OpenVMS here). An OpenVMS application can use ODBTP to connect to any ODBC data source and AF is available with the PI ODBC driver.

                   

                  Taken from PI ODBC documentation, PI ODBC employs the PI OLEDB Enterprise and PI OLEDB Provider query engines to connect to the PI System and execute queries. AF can be queried with PI OLEDB Enterprise.

                   

                  Note that ODBTP can also be used to connect to any ODBC data source, including SQL Server.

                    • Re: Connect to AF from Open VMS
                      chuck

                      Our best recommendation is to migrate PI2 server from OpenVMS to PI3 server on Windows. 

                       

                      Applications on OpenVMS with PI2 server or PINet (PI-API-OVMS) present will NOT be able to connect to or reference data from PI AF server.  There never was a PI-SDK or AF-SDK for the OpenVMS platform.  On Windows platforms, there was never support within OSIsoft 64 bit product implementations for connections with OSIsoft products on OpenVMS platforms.   While there was PI-API-OVMS available within implementation of PI2 server or PINet, the PI-API on OpenVMS tended to be a subset of functionality found on Windows and UNIX platforms and feature sets of PI-API on OpenVMS tended to lag behind implementation of PI-API features found on Windows and UNIX platforms.

                       

                      Best you might expect is being able to read data from a PI2 server via ODBC calls, not the other way around.  (Don't expect to be able to read data from a PI3 server or PI AF server using the PI-ODBC drivers on an OpenVMS node.)

                    • Re: Connect to AF from Open VMS
                      chuck

                      Hi Stephane

                      PI AF 2x cannot connect to OpenVMS PI server (PI2).  If the PI server is version 2.1.2 or later, there may be a limited functionality PI-ODBC server, however, PI-ODBC was an optional component - a component your PI system might not be licensed for.  As Andreas suggests, most folks write some code on the Windows and OpenVMS sides of things to accomplish communications and data passing. 

                      Do you know what your PI system number is?  What is the location of your PI system?