Versions Compared

Version Old Version 48 New Version Current
Changes made by

Matthew Girard

Matthew Girard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents
minLevel1
maxLevel6
include
outlinefalse
indent
excludeContents
typelist
class
printablefalse

Process

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

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.

    Image Added

    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

Expand
titleOld 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

...

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 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

...