4 Replies Latest reply on Feb 27, 2021 10:48 PM by Syed Aziz

    JSON Target File on PowerCenter Standard Edition - 10.4

    R R New Member

      Hi All,


      In Informatica PowerCenter - 10.4., I need to create output file in JSON Format. Can anyone let me know what are all the possible ways to create JSON Format Output file ?

        • 1. Re: JSON Target File on PowerCenter Standard Edition - 10.4
          Syed Aziz Guru

          Hello RR,


          No, PowerCenter does not support files that are in Java Script Object Notation (JSON) format. Pmdtm is only capable of reading flat files (fixed or delimited), XML files, and so on. JSON is not a format that is readable by the dtm code or by the Designer for parsing the metadata.


          To read JSON, use a Java transformation and output in XML or write to a database.


          B2B Data Transformation offers out of the box handling of the JSON Format.


          For B2B Data Transformation 9.1 to 9.5.1 HotFix 1, an additional block to support JSON Format can be downloaded from the Informatica Marketplace:

          B2B DT : Data Transformation JSON Support



          Starting B2B Data Transformation 9.5.1 HotFix 1, the support for JSON format is built in to the product and there is no need to download the Marketplace block.


          In addition, the JSON format is also HParser offering. Refer to the following links on the Informatica Marketplace for more details: HParser Community Edition


          JSON data extracts are handled through B2B Data Transformation project creation. 


          B2B Data Transformation supports JSON through an import mechanism (such as, same as COBOL); upon loading a JSON object, a parser/serializer/XSD would automatically be generated.





          JSON is an alternative to XML and is used to store information in flat files. It could be used between different platforms that run Java.

          For more information on JSON, see Introducing JSON

          For more information on JSON and XML, see JSON: The Fat-Free Alternative to XML


          Best regards,





          • 2. Re: JSON Target File on PowerCenter Standard Edition - 10.4
            Asmita Kesarwani Guru

            Hi RR,


            Thank you for posting your query.


            If you would like to generate the JSON output using PowerCenter Designer, then you will need to make use of the Java Transformation and write custom java code to achieve this.


            If you plan on using the developer client , then you can make use of the data processor transformation.

            Below are the steps for the same :



            Please let us know if this helps.




            • 3. Re: JSON Target File on PowerCenter Standard Edition - 10.4
              Nico Heinze Guru

              Not 100% correct with regard to PowerCenter.

              It is quite possible (and has been done by quite a few people who have asked on this forum) to create the JSON contents using an Expression transformation. Whether this works or not in any particular use case, that's a different question and needs to be answered for each case individually. That mainly depends on the complexity of the JSON structure.

              Making a simplified statement here, if the JSON output is not hierarchical, then an EXP should work fine. If you do have to create JSON output with more than one hierarchy level, then it might be necessary to use a Java transformation. However, to give really educated advice, we would need to see a typical sample output case.


              Either way, in general it's not as easy with PowerCenter to create JSON output as it may be with the Informatica platform (where you use the Developer client).




              • 4. Re: JSON Target File on PowerCenter Standard Edition - 10.4
                Vasudevan TS Guru

                As Nico mentioned, it would be different for case by case. When you have complex hierarchy, its not very easy to create the output with existing transformation other than JAVA transformation on it.

                1 of 1 people found this helpful