Share
Created By
seanb996

seanb996

shailenders

shailenders

roopalirastogi

roopalirastogi

Yamini1111

Yamini1111

Home » Challenges » Appian World 2021 Hackathon » KPMG Connected Command

KPMG Connected Command

We have leveraged the power of Appian to build a console that accomplishes providing enterprise-grade big data controls within a low code user-friendly framework.




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:
  1. Nucleus: Database monitoring and reporting, easy and immediate access of database backups and setting up scheduling, configuring automatic database alerts (based on size, table growth, etc).
  2. Backbone: Digital reference master, when values are added, modified or deactivated constants are automatically updated (both at the category level and the reference value level). Citizen developers can be provided all of the constants they require to properly query the correct lookup information, and administrators can easily review and maintain reference information through the digital form, including directly in production if controls permit it.
  3. Audit: Will leverage Appian to create database triggers that will execute on both INSERT and UPDATE so that we have copies of all tables that show a row by row history of all changes to that table's row. This will automatically create a backend audit table.
  4. Archive: Will leverage Appian to create database triggers based on inputted business rules that link with reference master Ids to automatically move data of a certain age out of tables and into an archive table, to ensure that data does not get out of control in transactional tables as time goes forward.

Anonymous
  • in reply to maksimmohnonogm8793

    Hello, friends! Enjoy33 Casino Australia is a real treasure for gamblers! A wide selection of slots and classic table games from leading software providers makes every game unique. The site's interface is very user-friendly and pleasing to the eye, which adds to the comfort of the game. I am especially impressed with the live dealer section, where you can enjoy the authentic casino atmosphere. I recommend it to everyone!

  • Hello everyone! Who can recommend a great online casino?

  • One aspect that sets porn videos apart from other sites is its commitment to providing content in HD, ensuring an immersive and visually appealing experience. Additionally, the site regularly updates its library with fresh content, keeping things exciting and new for its users. The community features, such as user ratings and comments, also add a social element that enhances the overall experience.

  • Ever since discovering this platform, my online gaming experience has been revolutionized. The user interface feels remarkably intuitive, as if it were tailored just for me. Beyond the interface, the gaming experience is so immersive, it's like stepping into another universe. The stakes are particularly high for Nigeria. To truly comprehend it, you really have to try it out. Venture into the world of yangasport and witness the transformation of your gaming landscape. I can genuinely attest to the impact it's had on my gaming experience.

  • 在选择英文论文代         http://australiaway.org/a/yingwenlunwendaixie/       机构时，可以通过与对应机构的客服或代表沟通来了解他们的服务流程和服务范围。

  • KPMG Connected Command revolutionizes crisis response with its innovative technology and real-time data analysis. I've seen firsthand how it enables organizations to make informed decisions product photo editing service swiftly, enhancing resilience and mitigating risks effectively. Its comprehensive approach to crisis management sets a new standard for preparedness in an ever-evolving business landscape.

  • Hello. Wanting to play a reliable and trusted game, I decided to try plinko game. I liked this game from the very first moment. It has a simple gameplay and cool graphics, and the winnings it offers are incredibly big. Therefore, any player will have a lot of fun with this game.

  • Finding the right videographer felt overwhelming until we discovered this link Tara Weddings . Their portfolio instantly drew us in, but it was their personable approach that sealed the deal. On our wedding day, they were everywhere and nowhere—capturing everything without ever feeling intrusive.

  • This application sounds like a game-changer for citizen developer programs! It's impressive how you've tackled the technical challenges to ensure its agnosticism and seamless deployment across various client environments. The ability to automatically pull information and perform actions without relying on local dependencies is a significant achievement. Utilizing RPA to create constants shows your creativity and adaptability. Excited to see how this tool further empowers citizen developer programs and benefits Appian clients. Great work!

  • Can someone explain to me whether tiktok has a function to watch videos offline?

© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.