topic Re: Retrieving data from mainframe DB2 in QlikView

Retrieving data from mainframe DB2

deepakqlikview_123 — Mon, 08 Sep 2014 05:30:02 GMT

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

Re: Retrieving data from mainframe DB2

rwunderlich — Mon, 08 Sep 2014 05:35:05 GMT

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

DB2 Connect from IBM

Data Direct

Star SQL

-Rob

Re: Retrieving data from mainframe DB2

rajeshvaswani77 — Mon, 08 Sep 2014 05:37:34 GMT

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

Re: Retrieving data from mainframe DB2

Mon, 08 Sep 2014 05:39:09 GMT

Rob,

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

Thanks

Suraj

Re: Retrieving data from mainframe DB2

deepakqlikview_123 — Mon, 08 Sep 2014 05:39:19 GMT

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

Re: Retrieving data from mainframe DB2

ashfaq_haseeb — Mon, 08 Sep 2014 05:42:48 GMT

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

Re: Retrieving data from mainframe DB2

rwunderlich — Mon, 08 Sep 2014 05:45:13 GMT

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

Re: Retrieving data from mainframe DB2

rwunderlich — Mon, 08 Sep 2014 06:04:26 GMT

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

Re: Retrieving data from mainframe DB2

deepakqlikview_123 — Mon, 08 Sep 2014 07:28:39 GMT

Hi All,

Thanks for your reply

Thanks,

Deepak