QlikView support VSAM as data source?

[#1]

Hi

I want to know if QlikView support VSAM as data source? And where I find a connection ODBC of VSAM (Cobol) Files whit QlikView, if anyone knows would appreciate your help.

Thanks

[rbecher]

Hi,

as far as I know this is the driver with the most features:

http://www.hxtt.com/cobol.html

You can probably use this in combination with our QlikView JDBC Connector:

http://community.qlik.com/docs/DOC-2438

- Ralf

[rwunderlich]

I don't think there is way to read VSAM files directly. What you can do is IDCAMS Repro them to a sequential file and then load the seq file using FTP.

There are several third party (IBM as well) product you can install that provide SQL access to VSAM files, if you have the funds and volume to go that route.

-Rob

http://robwunderlich.com

[rbecher]

You can contact me directly for configurational questions on the JDBC Connector:

ralf.becher@tiq-solutions.de

[rwunderlich]

What platform are your VSAM files on, z/OS or AS/400?

If on z/OS, it looks like you can access VSAM directly using Distributed File Service, SMB-RFS. I don't know if this is available on AS/400.

-Rob

[#6]

The platform are on z/OS

[#7]

Does anyone have done it, importing VSAM files into QlikView?

any other sugestions?

Thanks

[rbecher]

I'm just curious to try this with our JDBC Connector. Can you send me a sample file?

- Ralf

[rbecher]

So, in the meantime I did an example how to read a Cobol file:

http://community.qlik.com/docs/DOC-2904

- Ralf

[rwunderlich]

This is great Ralf. But I'd like to point out that that "COBOL" files are not the same as VSAM.

-Rob