Alternatives to TOAD

[Legacy User]

I need to set up a client to test my queries.  The implementation consultant that helped us with initial onboarding recommended TOAD, but my org's security requires a tool that supports using an HTTP proxy, which as far as I can tell Toad does not.  Does anyone have any recommendations for an alternative that has this functionality?

[Eugene Greiff]

I use Oracle SQL Developer.  In the connection dialog there is an advance button which lets you define a proxy.  I haven't ever used the proxy but  I do a lot of SSH to my server.

 

 

V/r,

Gene

[Deactivated User]

I use Oracle SQL developer as well through Citrix.

Would have used DatabaseBrowserPortable unpacked elsewhere as it does not require any installation, but that requires install of Oracle client which cannot be done with my access rights.

 

For MS SQL Server comes also with a native tool Management Studio/Enterprise Studio which can be installed from the server media.

[Nick Darlington]

TOAD works through the Oracle Client Interface (OCI), meaning your local Oracle Client installation and tnsnames configuration.

 

It seems that the tnsnames itself may not support a SOCKS proxy causing the limitation, and that any JDBC-based query software (like SQL Developer, SQuirreL, DBeaver, and others) should do the job and be able to setup the JVM http proxy parameters through them.  SQL Developer and DBeaver both have a UI for that too so you don't have to get into the JVM params directly.

[Legacy User]

Thank you everyone; I will try SQL Developer