Can I use Toad for Oracle Cloud (Fusion)?

Toad for Oracle
1

I’m a developer and I have been told that I’m not able to query using SQL on Oracle’s Fusion product. That can’t be the case right? Can I connect to the database using Toad just I have been able to with 11i and R12? Can anyone confirm that this is not the case?

2

Oracle Fusion is an application, not a database, right? So the answer is - as long as that application is built on a normal Oracle database, and the database is available for connections via SQL*Net, then you should be able to connect with Toad to that database.

3

Yes, sorry maybe I phrased the question incorrectly. Essentially what I have been told by my colleagues is that once you implement Oracle’s Fusion Cloud App, you’re no longer given access to the database via SQL*NET. I’m hoping someone on here can confirm that they do have this type of access.

Thanks!

4

Oh, I see. Sorry, I don’t know the answer to that.

5

We have found that Oracle now offers a ‘service’ called “Oracle Database Cloud Service” which is essentially a VM version of your cloud database. Without this subscription, you cannot access the database:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_QS/oracle_database_cloud_service_dbaas_quick_start.html

I’ll leave this here in case anyone else has experience with this.

6

Toad does work with the Oracle Cloud Database Service, assuming the ports are open (something you have to do after database creation)