Skip to main content
Windward

Connect to an IBM DB2 Data Source

 

 

 

Data Source Type:

IBM DB2 (all types)

 

Overview

This article covers how to install and connect to an IBM DB2 data source.

 

 

What you will need to establish connection

If you do not have an IBM DB2 connector already installed, the following are instructions on how to install a lean connector that will enable you to connect to your database using AutoTag:

To install the IBM DB2 connector, and only the drivers needed (you probably do not want the IBM connector client interface), do the following:

  1. Go to the IBM ‘Download Fix Packs’ page: http://www-01.ibm.com/support/docview.wss?rs=4020&uid=swg27016878
    • The labels say ‘Fix Pack’, however these are the full drivers you need for installation.
  2. Select the latest ‘Fix Pack’ version. (Choose the most recent IBM Data Server Client Packages Fix Pack for the most recent Version in the list -- they may be listed in reverse chronological order). 
  3. Locate the ‘IBM Data Server Driver Package’ option.
  4. Select your OS type.
  5. Choose the #1 Driver Package in the list (if any).
  6. You will be prompted to create an IBM account or login with an existing IBM account.
  7. After login, select the language download package you desire.
  8. After download, ensure you run the installer as an administrator or it may not install correctly.
  9. After you have followed the prompts from the IBM installer, you have completed the driver install.

 

 

 

Connect Your Windward Template to IBM DB2 as a Data Source

Step 1

From MS Word, Excel or PowerPoint, navigate to the AutoTag Manager tab in the ribbon. 

 

 

 

Step 2

Once in the AutoTag Manager tab, click on the Data Source button. This will open the DataSources dialog box. Click Add to bring up the Datasource Connector.

 

 

 

 

 

 

 

Step 3

Select the IBM DB2 .NET connector from the ‘Vendor:’ drop down list.

 

IBMDB2_4.png

 

 

Step 4

Fill in the details for your IBM DB2 connection in the Datasource Connector window. You can also test your connection by using Windward’s sample DB2 database (details below).

 

Datasource Connector Fields

Vendor: Select the IBM DB2 .NET Data Provider {version} from the drop down list.

Name: Type a name for your datasource connection.
Server: Enter the server name here.

Database: Enter the database name here. This may auto-populate once the Server name has been provided. In most cases you will need to set your username & password in order for AutoTag to auto-populate the list. However, if you know the Database name, you can simply type the name in the textbox.

 

IBMDB2_5.png

 

 

Once all of your information is properly filled in you can click OK and your connection will be established.

 

Other features in the Datasource Connector

Display Tables:

‘User’ is selected by default. Select ‘User & System’ to grab the metadata of the tables created for a database and the system tables used to administer and configure each database.

Read in metadata:

Check this to read in additional information from the database, primarily the descriptions of tables, views, & columns and the primary key - foreign key relationships. It is a good idea to have this selected.
Use Connection String:

This is optional. You can enter the connection string directly instead of entering the Server, Database, & credentials in the previous fields. When unchecked, it will allow you to type the connection string AutoTag will use to connect to your data source.

Root directory:

This is optional. This is the "default directory" for any import tag requests where the requested file does not have an absolute path. If left blank, AutoTag will use the directory where the data source file is located. If the data source is not a file it will use the directory where the template is located.

Test:

You can test your DB2 connection by clicking this button. If all parameters and credentials are correct and a connection is made, you will receive a successful notification.

Test your connection by using Windward’s sample DB2 Database

The Windward sample DB2 credentials are:

  • Server: db2.windward.net
  • Database: SAMPLE
  • Username: demo
  • Password: demo

 

Common Issues:

Each variety of DB2 uses different options to read in metadata. If you connect to your database, but AutoTag does not display any Tables or Views in the Data Bin, then please read Overriding DB2 Metadata.