Versions Compared

Key

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

...

Google Drive Live Link
urlhttps://drive.google.com/drive/folders/1EPPtyvkpzHtBEJ0xYMfGC6LAbYXN8ZKW

Release Details

When: 12/12/2022

Responsables: Julien COUPE/Mourad GHISSASSI

Environment type: PROD/PRE-PROD

Version: 1.0.3

JIRA : https://solvayagile.atlassian.net/jira/software/c/projects/PA/boards/297

Target Environment

GCP

prj-carbon-footprint-prod

prj-carbon-footprint-pre-prod

Talend Server

ce-ew1-b-talend-gcp-remote-engine-prod

ce-ew1-b-talend-gcp-remote-engine-pre-prod

Talend Exploits

rds-ew1-tlnd-p-mssql-01

rds-ew1-tlnd-v-mssql-01

Requirements

Release Steps

Files and Folders

Cloud Storage

  • Create folders : Buckets already created in PRE-PROD and PROD
  • Add all manual files

BIGQUERY

  • Create the following dataset: CLC
  • Run the last query of following script : Create tables
  • Delete tables after good run

TMC

Project: Ind_PCF

Create the following Talend flows:

...

Type

...

Flow/Job

...

V.

...

Trigger - Cron

...

Task

...

F006_OrchFlow_PCF_Monthly_GCS

...

0.1.0

...

Every 6th of each month

Update the following Talend flows: version

...

Type

...

Flow/Job

...

V.

...

Trigger - Cron

...

Task

...

F004_PCF_Fill_DM_Area

...

0.1.9

...

Every 6th of each month

...

Task

...

F001_OrchFlow_PCF_Monthly

...

0.1.2

...

Every 6th of each month

...

Plan

...

PL_IND_PCF_monthly

...

Every 6th of each month

Delete the following Talend flows:

...

Type

...

Flow/Job

SQL Server - Parameters

Run the following scripts on SQL Server TALEND_EXPLOIT database:

After Release Verification

After First Run

...

1rDy1rGCTGZJ5kOCsTnLyLIEzyJYV6uxq