Connecting to a database by using a wizard

You can browse existing data objects by connecting to a database in the Database Explorer. This topic explains how to open the New Database Connection wizard from the Database Explorer view. The New Database Connection wizard pages can also be embedded in other wizards in the workbench.

To connect to a database by using a wizard:

  1. Right-click in the Database Explorer, and select New Connection from the pop-up menu.
  2. On the first page of the wizard, select a database manager, a JDBC driver, and specify other connection details. See one of the related topics for specific information about the database that you want to connect to.
  3. Optional: On the Limit the objects retrieved from the database page, specify filtering options. For best performance, you should use filters when you are connecting to a large database.
  4. Complete all other wizard steps and click Finish.
The connection is displayed in the Database Explorer.
Related concepts
Data object filters
Related tasks
Troubleshooting database connection problems
Related reference
DB2 for iSeries database connections
DB2 for Linux, UNIX, and Windows database connections
DB2 for z/OS and OS/390 database connections
Derby database connections
Informix database connections
Oracle database connections
Microsoft SQL Server database connections
Sybase Adaptive Server Enterprise database connections

Feedback