2 Replies Latest reply: Nov 30, 2015 5:51 AM by Michael Moore RSS

    Monarch Data Pump 10.5 Process Information Export

    Michael Moore

       

      I am running Monarch Data Pump 10.5, and am trying to extract information about my processes (project name, model name, input file, export file, etc).  Does anyone in the community have experience with 10.5, and know how to export this information?  I'd prefer to get all the processes at once, but can export one at a time if need be.  Thanks!

       

        • Re: Monarch Data Pump 10.5 Process Information Export
          Olly Bond

          Hello Michael,

           

          There's an Export All Processes option in DataPump, which exports the XML details of each process. However, this doesn't do much more than capture the sequence of projects, and the distributions of the exports. The model files are only reference in the XML project files itself, as are the input files. The model files contain the details of external lookups, filters, and so on.

           

          You _can_ recurse through the job logs to get the sequence of projects and then parse the XML xprj files for the reference to xmods and try to glue the whole thing together. Or if you upgrade to DataPump v11, then the job logs are verbose and contain all the information you need.

           

          I would like to say that upgrading to v12 or v13 would help, but the introduction of the Digital Object Repository meant that instead of references to:

           

          \\networkshare\folder\process\project01.xprj

           

          ...we are faced with:

           

          dor://57fadspgap934056702936660aw

           

          which isn't quite so helpful.

           

          I'm hoping to get to grips with the issue a bit more in Q1 - because I've built a utility that generates editable Visio flow diagrams from job logs and it's a shame to see it go to waste. If you'd like to see a sample of the output from a v11 job log, please do let me know.

           

          Best wishes,

           

          Olly