Inteligencia artificial 

Productivity accelerator. Innovation catalyst. Creative collaborator. Whatever your vision for AI, Unisys provides the solutions, expertise and tools to realize the full business potential of your organization.
Explorar

Optimización logística

Keep cargo moving — despite disruptions. Discover how patent-pending AI models using real-time data can save time and boost revenue by improving capacity utilization, route planning and inventory management.
Explorar

Consultoría

The nature of work is changing. Let's evolve your business together. Future-proof your organization with consulting services from Unisys and advance as a digital-first entity.
Explorar

Industrias

Your industry sets you apart. You see the road ahead clearly. Let's join forces and turn that vision into reality. Unisys brings the tech know-how to complement your deep expertise.
Explorar

Historias de clientes

Explore vídeos e historias donde Unisys ha ayudado a empresas y gobiernos a mejorar las vidas de sus clientes y ciudadanos.
Explorar

Investigación

Embárquese en un viaje hacia un futuro resiliente con acceso a la investigación integral de Unisys, desarrollada en colaboración con los principales analistas del sector y empresas de investigación.
Explorar

Centro de recursos

Encuentre, comparta y explore activos que respalden sus objetivos operativos clave.
Explorar

Carreras

Curiosity, creativity, and a constant desire to improve. Our associates shape tomorrow by going beyond expertise to bring solutions to life.
Explorar

Relaciones con los inversionistas

Somos una empresa global de soluciones tecnológicas dedicada a impulsar el progreso para las principales organizaciones del mundo.
Explorar

Socios

Colaboramos con un ecosistema de socios para ofrecer a nuestros clientes productos y servicios de vanguardia en muchas de las industrias más grandes del mundo.
Explorar

Language Selection

Your selected language is currently:

Español
Transforming customer experience for a digital-first world

Driving large-scale cloud migration success with zero downtime

About the company

A prominent U.S.–based financial institution.

Challenge

The financial institution had multiple critical applications on more than 200 relational databases. It was looking to migrate these relational databases from Oracle to Amazon Web Services Relational Database Service (AWS RDS) for PostgreSQL and subsequently improve performance, governance and scalability. These are critical no-downtime applications integral to market functioning, compliance and integrity.

While migrating to AWS RDS, it was also important to establish data governance for a Relational Database Management System (RDBMS) and meet the Payment Card Industry, Sarbanes-Oxley Act and Nonpublic Personal Information/Personally Identifiable Information compliance requirements. Another critical goal was to enable the high availability of apps and scalability of relational databases based on the needs and traffic requirements of the applications.

What we did

  • Data architecture
  • Data governance
  • Data encryption using AWS Key Management Service (KMS) setup
  • Multi-Availability Zone (Multi-AZ) disaster recovery setup
  • Data catalog
  • Schema migration
  • AWS RDS migration

Solution

The company had already adopted the AWS cloud and had mature enterprise operations, governance, DevOps and approval policies. Our team utilized enterprise policies, foundations and frameworks to establish the following:

  • Provided data governance
  • Set up data encryption using KMS
  • Set up Multi-AZ disaster recovery
  • Reengineered and developed pipelines and migrated data from on-premises Oracle relational databases to RDS for PostgreSQL
  • Set up the application testing suite for execution and a Jenkins Pipeline to run and manage automated testing
  • Created a schema in the target PostgreSQL database by converting the source Oracle database schema utilizing the AWS Schema Conversion Tool
  • Set up AWS Database Migration Service (DMS) to load data from the source to the target database and implemented automated processes to trigger DMS
  • Utilized open-source packages like Ora2Pg to convert Oracle and MySQL databases to PostgreSQL automatically; enabled the pub/sub model with a relational data warehouse to sync the application’s source data

Result and outcomes

The large-scale migration of an RDBMS to a cloud-native Amazon RDS helped the company achieve the following outcomes and benefits:

Zero

downtime during the large-scale migration

45+

application relational databases migrated to the cloud

5,000+

total active users migrated seamlessly without disrupting the end-user experience

Business benefits

  • Considerable savings in database licensing costs
  • Better scalability, resiliency and governance
  • Faster time to market with increased speed of changes

Technical benefits

  • Change data capture enabled for the application data warehouse to application database sync
  • Zero disruption to critical applications during service level agreement hours