Retrieving data from mainframe DB2

[deepakqlikview_123]

Hello Experts,

Can you please suggest how to fetch data from mainframe DB2 in qlikview.

Is there any need of installing driver.

Please help me out.

Thanks,

Deepak

[rwunderlich]

You must install a driver. There are several available such as:

DB2 Connect from IBM

Data Direct

Star SQL

-Rob

[rajeshvaswani77]

Hi Deepak,

Alternate option is to raise a request to DB team to extract all data in to CSV files and hand it to you.

This will be applicable only if you are getting rid of mainframe. Otherwise as Rob has suggested, yes there are drivers.

thanks,

Rajesh Vaswani

[#4]

Rob,

I thought ODBC/OLEDB drivers are good to extract data from DB2. Am I wrong?

Thanks

Suraj

[deepakqlikview_123]

Hi Rob,

Thanks for your prompt response.

Can you please elaborate more on this.

Can you please send me  a link for installing drivers,I need to do hands on for this.

Thanks,

Deepak

[ashfaq_haseeb · Accepted solution]

Hi,

Deepak ask your DB2 admin to install drivers for you.

There is default drivers available  OLEDB or ODBC for DB2 by IBM

Regards

ASHFAQ

[rwunderlich]

I don't know if there is an OLEDB driver for mainframe (Z/os) available, but there are ODBC drivers such as I listed in my previous response. In any case, my experience is that you have to install the driver -- whatever vendor you chose.

-Rob

[rwunderlich]

As Ashfaq has suggested, you probably want to talk first to your DB2 Sysprog. The DB2 drivers are licensed (priced) software and your organization may already own the required software. If you don't already own a zos DB2 driver, Star SQL is a very reasonably priced driver in my experience.

Db2 client for windows Db2 linux client Db2 Connect

Not to knock the other vendors, there are a number offerings that all have their own strengths. It may be that your zos DB2 license already entitles you to use the IBM driver. Check with your DB2 Sysprog.

-Rob

[deepakqlikview_123]

Hi All,

Thanks for your reply

Thanks,

Deepak