To define a new connection, complete the following steps:
- Highlight the Connections node, then right-click in the
Database Explorer view and click New Connection as shown in Figure 1. Figure 1. Creating a database connection
The New Connection page is displayed, similar to Figure 2, showing a list of database managers and associated parameters that define the selected manager connection.Figure 2. Naming the new connection and choosing a connection type
- Use
this page to specify the database manager, platform, and version of
the local or remote database to which you are connecting. Select the
JDBC driver supported by your database manager, and then specify all
of the required connection information for that driver. Some of the
information is entered for you by default.
Depending on the database software that is used for the warehouse database, set up your connection similar to examples in the following sections. The JDBC driver must be a type 4 driver.
Connecting to other supported databases: The sections that follow show several examples of connecting to databases for several supported versions of database application software. If you do not see the version of the database manager in the selection list, you can specify Other in the JDBC driver field and then define your own connection parameters. See Creating a database connection with a different JDBC driver class for an example.