2 Replies Latest reply: Sep 27, 2012 8:11 AM by AlexAnd RSS

    Tool to read and understand PLSQL and convert it into XML

    964839
      Hi,

      We have some code written in PLSQL (This was written by a different team). Is there any tool available which can automatically read the logic in the PL/SQL code? The code actually moves the data into database tables. We want to feed the data as source in Informatica. Is there a way to read the code and maybe covert to it to XML?

      Really appreciate the help.

      Thanks in advance!!
        • 1. Re: Tool to read and understand PLSQL and convert it into XML
          odie_63
          Hi,
          Is there any tool available which can automatically read the logic in the PL/SQL code? The code actually moves the data into database tables. We want to feed the data as source in Informatica. Is there a way to read the code and maybe covert to it to XML?
          Do you want that hypothetical tool to be able to make coffee too? :)

          Seriously, your best bet is to find someone who knows PL/SQL and that will be able to back-engineer the logic into business rules you can then implement in Informatica.
          Human brain is the right tool for the job.

          The alternative you're suggesting is not realistic.
          That would require retrieving the corresponding DIANA tree nodes (sort of pre-compiled version of the code) and interpret them.

          What XML structure are you expecting? Is it some sort of config file specific to Informatica.
          What does the PL/SQL code look like?
          • 2. Re: Tool to read and understand PLSQL and convert it into XML
            AlexAnd
            in my humble opinion - NO