Overview of MDC using AWS DMS for Replication

Amazon Web Services Database Migration Service (AWS DMS) streamlines the process of migrating Proficy MDC databases to AWS. The MDC platform utilizes AWS DMS to continuously replicate its database data, ensuring that the data is always up-to-date between the source and target databases. Thus, AWS DMS acts as a replicator, facilitating continuous data replication from one database to another. By leveraging AWS DMS, MDC can efficiently and securely migrate its data management systems to AWS. This transition will provide improved scalability, reliability, and performance, ensuring a seamless user experience.

The following diagram illustrates the architecture for using AWS DMS with a SQL Server source in a user Data Center, connected to AWS through a Site-to-Site VPN (Virtual Private Network) to ensure secure and continuous data replication. This setup is divided into two main components. On the left side of the architecture diagram is the user Data Center, which hosts the on-premises SQL Server database. On the right side is the AWS environment, integrated with MDC account, hosted in a user specific Virtual Private Cloud (VPC). The connection between these two environments is facilitated by Site-to-Site tunneling, which includes components such as the customer gateway, routers, and VPN gateways. The customer gateway, a device or software on the user’s end, establishes the connection to the AWS VPN, providing external access within a firewall.

The Site-to-Site VPN employs two SSL-encrypted tunnels (Tunnel 1 and Tunnel 2) to ensure secure data transfer. Only one tunnel is active at a time, if the active tunnel fails due to maintenance or other reasons, the second tunnel automatically becomes active, maintaining continuous data transfer without interruption. AWS further ensures security with built-in encryption for data in transition from the on-premises SQL Server to AWS DMS. This means that data is always encrypted and secure during the transfer.

This Site-to-Site VPN architecture thus enables secure, efficient, and continuous data replication from an on-premises SQL Server to AWS using AWS DMS. The built-in encryption and automatic failover mechanisms ensure data integrity and availability, providing a reliable solution for data migration and replication. For more information, refer to Site-to-Site VPN AWS documentation.