/
Denodo Code Promotions

Denodo Code Promotions

Owned by Matthew Girard
Last updated: Dec 18, 2023
2 min read

Table of Contents

Process

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

The process below outlines how revisions are created and deployed. Revisions are reviewed by admins and deployed every Monday. Before creating revisions, make sure you’ve done adequate testing of your code.

  1. 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 any objects directly associated with that role so the necessary VQL is generated to update permissions

      2. DO NOT promote any dev roles when promoting to STAGE or PROD. Only promote read roles. This will ensure that objects are read only outside of the dev environment.

    2. Give revision a name and description and save

    3. Validate your revision against STAGE and PROD

    4. Announce the revision in #revisions in the Denodo team in Teams asking for it to be deployed at the next Monday deployment session.

  2. The admins will review your revision for security. If there are no issues, the revision will be deployed to STAGE and PROD. If issues are found, you will be asked to resolve them before deployment.

Revision Tracker

Date

Revision

Author

Description

Approved By

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