Technical Articles
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.
Great work Fatih impressed!!
Thank you for your kind words & support Yogananda! I'm glad it is helpful.
Very Nice Fatih.
How can we maintain more than one CPI host?
Mohan
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
Hi Mohan,
It now supports multiple CPI host/tenant!
Regards,
Fatih
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
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