Connecting to a remote Oracle database on MacOSX

0

In my company's development environment, we (still) run PHP 5.6 on a Linux environment, with a Laravel based framework, connecting to Oracle. Nobody has attempted to run a local copy of the code and connect to Oracle.

Assuming the Oracle db itself will accept the connection (which might require adding a permission but again assuming that can be done), is there any feasible path forward in running the code locally and making the connection to the DB? I'm not sure about the Oracle driver (I've used MySQL almost exclusively) and I believe there is licensing and possibly a JVM setup required etc.

I have SQL Developer installed on my MacOSX, and a few years ago (on a windows env) had Toad installed - so perhaps one of these might have an internal API that would work. Again this is a general question looking for feasibility, what things to check I'm (probably) not aware of, and best path forward, thanks.

Oliver Williams

Posted 2019-10-28T13:27:57.347

Reputation: 263

No answers