-
Title
Does Toad support connecting to Oracle Cloud databases? How to connect Oracle Cloud database? -
Description
Does Toad support connecting to Oracle Cloud databases?
How to connect to Oracle Cloud database?
-
Resolution
Database Official Support in Toad for Oracle TNS/Direct/LDAP Connection Method Clientless Connection Method Oracle Cloud
Managed Databases (DBaaS, IaaS, etc.)Yes Yes Yes Oracle Cloud Autonomous Database Yes Yes Yes Oracle Cloud Fusion Database* No N/A N/A Amazon AWS RDS Oracle Database Yes Yes Yes Amazon AWS EC2 Oracle Database Yes Yes Yes Azure VM Oracle Database Yes Yes Yes
Connect to Cloud Databases
Toad can connect to cloud databases that are configured through Oracle Client Interface (OCI) API. OCI validation can be made by testing the connection using SQL*Plus.
The steps to connect to Oracle cloud database are the same as connecting to Oracle on-premises database. See the step-by-step guide on how to connect from Toad.
See additional details on how to connect DBaaS using SQL*Plus.
See additional details on how to connect to Oracle Cloud database.
See additional details on how to configure Oracle Autonomous Database.
*To connect to Oracle Cloud Fusion use Toad Data Studio product.. The installer of Toad Data Studio can be found here. More information regarding the feature can be found on Toad Data Studio product video page.
-
Additional Information
This can also be applied to SQL Navigator, as the same connection method is shared with Toad