Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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
MVP & Luminary
MVP & Luminary

QlikView support VSAM as data source?

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

MVP & Luminary
MVP & Luminary

QlikView support VSAM as data source?

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

MVP & Luminary
MVP & Luminary

QlikView support VSAM as data source?

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

ralf.becher@tiq-solutions.de

MVP & Luminary
MVP & Luminary

Re: QlikView support VSAM as data source?

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

QlikView support VSAM as data source?

The platform are on z/OS

Not applicable

QlikView support VSAM as data source?

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

any other sugestions?

Thanks

MVP & Luminary
MVP & Luminary

QlikView support VSAM as data source?

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

- Ralf

MVP & Luminary
MVP & Luminary

QlikView support VSAM as data source?

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

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

- Ralf

MVP & Luminary
MVP & Luminary

Re: QlikView support VSAM as data source?

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

-Rob