This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4813 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.
IT project data
- Industries trade
- Specialist tasks data warehouse, documentation, ETL
- DP tasks Migration
- System environments technical data processing
- Procedure model customer standard
- Programming languages Python
- Databases Oracle Database
- Development and test tool Oracle SQL Developer, TOAD
- Middleware and frameworks Apache Webserver
Project period25.02.2020 - 16.10.2020
Customers who trust us
Have we sparked your interest ?
