You can also create a new connection by creating a duplicate of an existing connection. This method is useful if you want to create a connection that is similar to an existing connection but with different properties. To create a duplicate of an existing connection, right-click a connection in the Data Source Explorer and select Duplicate. You can then edit the properties of the duplicate connection as needed.
To connect to a database by using a wizard:
Specify a JDBC driver to use to connect to the database. JDBC drivers that appear in the list are fully supported. If a driver that you want to use is not listed but it is supported by the database manager, select Other Driver Default and provide the details.
Click Edit JAR List to open a window so that you can modify the path to the JAR files that are being used for a particular JDBC driver. You can also use this window to view the names and typical locations for JDBC JAR files for each listed driver.
Global driver properties are set in the Preferences window, on the Driver Definitions page.
The IBM® Data Server Driver for JDBC and SQLJ is included with the workbench product, and by default the wizard uses the included version of the driver. It is recommended that you use this version, because it has been tested thoroughly. If you want to use a different version of this driver, you can modify the path to the required JAR files by clicking Edit JAR List. Other JDBC drivers for IBM data servers might also be included, depending on the workbench product that you are using.
JDBC driver limitation: Some drivers require a pass code or license file. Although license information can be set or available in the current environment, the information might not be available in other environments, such as on a Web server. The driver does not work if the pass code or license is not available.
For best performance, you should use filters when you are connecting to a large database.
If you do not specify filtering options in the wizard, you can modify them later by modifying connection properties or by specifying data object filter options. To modify connection properties, right-click a connection in the Data Source Explorer and select Properties.
Filtering is not enabled by default on the wizard page. To filter your connection, clear the Disable filter check box, then specify filtering options either by using an expression or by selecting specific objects to include or not include in the connection view.