Skip to Content
Technical Articles
Author's profile photo Fatih Pense

CPI Credentials Where-Used List with CPI Explorer

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.

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

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.

 

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Yogananda Muthaiah
      Yogananda Muthaiah

      Great work Fatih impressed!!

      Author's profile photo Fatih Pense
      Fatih Pense
      Blog Post Author

      Thank you for your kind words & support Yogananda! I'm glad it is helpful.

      Author's profile photo Mohanbabu Gargisugur
      Mohanbabu Gargisugur

      Very Nice Fatih.

      How can we maintain more than one CPI host?

       

      Mohan

      Author's profile photo Fatih Pense
      Fatih Pense
      Blog Post Author

      Thanks for the feedback Mohan!

      For now, the tool doesn't support that. I tried to keep things simple for the first release. However, I agree it is necessary to add multiple hosts so I'm thinking of ways to implement it.

      You can switch hosts as a workaround since It downloads artifacts to different folders so you don't have to download artifacts every time you change the configuration.

      Best regards,
      Fatih

      Author's profile photo Fatih Pense
      Fatih Pense
      Blog Post Author

      Hi Mohan,

      It now supports multiple CPI host/tenant!

      Regards,
      Fatih

      Author's profile photo Pieterjan Luyssen
      Pieterjan Luyssen

      Hi Fatih,

      Very nice, this is really helpfull!

      Nice upgrade would be that you can give a 'where used' list for everything in the Keystore (certificates/ Key pairs/ SSH Keys)

       

      Best regards,

      Pieterjan

      Author's profile photo Fatih Pense
      Fatih Pense
      Blog Post Author

      Hi Pieterjan,

      I'm glad it was useful to you! Thank you for the feedback. It is really valuable to get new perspectives from other consultants! It helps me to prioritize my limited energy, and sometimes opens doors I can not imagine 🙂

      I'm always open to advice and discussion for the tools. I also have some new stuff in the pipeline for CPI Explorer, so check for updates from time to time 🙂

      Best regards,
      Fatih Pense