| Connection Parameter | Description |
|---|---|
| Use Network Library Configuration | If the data source utilizes a network library, select this parameter. The corresponding connection parameter fields become available. Otherwise, choose Generic JDBC Configuration and enter the connection parameters, as specified. |
| Host/Instance (JDBC Configuration) | The name of the data source. |
| Port (JDBC Configuration) | Optional. The listening port used in TCP/IP communications between DB Optimizer and the data source. |
| Protocol (JDBC Configuration) | The communication mechanism between DB Optimizer and the data source. Choose TCP/IP or Named Pipes. |
| Default Database (Optional) | The default SQL database name, as defined by the schema. |
| 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. |