CPI Credentials Where-Used List with CPI Explorer

[fatihpense]

Hello CPI consultants,

In PI/PO you can only enter credentials to adapters. In CPI these credentials are organized in one place and you can reuse them. I believe it is a better workflow. The problem is that since CPI is very flexible & powerful you can use credentials in a lot of places like Externalized Parameters, Adapters, and Scripts. Then you have to be careful about changing or deleting credentials.

I thought it would be nice to see where these credentials are used to have an idea about the impact of changes. I developed a new free tool for this purpose: CPI Explorer. Since it requires downloading CPI content on your tenant, for security and performance reasons it is a local Windows 10 app. You can visit the Microsoft Store page to download this app.

Update(2020-08-08): Now this tool is part of Pizug Companion docker image. Check out the new application: https://blogs.sap.com/2023/08/07/companion-for-sap-cloud-integration-tools-you-love-comes-as-a-docke...

Usage

This is the end result we want:

 

Let's start from scratch. When you open the app you will see this screen. You can click on "Open CPI Explorer Page". I had to use a regular browser due to technical limitations, this may change in the future. My only advice would be to use a modern browser(everything except old IE)

First, you need to set up your tenant configuration. If you don't have a configuration you should see a warning.

Enter the information. You can write the hostname or just paste the URL of your tenant, it will be parsed. Note that your password is not stored cleartext, it will be stored in Windows Credentials Manager.

When you save your connection it checks the connection and then saves. So if you can't save it, check your username & password again.

When everything is configured correctly, you should see these green messages:

Let's switch to the "Local Artifacts" page. If you don't have any artifacts you should see:

You can click on "Start Downloading Artifacts", it will take around one minute to download your flows. You can also re-download them anytime. Here is an example:

Q: So where are these artifacts downloaded? Can I use them as backups?

A: Yes. They are downloaded under Documents/CPIExplorer. You can copy and store them as backups.

Now, you can go to the "Credentials Where-Used List" page and click on the "Analyze" button!

Installation

Update(2020-08-08): Now this tool is part of Pizug Companion docker image. Check out the new application: https://blogs.sap.com/2023/08/07/companion-for-sap-cloud-integration-tools-you-love-comes-as-a-docke...

You can install it from Microsoft Store:

https://www.microsoft.com/en-us/p/cpi-explorer/9pbkk398ww57

Conclusion

I hope it will be useful for the community. It is a very basic app and there is a lot to improve. If you have any ideas, you can comment, send a message to me, or you can use the feedback form in the app.