QlikView connects IBM DB2 via ODBC

QlikView connects IBM DB2 via ODBC

PART1: Creating an ODBC-driven connection for IBMDB2

First go to the control Panel to find Control Tools,--> Choose an ODBC data source based on the version of your system,

Because the IBM DB2 database needs to be connected via an ODBC data source, you need to go to the IBM website to download the driver driver that is right for you based on the number of bits in your system.

Because my system is 64 bits, I am here to share the IBM driver package:http://www-01.ibm.com/support/docview.wss?uid=swg24038641

At first I also downloaded kingty_x on the csdn to share the driver package, but found that no response, I went to IBM's official Web download,< attached: If because of the network reason is slow, I have downloaded from the IBM official web 64-bit driver package on the CSDN, I'll be right here. Connection Sharing: http://download.csdn.net/detail/sharkxgbaby/9513735>

http://download.csdn.net/download/kingty_x/5524119, we can first try to use this driver package to see if you can register successfully, if not, you can only go to the IBM official website to download,

When the installation is successful you will see such an item in the ODBC data source < You can also refer to another CSDN blog post, how to install IBMDB2 ODBC driver> attached link: http://download.csdn.net/detail/ kingty_x/5429753

Description of your IBM DB2 driver installation was successful,

After writing to data SourceName, click the Add button next to the database alias on the left,

The following description can be filled in casually, UserID and password need to fill in the legal access to the database user name and password.

Select the advanced Settings to the left, there are four items that need to be added.

PORT

Target database port, DB2 installed by default to 50000

PROTOCOL

Agreement, according to the circumstances of the choice, generally for the TCPIP agreement

Databse

Target database name

After filling in the appropriate information, click the Apply button, all the information will be updated to the Value column, click OK to save the settings.

Here is the homepage, you can see the ODBC data connection you created, click this link, fill in the appropriate user name and password, click the Test button

You can see that the test link was successful, indicating that the IBM DB2 data was connected successfully

PART2: Download Data resources in DB2 via Qlikview

Create a new file and click Edit Script, Click the connection below,

Select the data source, and then enter the user name and password, click Test Connection ..., and then see Connection Test succeded, click OK.

To the homepage, click the Reload button, as shown below, so you can drop all the data sources in the database.

QlikView connects IBM DB2 via ODBC