Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP

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

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
MVP

QlikView support VSAM as data source?

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

ralf.becher@tiq-solutions.de

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
MVP

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
MVP

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

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

Community Browser