Connecting Excel to IBM Db2 Warehouse

These instructions explain how to connect Microsoft Excel 2010 to Db2® Warehouse.

Before you begin

Before you can connect to your database, you must carry out the following steps:

  • Verify prerequisites, including installing driver packages, configuring your local environment, and downloading SSL certificates (if needed)

  • Collect connect information, including database details such as host name and port numbers, and connect credentials such as user ID and password

You must have the Db2 driver package or the IBM Data Server Driver Package installed on your local computer.
Restriction: Connections between Excel and IBM Db2 Warehouse are supported on only the Windows operating system.

Procedure

  1. In the web console, go to the Run SQL page.
  2. Type one or more SELECT statements in the editor text box.
  3. Click one of the Run options.
  4. Click Excel ODC File.
  5. Download and open the BLUExcel.odc file in Excel.
    If a security notice is displayed, click Enable.
  6. Click Open to connect to the Db2 Warehouse database. The Connect To DB2 Database dialog box opens.
  7. Type the user ID and password that you use to log in to Db2 Warehouse. To obtain the user ID and password, click Connect in the web console or Connect > Connection Information in the web console.
  8. Ensure that the connection mode is Share, and then click OK.

Results

The query results are displayed in an Excel spreadsheet. These are the same results that are displayed in the Results viewer. Now you can generate charts and reports and analyze your data by using Excel.