Oracle 12c (PDB) Replication to SQL Server 2016

If you need to replicate data from Oracle to SQL Server, I highly recommend Oracle GoldenGate for its reliability and robust replication capabilities. In this demonstration, I’ll showcase data replication from Oracle 12c Multitenant to SQL Server 2016 using Oracle VirtualBox, the Oracle Developer Pre-Built VM, Oracle GoldenGate, Windows Server 2016, and SQL Server 2016. These VirtualBox machines will run on a Windows 10 system, which serves as the base “home” environment.

Prerequisites

Oracle VirtualBox is downloaded and installed on Windows 10.
Working knowledge of Oracle 12c Multitenant.
Working knowledge of SQL Server 2016.

Instructions

Part 1 – Install Windows Server 2016 in VirtualBox

Part 2 – Install SQL Server 2016 on Windows Server 2016

Part 3 – Import Oracle/Linux Pre-Built Developer VM into VirtualBox

Part 4 – VM Network Settings

Part 5 – Install GoldenGate for SQL Server on Windows

Part 6 – Install GoldenGate for Oracle on Linux

Part 7 – Configure GoldenGate for Oracle on Linux

Part 8 – Configure GoldenGate for SQL Server on Windows

Part 9 – Putting it all together

Part 10 – Monitoring Replication