You can have APPLY process running on separate server instead of target server where MSSQL SQL Server database is running. APPLY process communicates with MSSQL SQL Server database through system DSN therefore to offload APPLY to another server, we need to configure system DSN on that server.
...
| Note |
|---|
Make sure that the network settings are configured correctly (Firewall, tnsping,system DSN). APPLY server must have system DSN connecting target MSSQL SQL Server database and TNS connecting source Oracle database. |
...