GEL Script Best Practices - sql:update vs XOG

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

What are the considerations when creating a custom GEL script and needing to update Clarity data?

Environment

All Supported Clarity Releases

Resolution

• Use XOG for core system updates to guarantee data validation, and reserve SQL Updates strictly for custom, standalone attributes
• Bypassing the application layer for values for assignments or tasks may skip some essential business logic like creating  time slices and initializing ETC curves
• XOG will guarantee data integrity, audit and maintenance on upgrades. This is the supported way to go
• sql:update may perform faster compared to XOG
• Please note direct SQL updates in the GEL scripts are unsupported and as such need to be thoroughly reviewed and tested by the process developer before moving to Production