Database Configuration

This topic provides an overview of the type of database configuration.

Oracle® Database Navigator provides several ways to configure a database connection and perform authentication. For an Oracle database, you can create a new connection using one of the following configuration methods:

Configuration Type	Description
Basic connection (Service Name or System Identifier)	Requires you to provide the Service Name or SID (System Identifier) of the database you want to connect along with the host name, port number. The database URL field is auto filled.
Easy Connect	Requires you to select the TCP or TCPS protocol and provide the host name, port number, and database service name. You can provide the type of database server and the corresponding Property Value(s). The database URL field is auto filled.
TNS	Requires you to select the folder location (or Oracle wallet location directory) where the TNS config file is stored, and then select the appropriate TNS profile (Network Alias). The database URL field is auto filled.
Custom URL	Requires you to provide the JDBC URL manually, consisting of the protocol, sub-protocol, host name, port number and database name.

Note:

Configure an SSH tunnel and authenticate using a password or key/value pair to securely connect to the database. Oracle® Database Navigator plug-in supports connectivity to Oracle Cloud Autonomous databases through simple URL connection using the "Custom URL" configuration type, or via Oracle wallets.

• Database Authentication
  This topic provides an overview of database authentication models.
• Connection Details
  This topic provides an overview of the general settings of a database connection.
• Connection Properties
  This topic provides an overview of setting up a Properties File for database connections.