Connection Parameter | Description |
---|---|
Use Alias Information from your SQL.INI File | If the data source is mapped to a name via SQL.INI, select this parameter to use that name for connection. Otherwise, choose Generic JDBC Configuration and enter the connection parameters, as specified. |
Host/Instance (JDBC Connection) | 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. |
Default Database (JDBC Connection) | Optional. The default database name, as defined by the schema. |
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. |