3 Replies Latest reply on May 10, 2021 11:21 AM by Nico Heinze

    Mapping and Workflow documentation

    Dianna Gibbs Seasoned Veteran

      Is there an easy way to export mappings and workflow into a documentation type form of document?  I saw a link to Marketplace but doesn't work.  I also understood I could "export metadata" to Excel but I do not have that option.

       

      Any thoughts or direction appreciated.

        • 1. Re: Mapping and Workflow documentation
          Syed Aziz Guru

          Hello Dianna,

           

          There is no specific tool that can be used to create a comprehensive documentation on a mapping and all objects contained in it.
          But, there are a few options that can be used in a very similar fashion as listed below.

          Workaround

          Here are some current options to look at:

          Mapping Dependencies (Mappings > Dependencies)

          The object dependencies option can be used to document a mapping as follows:

          1. Open the mapping in Designer.
          2. Go to Mappings > Dependencies...
          3. Select All Children and All Parents.
          4. Click OK.
          5. Select File > Save to File.
          6. Select either HTML or text format.

          This will create a formatted file with information on the mapping and its dependant objects.

          Mapping Report

          The PowerCenter Mapping Report can be used to document a mapping as follows:

          1. Right-click the mapping.
          2. Select View Mapping Report.
          Note

          This option requires a Reporting Service with the Repository Reports option and is available in PowerCenter 8.5 and later releases only.

           

          Also, as per, "Exporting and Importing Multiple Objects and Object Types"; you would be able to export them separately, for example:

           

          exporting and Importing Multiple Objects and Object Types

           

          You can export and import multiple objects and multiple object types at the same time. However, the combination of object types depends on the PowerCenter Client application you use.

           

           

          The following table lists the multiple objects you can export and import:

           

           

          PowerCenter Client Application

           

           

          Options for Exporting

           

           

          Options for Importing

           

           

          Repository Manager

           

           

          • Multiple objects from one folder

             

          •  

            Multiple object types from one folder

             

          For example, you can export multiple mappings to the same file.

           

          • Multiple objects from multiple folders

             

          •  

            Multiple object types from multiple folders

             

          When you import objects from multiple folders, you can choose which folders to import into.

           

          pmrep

           

           

          • Multiple objects from multiple folders

             

          •  

            Multiple object types from multiple folders

             

          For example, you can export reusable transformations and reusable worklets to the same file.

           

          • Multiple objects from multiple folders

             

          •  

            Multiple object types from multiple folders

             

          When you import objects from multiple folders, you can choose which folders to import into using the control file.

           

          Designer

           

           

          • Multiple sources, targets, or reusable transformations from one folder

             

          For example, you cannot export both sources and targets from the Navigator. You cannot export multiple mappings or mapplets.

          You cannot export multiple object types.

           

          • Multiple objects from one folder

             

          •  

            Multiple object types from one folder

             

          You can only import Designer objects.

           

          Workflow Manager

           

           

          • Multiple reusable Email, Session, and Command tasks from one folder

             

          •  

            Multiple worklets from one folder

             

          •  

            Multiple workflows from one folder

             

          For example, you can export a reusable Email task and a reusable Session task.

           

          • Multiple objects from one folder

             

          •  

            Multiple object types from one folder

             

           

          You can only import Workflow Manager objects.

           

           

          You can export different object types from all PowerCenter Client tools by exporting the results of an object query.

           

          Best regards,
          Syed
          • 2. Re: Mapping and Workflow documentation
            Anukrati Tiwari Guru

            Hi Dianna,

             

            Mostly it's not possible. Would it be possible for you to let us know the use case so that we can help you.

             

            Thanks

            Anukrati

            1 of 1 people found this helpful
            • 3. Re: Mapping and Workflow documentation
              Nico Heinze Guru

              I know a few partner companies who have produced tools to create documentation for workflows, mappings, and the like. If you would like to get more information, please contact me off-list.

               

              Regards,

              Nico