Data warehousing — Creating database connections

Use the Warehouse Administration Console to define the database connections that your application will need to connect to. After you define a database connection, it becomes available for you to select during the deployment or import process.

Before you begin

Install Informix® SQL Warehousing Tool.
Log in to the Warehouse Administration Console.

For each physical database that your applications need to connect to, you can create one or more different database connections.

When you create a connection, you select the data server type in the Create Connection wizard. The data server type list is created from the list of driver definitions, which the connection uses to connect to the database. If you do not see the data server type that you want to use in the list, you must create a driver definition for the driver first on the Manage Data Server Drivers page. In addition, you must specify the JDBC URL. For preconfigured drivers, the JDBC URL is created from a template that is based on the information that you specify when you create a connection. However, for drivers that are not preconfigured, you must create the JDBC URL by using the information in the vendor documentation for that driver.

The two types of Informix drivers use two different driver classes. You can define a connection by selecting the Informix (JCC) driver or the Informix JDBC driver from the data server type list in the Create Connection wizard. Each driver has a different JDBC URL and uses a different class. The Informix (JCC) driver uses the DB2® driver class, and the Informix JDBC driver uses the IFX driver class.

Procedure

To create a database connection:

Select the Manage Connections tab.
If the data source is a non-DB2 database, set up a data server driver before you create a connection.
1. Select the Manage Data Server Drivers tab.
2. Click the Add Driver button.
3. Specify the driver ID.
4. Specify the driver class.
5. Specify the full path for the location where the driver exists.
Use the Add Connections wizard to create a database connection.

After you create a connection, go to the Manage System Resources tab to create a system resource.