Connecting to DB2

Connecting to DB2

The SaveToDB add-in allows connecting to DB2 tables, views, and stored procedures.

The SaveToDB add-in supports the following data providers:

  • IBM DB2 ODBC Drivers including DSN files
  • IBM OLE DB Provider for DB2
  • IBM DB2 .NET Data Provider

You can download and install IBM Data Server Client Packages at https://www.ibm.com/products.

Here is a sample of the Database Connection Wizard page where you can select the data provider:

Connecting Excel to IBM DB2 - Selecting Provider

Connecting to DB2 Databases

Use the following server name format for IBM DB2:

<Server name or IP-address>[:<Port>]

Here is a sample of the connection to the samples database on the localhost:

Connecting Excel to IBM DB2 Database

Here is a sample of the connection to the samples database on localhost port 50000:

Connecting Excel to IBM DB2 Database