Observe the following program and settings information for Oracle GoldenGate for SQL Server:

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

  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

  Note:

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

• Installation of the Oracle GoldenGate CDC cleanup tasks requires the Microsoft sqlcmd Utility. Download instructions for Windows and Linux systems can be found at:

  https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver15

• To install capture on a remote Linux or Windows server, set the remote server's time and time zone to that of the database server, or use LSN based positioning for the Extract.