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 DSN system DSN therefore to offload APPLY to another server, we need to configure DSN system DSN on that server.
Please follow Dbvisit Replicate configuration examples on following link and do as instructed on the server where you want to run APPLY instead of target system.
...
| 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. |
...