| Connection Parameter | Description |
|---|---|
| Use TNS Alias | If the data source is mapped to a net service name via tnsnames.ora, select this parameter. Otherwise, choose Generic JDBC Configuration and enter the connection parameters, as specified. |
| Host/Instance (JDBC Configuration) | The name of the host machine on which the data source resides. Port (JDBC Connection)The listening port used in TCP/IP communications between DB Optimizer and the data source. |
| Type (JDBC Configuration) | Indicates if the data source is defined via a system identifier (SID) or a service name. |
Service/SID Name (JDBC Configuration) | The name of the system identifier (SID) or service name that identifies the data source. |
| Security Credentials | The log on information required by DB Optimizer to connect to the data source. |
| Auto Connect | Automatically attempts to connect to the data source when selected in data source Explorer, without prompting the user for connection information. |
| Allow Trusted Connections | Enables trusted connections to the data source from DB Optimizer. |
| JDBC Driver (Advanced) | The name of the JDBC Driver utilized by DB Optimizer to connect and communicate with the database. |
| Connection URL (Advanced) | Used by the JDBC Driver to connect with a database. Often contains host and port numbers, as well as the name of the database to which it connects. For example: jdbc:postgresql://host:port/database |
Custom JDBC Driver Properties (Advanced) | The name and property value of any custom JDBC drivers associated with the data source. |