Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
santhosh_kumarv
Active Contributor
6,785
Mapping Documenter Tool! This can be my 10 Year Challenge 🙂

In Oct 2009 I released a Java tool for documenting SAP PI Message Mapping and 10 years later I'm here today with a similar tool for documenting SAP CPI Message Maps. Thanks to r_herrmann to inspire me with his CPI Dashboard tool. This gave me idea to tool my standalone java code which I have been using for a while to both document and analyze SCPI Maps.

Without wasting any more time, lets see about the tool, how to download, configure and use it.

About the Tool


It's a fairly intuitive Web frontend page that allows to navigate to the required maps.



Upon navigating and selecting the Map, the tool process the metadata of Map and generate an table with the source, target fields and constants, function used in transformation. The result entries can be searched/filtered in the UI and also can be downloaded as Excel.

  • The tool works for both CPI and ESR Maps imported into CPI.

  • It works only for the Editable Integration Package and not Configure Only Integration Package.

  • It works only for the Versioned IFow's. In other words it does not work for IFlows in Draft Version (Exception being the initial Draft which is actually version 1.0.0).


Download


The Frontend and the service to feed data are built as a Composite IFlow. You can download it from Git Repository here.

Configure


1. Import the IFlow in to an Integration Package.



2. Configure Sender Webbrowser: It has 5 HTTP Channels sharing a common URL Base Path and Role parameters.













Tool_base_URL  URL Path Prefix that you want to access the tool from.
User Role The Role to limit access to the tool.

I recommend creating a custom role to enable tool Access. New custom role can be created in the Runtime Node following this Guide. It will avoid assigning ESBmessaging.send role to Tool users which result in giving them unintended IFlow execution rights ( since it's common practice to use the default role for all IFlows).


3. Configure Receiver SAP_CPI: It has 4 HTTP Channels to consume SAP CPI ODATA APIs. The channels are sharing the configuration parameter for TMN host and Credentials.













SCPI_Host  SAP CPI tenant management node Host Name
Credential Name  Security Material / User Credential Artifact Name with TMN User/Password

4. Save and Deploy IFlow.

Using It


Copy the Main Page URL from the Deployed IFlow and open in a Browser.



The WebApp open with the Integration Package preloaded. Upon selecting the Package, the Integration Flows in the package is fetched real-time and similarly the Message Mapping. When the Map is selected the table is populated with the mapping data and can also be downloaded as Excel.



 

Happy Using! Please feedback and report any Error / Inconsistency which would help me to improvise the tool.
17 Comments
Labels in this area