Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I 'm need a connection ODBC of Cobol whit QlikView, if anyone knows would appreciate your help.
Thanks
Att: Diego
There is no COBOL ODBC exactly. Typical COBOL data access would be a DBMS like DB2, or VSAM or flat files. I'm guessing you are trying to access VSAM or flat files? Can you be specific?
-Rob
Thank's for your help.
I' m basic need is extract the data .dat and .inx of Cobol and convert on .qvd in QlikView, or of know a tools that migrate the data of Cobol to SqlServer or Oracle.
Thank's
Att: Diego Hernandez
Hi
For your need exists the product Relativity, it converts the Cobol Files into "tables", that can be accesed by an ODBC connection.
I've participated in projects with this tool with good results
Rgds.
Hello !
We use Cobol on mainframes here. And we use QV with all of our mainframe files.
What we do is to extract the tables as CSV files. We "dump" mainframe tables as CSV files outside the mainframe.
And we only "dump" tables that have been modified since last dump. This optimizes a lot the download process.
We also have built a kind of "automator" that reads the table layout and builds automatically a Cobol program to dump that table into a CSV. The developer simply points the tables that are to be downloaded and also the fields to be downloaded. All the rest is done automatically.
Anyway, let me know if I can help you with some ideas.
See ya !
diegofha wrote:I' m basic need is extract the data .dat and .inx of Cobol and convert on .qvd in QlikView, or of know a tools that migrate the data of Cobol to SqlServer or Oracle
I'm familiar with mainframe COBOL and this looks like Windows, so I don't have any insights. However, it looks like you got another possible response.
-Rob
Hello Diego !
Some points for you :
Hope that all can help you, OK ?
Where are U talking from ? Maybe we can exchange ideas in private mode (email).
Good Luck ! See ya !
Forgot to mention : our source files are in OEM coding !
Hi, Adriano
Thank's for your help, I Think will be very useful.
See ya !
OK.
One ESSENTIAL thing that you must understand : ALWAYS transform your CSV files into QVDs.
QVDs are way, way faster to be read by QV.
Since your final applications will have to read the files several times during development process, perfomance here is very important.
Have done some tests here. You can have an idea :
So, hope you understand this key point, OK ?
Let us know what you ended up doing there on your side, OK ? So that we can share some ideas as well.
What environment you are ? Mainframe ? IBM ? What is the machine and Operating System ? We're on a Unisys Mainframe.
See ya !