Oracle Cloud Infrastructure (OCI) GoldenGate is a cloud-native service designed for real-time data replication, integration, and streaming across heterogeneous environments. It enables enterprises to build mission-critical architectures for high availability, disaster recovery, analytics, and cloud migrations.
Oracle Autonomous Data Warehouse (ADW) is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type.
Microsoft SQL Server is a third-party RDBMS used to build large-scale OLAP/OLTP applications.
In this blog, we will explore how to Set up real-time data replication from on-premises Microsoft SQL Server 2016 database to OCI ADW 23ai database using OCI GoldenGate 23ai.The same steps are applicable to MSSQL in On-premises/Azure Cloud as source Database with the exception that DDL replication is not possible between diffrent RDBMS.
For detail steps please refer to tutorial Set up Real-Time Data Replication using OCI GoldenGate from On-Premises Microsoft SQL Server to Oracle Autonomous Data Warehouse.It walks you through the entire process, from configuration to real-time data replication, ensuring high availability and seamless data movement.