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: