Promotion of code can be done in the Solution Manager (see Denodo Servers and URLs )
Process
Create a revision
If making role changes, be sure to include all objects in a any VDB associated with that so the necessary VQL for permissions updates is generated
Deploy revision to STAGE
Have a peer review the revision
Once approved, promote to PROD
...