Oracle Database Gateway 19c Deployment for SQL Server

I recently worked on a project to cross-platform migrate an Oracle database to SQL Server. There was a last minute dilemma in this project – the environment also leveraged an in-house application built on Oracle APEX (Application Express), which meant that in-house application cannot run on SQL SERVER. This application was essential to certain functionalities within the finance department and could not be retired, neither could we afford (development time + cost) to build an entirely new in-house application. I came up with the solution to implement Oracle Database Gateways to address the needs of such disparate data access.

Continue reading…