KPMG Connected Command

The inspiration for this application comes from our experience helping our clients establish citizen developer programs. When setting up these programs with our clients, we have found that without proper controls in place, citizen developers require higher level IT management to ensure that database best practices are being followed and that the data growth is sustainable. This application is intended as a tool to help facilitate setting up and monitoring those controls, with the goal of further empowering citizen developer programs with our Appian clients.

The main technical challenge we had when creating this console was making sure that it was completely agnostic, and could be deployed immediately to any client environment and automatically read all information and perform all actions. The application connects to the database without being dependent on any CDTS or table names, as it automatically pulls these items. All of the actions available were built without having to connect to any local application dependencies. We are also proud of our ability to create constants that follow our naming convention based on user provided information, as there is no Create Constant smart service, so we had to get creative in how we would create constants in the application. We decided to use RPA to accomplish this, and are currently using Blue Prism, however we are in the process of switching this to Appian RPA so we can have no outside dependencies in the app.

The four consoles we have built (2 submitted for this hackathon, 2 pending) are as follows: