Data Source Type:
IBM DB2 (all types)
This article covers how to install and connect to an IBM DB2 data source in AutoTag's v15. For more information, see the article on the new Connection Editor here.
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:
- 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.
- 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).
- Locate the ‘IBM Data Server Driver Package’ option.
- Select your OS type.
- Choose the #1 Driver Package in the list (if any).
- You will be prompted to create an IBM account or login with an existing IBM account.
- After login, select the language download package you desire.
- After download, ensure you run the installer as an administrator or it may not install correctly.
- 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
From MS Word, Excel or PowerPoint, navigate to the AutoTag Manager tab. Once on the AutoTag Manager tab, click on the upper half of the Data Sourcesbutton. This will open the data source Connection Editor.
Note that if you click on the bottom half, you will get a dropdown menu which lists data sources that are already connected; this may be blank.
Enter your organization's information. The information for Windward's sample IBM data sources is shown below.
1. In the Connection Editor window, in the New tab, click on IBM DB2 under SQL data sources. The Details pane will change to prompt you for your data source details.
2. Enter a Nickname for your data source connection.
3. Browse to your server location or fill in your server and database information. 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.
4. Fill in your credentials or opt to use your Windows Identity.
5. ‘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.
6. Click Connect, and then Test your connection. If all parameters and credentials are correct and a connection is made, you will receive a successful notification. Clicking Close will save your information.
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
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.
|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 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
Each flavor 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.