This is one of 4622 IT projects that we have successfully completed with our customers.How can we support you?
Oracle Migration
Project duration: 8 months
Brief description
Migration of the Oracle 12c database and the ETL processes to a new Linux server with Oracle 19c standard.
Supplement
At the start of the project, the current Oracle 12c server is already 10 years old and must be replaced as soon as possible. The database and ETL processes are poorly documented. About 3000 to 4000 database objects (mainly tables) have to be checked, documented if possible and then transferred to the new Oracle 19c database. The Cognos Datamanager from IBM used for the ETL control must also be replaced. The ETL control will be replaced by the Python logic in Apache Airflow. For all required transformation processes of the data, corresponding Oracle views are created. In the first phase of the project, the main focus is on documenting and transferring the existing processes. In the next phase the processes will be tested and optimized.
Subject description
The customer's product inventory is stored in the Oracle database and read from it for eCommerce. The upgrade of the Oracle database serves, among other things, is done to improve performance and security.
Overview
- Industries trade
- Specialist tasks data warehouse, documentation, ETL
- DV tasks Migration
- System environment technical data processing
- Procedure model customer standard
- Databases Oracle Database
- Development/ test tools Oracle SQL Developer, TOAD,
Project period25.02.2020 - 16.10.2020
Have we sparked your interest?
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
Service
Industries
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
