Process

Promotion of code can be done in the Solution Manager (see Denodo Servers and URLs ).

The process below outlines how to create. Each revision should be added to the Revision Tracker table below for the purpose of tracking approvals.

Create a revision. All revisions should use DEV as their source environment.
1. Select your revision elements
  1. If making role changes, be sure to include all objects in any VDB associated with that role so the necessary VQL for permissions updates is generated
  2. DO NOT promote the dev role when promoting to STAGE or PROD. This will ensure that all VDB’s/Object are read only.
2. Give revision a name and description and save
3. Create a row in the Revision Tracker below for your revision
Have a peer review the revision and add their name under the Approved By column in the Revision Tracker once approved.
Deploy the revision to STAGE and perform smoke testing
If smoke testing passes, deploy to PROD
If smoke testing fails, investigate, then create a new revision to address the issues

Revision Tracker

Old revision tracking table

Date	Revision	Author	Description	Approved By
2023-06-28	46	Matthew Girard	Creates jobs to clean cache database for dental and advancement VDB’s on a weekly basis	Joseph Strinka
2023-06-22	38	Joseph Strinka	Add TTS_Facstaff permissions to grp_ir_read since IR is not in tts	Matthew Girard
2023-06-20	34	Matthew Girard	Creates connections to denododb for cache, scheduler and data catalog	James West
2023-06-13	33	Matthew Girard	Updates VDB’s to use global LDAP configuration and deploys tts_facstaff role	James West
2023-06-12	32	Joseph Strinka	Add Clickstream to Prod	Matthew Girard
2023-05-11	29	James West	Add Human Resources views and role needed.	Joseph Strinka
2023-05-03	24	James West	Add Class Enrollment views and role needed	Joseph Strinka
2023-04-18	22	James West	Updated Admissions view to use the new roles that were added	Matthew Girard
2023-04-06	19	Joseph Strinka	Add scheduler job for Research Technology
2023-04-06	18	James West	Updated Admissions view: some field names to use gs_ when specific to GSAS school	Joseph Strinka
2023-03-28	17	James West	Add Read Permissions with Dependencies	Joseph Strinka
2023-03-24	15	James West	Adds Admissions - Application Submitted view that is accessable by asg-admissions-read group	Joseph Strinka
2023-03-23	14	Matthew Girard	Updates Oracle DW Connection to include failover via connection string	Joseph Strinka
2023-02-22	12	Joseph Strinka	Adds clickstream base view in student_lifecycle VDP and sets up for denodo-mkt AD group roles	Matthew Girard