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 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:

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