3 Replies Latest reply on Apr 23, 2021 1:40 AM by Nico Heinze

    DBConnection impact when used in Application Connection type. PC10.2HF1 to PC10.4.1 or PC10.5

    user151735 Active Member

      Hello Everyone,

       

      We are in the process of upgrade from 10.2HF1 to 10.4.1 or 10.5.  I came across an issue with the Application connectors with 10.4.1 where the standard or DBConnection*** does not support of Application Connection Type.

       

      Example:

      PowerCenter 10.2 HF1

      $DBConnectionABC=ABCDB  -- TYPE Netezza Application Connector

       

      PowerCenter 10.4.1 or 10.5

      The below mentioned Application type has to be changed in both session parameter and also in parameter file, then only it will work.

       

      $AppConnectionABC=Application:ABCDB.

       

      Do anyone of you have experienced when you have upgrade from 10.2 to 10.4 or 10.5?  Please share your experience with this.  In case if you have modified this connection type Parameter value globally, can you share the process you had implemented.

       

      Thank you,

      Gurudutt

        • 1. Re: DBConnection impact when used in Application Connection type. PC10.2HF1 to PC10.4.1 or PC10.5
          Syed Aziz Guru

          Hello Gurudutt,

           

          You could select an Application connection type to access PowerExchange sources and targets.  In 10.5 you could use a relational connection object for each Netezza source or target that you want to access.  The relational database connection defines how the Integration Service accesses the underlying database for Netezza Performance Server. When you configure a Netezza connection, you specify the connection attributes that the Integration Service uses to connect to Netezza.

           

          Best regards,

          Syed

          • 2. Re: DBConnection impact when used in Application Connection type. PC10.2HF1 to PC10.4.1 or PC10.5
            user151735 Active Member

            Hello Syed,

             

            Appreciate for responding quickly.  What you have suggested is for new development which is the best practice.  If we already have 1000's of workflows in Production does it going to impact?  Is there any Global Change that was part of the 10.5 upgrade recommended by Informatica.  Let me know?

             

            Thank you

            • 3. Re: DBConnection impact when used in Application Connection type. PC10.2HF1 to PC10.4.1 or PC10.5
              Nico Heinze Guru

              I don't know whether this is taken care of as part of a repository upgrade, but if not, there is a possible strategy. Not nice but works.

               

              Export all affected workflows to XML files (e.g. one XML per folder).

              Build a process to patch these XML files such that the relational Netezza connections are replaced by Netezza application connections. In a XML export, that should only take one string replacement, no more.

              However, it is important that these connections are set up in the target repositories before these XML files are imported, otherwise you will end up with 1000s of invalid sessions / workflows.

               

              In other words: the upgrade process will become more complex because you cannot simply upgrade the repository contents IF that should not be part of the built-in upgrade process. But it is possible.

               

              Regards,

              Nico