RAD: Connect to a database by using a wizard

 

You can browse existing data objects by connecting to a database in the Database Explorer view. After you connect to the database, you can import the database design into a project. You can also connect to a database from the Database Connection page that is embedded in other wizards in the workbench.

This topic describes how to create a database connection by using the New Database Connection wizard that is launched from the Database Explorer view. If you are creating a database connection from another wizard, see the topic about the Database Connection page.

To connect to a database by using a wizard:

1. Switch to the Data perspective.

2. Right-click in the Database Explorer view, and select New Connection from the pop-up menu.

3. On the first page of the New Database Connection wizard, select one of the following options:
   • If you are connecting to a DB2 database that has a database alias, select Choose a DB2 alias and click Next.

   • If you are not connecting to a DB2 database that has a database alias, select Choose a database manager and JDBC driver and click Next. On the page that opens, 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.

4. 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.

5. Complete all other wizard steps and click Finish.

The connection is displayed in the Database Explorer view.