PMG is serious about low code
Replace tricky, coded logic with workflows

Let’s talk about a real-world situation where a PMG customer recently faced a seemingly monumental challenge: how to safely update a piece of code that was core to several business processes.

The piece of code in question was a complex and years-old SQL stored procedure – badly in need of updates to accommodate their growing line of business. The customer had come to a difficult conclusion: there was simply no way to safely update the stored procedure without the risk of causing major issues for their business stakeholders.

The stored procedure consisted of hundreds of lines of low-level code that very few individuals in the organization could even read. This made it extremely difficult to update, test, and troubleshoot. And the stakes were high – any issue with the stored procedure could have major negative impacts to both internal and external customers. In short, the risk of touching the stored procedure was deemed too high.

But updates were still required. What to do, what to do?

Realizing that the answer may lie in the power of PMG’s Workflow Designer, the customer decided to change tactics. They recreated the stored procedure logic in a PMG workflow, which ended up taking only a matter of days.

This change in approach has paid off. Being able to view and update the process in a visual manner has given them the ability to respond more quickly to their stakeholder needs while also greatly reducing the maintenance burden for their development team. It’s been a true win-win for everyone.

Do you have a similar issue that you could solve by using a workflow?