Connection ParameterDescription

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
jdbc:derby://host:port/database 

Custom JDBC Driver Properties (Advanced)

The name and property value of any custom JDBC drivers associated with the data source.



IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal