Connection ParameterDescription
Use TNS AliasIf 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 ConnectionsEnables 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
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