Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView support VSAM as data source?

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

14 Replies
rbecher
MVP
MVP

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

Astrato.io Head of R&D
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
MVP
MVP

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

ralf.becher@tiq-solutions.de

Astrato.io Head of R&D
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

The platform are on z/OS

Not applicable
Author

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

any other sugestions?

Thanks

rbecher
MVP
MVP

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

- Ralf

Astrato.io Head of R&D
rbecher
MVP
MVP

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

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

- Ralf

Astrato.io Head of R&D
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob