This is one of 4621 IT projects that we have successfully completed with our customers.How can we support you?
Migration of a product database to AWS
Project duration: 1 year, 8 months
Brief description
An existing DB2 database is to be migrated to a PostgreSQL DB on AWS.
Supplement
An on-premise DB2 database is to be migrated to a PostgreSQL DB and hosted in the cloud on Amazon Web Services (AWS). The infrastructure will initially be defined and deployed with Terraform as infrastructur as code. With the AWS database migration services, the existing data is loaded into the cloud. There, the database is split into two instances, one for normalized data storage and a denormalized form as the basis for users. The advantage is that it is sufficient to back up the normalized one via snapshots. Via Foreign Data Wrappers one is to be integrated into the other for queries.
Subject description
In the life area of an insurance company, a product database is maintained on the basis of which new products and tariffs are developed. To simplify database maintenance and reduce costs, a license-free database in the cloud is to be used in the future.
Overview
- Industries insurance
- Specialist tasks life insurance
- DV tasks Migration
- System environment Cloud Computing
- Procedure model customer standard
- Databases AWS RDS, PostgreSQL
- Development/ test tools DbVisualizer, Eclipse, Git,
Project period18.01.2021 - 30.09.2022
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
