New/Edit connection dialog box

In the New connection dialog box you create new database connections, and in the Edit connection dialog box you edit the connection settings for existing database connections.

Oracle connection settings

 

Setting	Description
Database vendor	The type of database to connect to.
Hostname	The database server host.
Port	The port used to communicate with the database server.
Service name (SID)	The SID to connect to. The SID uniquely identifies an Oracle database instance on a given system.
Schema owner	The Oracle Schema owner.
Default username	Database Administrator user name. Must have access rights equivalent to at least DBO (database owner).

SQL Server connection settings

 

Setting	Description
Database vendor	The type of database to connect to.
Host name	Host of the database server and optionally the instance name (<hostName>\<instanceName>).
Port	The port used to communicate with the database server.
Instance name	The name of the instance to connect to (read-only).
Database name	The database name.
Default username	Database Administrator user name. Must have access rights equivalent to at least DBO (database owner).

IBM DB2 connection settings

 

Setting	Description
Database vendor	The type of database to connect to.
Host name	The database server host.
Port	The port used to communicate with the database server.
Database name	The database name.
Schema owner	The DB2 Schema owner.
Default username	Database Administrator user name. Must have access rights equivalent to at least DBO (database owner).