Data warehouse - Migrate over CAS

[seeker25]

No description provided.

[bolyachevets]

waiting for MISO to get back to us regarding ora2pg installation on nettle server hosting CAS

[bolyachevets]

Hello MISO – Are you able to approve the following?

List servers (by individual hostname) that the approval applies to. nettle.bcgov and pimento.bcgov
List the software to be installed, and or modules/known dependencies. Ora2pg
List a source for the software. https://sourceforge.net/projects/ora2pg/
Date approval requested. September 8, 2023
A brief description of the software, and any associated risks.
Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scans it automatically and extracts its structure or data, then generates SQL scripts that you can load into your PostgreSQL database." (see https://github.com/darold/ora2pg) Ora2Pg is an industry standard tool for Oracle to Postgres export/migration. It is available under the GPL v3 licence. Ora2pg will be run via cron triggers during off hours using read-only credentials. Internet traffic on the server is disabled via the firewall.

David Roberts
Senior Database Administrator – BC Registries and Online Services
Service BC
Ministry of Citizens’ Services
T: 778-698-1403 | Web: http://www.servicebc.gov.bc.ca/
“Access to government services made easy”

[bolyachevets]

Hello David,

Thank you for reaching out to our IPS team,

We will review your inquiry and assign shortly, with a response within 2 weeks.

Please inform us should your request require urgent attention.

Thanks,
Nicholas (Nick) Hein | Information Privacy and Security Analyst
CITZ Information Privacy and Security (IPS) Team
Email: [email protected]

[bolyachevets]

a sample of CAS data is in gcp, waiting for the team to decide on the tables we need to streamline the process