ETL Deployment and Scheduling

bcgov / foi-flow

Freedom of Information modernization

Apache License 2.0

5 stars 3 forks source link

ETL Deployment and Scheduling #1304

Closed mpilchar closed 2 years ago

mpilchar commented 2 years ago

Title of ticket:

Description

Summarize issue

Dependencies

Are there any dependencies?

DOD

[x] Set up Integration Services, SQL Agent Permission etc on DEV, TEST .
[x] Deployment to TEST, DEV, PROD
[x] Confirm the FW rules, access to OPENSHIFT from DMZ Servers.
[ ]
[ ]
[ ]

Note : Production ETL deployment DODs/Task moved to #1746, due to wait on STRA approval

lmullane commented 2 years ago

Blocked by network issues. Fix going into tonight. Will test tomorrow.

mpilchar commented 2 years ago

Firewalls open today - this work can now be initiated

abin-aot commented 2 years ago

removing DOD to deploy to PROD, since STRA is not approved to move live data. So , effort can be reduced to 5 from 8. Also, as of today - we observed an DB functions mismatch within the same version of AXIS DB on DEV, TEST and PROD. which has been reported to IMB -" FOIMOD-68" on IMB JIRA.

Missing DB functions between 10.3 DEV (ATIPD) comparing with same version on TEST(ATIPT), PROD

AFX_GetReferenceRequests

DODs moving to #1746

DO a trial deployment to PROD to confirm the access, FW rules