Prerequisites for Installing Oracle GoldenGate Microservices Architecture for SQL Server

  1. Install either the Microsoft ODBC Driver 17 or Microsoft ODBC Driver 18 for the operating system where Oracle GoldenGate is to be installed.

    Note:

    Support for Microsoft ODBC Driver 18 was added with Oracle GoldenGate release version 21.8.0.0.3. Versions prior to release 21.8.0.0.3 do not support the Microsoft ODBC Driver 18 for SQL Server.

    For Oracle GoldenGate on Windows, install the driver available at the following link:

    https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-2017

    For Oracle GoldenGate on Linux, install the driver available at this link, and follow the instructions for RHEL and Oracle Linux packages:

    https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017

  2. When installing Oracle GoldenGate on a hub server that is different server than the database server and creating an Extract, set the remote server's time and time zone to that of the database server, or use LSN based positioning for the Extract.