Data retrival from the Mainframe system

Could you pls advice me is that anyway can we pull down the data fromt heMainframe sytem.For Instance:-We are using mainframe system for all accounting activities. The excel macroshould get the journal voucher number and it should be generated in themainframe system through VBA and could copy the entire Journal voucher from themainframe to specified excel file.Please advice me on this

Share:

5 Answers Found

The method of retrieval would depend entirely upon what communicationprotocols you have in place between the PC and the mainframe. Youshould review the documentation for them -- that should give you agood idea on how to do it.

Talk to the section of your IT department that is responsible for themainframe. They should have procedures for FTPing information from themainframe to a text file on the LAN. Depending on the mainframe software,the terminal emulator may have the capability of transferring files from themainframe.

Though mainframes have common features, the actual applications are variedand the method of transferring information are also varied. The only oneswho would know for sure are the ones actually running the mainframe.

Politically, mainframes are far more compartmentized and security consciousthan a LAN and though you may be able to take a USB to a friend's PC, youwill run into a wall of procedures if you try to do that on a mainframe. Youmay run into a lot of "Not my department".

As I said before, the method will depend entirely on what mechanismyou have in place to communicate between the mainframe and the PC.There are a number of different products that provide thatfunctionality and each would have their own protocols that need to beused. You would be best off referring to the documentation for thatproduct.

When I implemented this for our systems, we had two different methodsavailable to us.

No one will be able to help you unless you can specify things like:

-- What kind of mainframe you're getting the data from-- What kind of PC/servers you have-- What communication protocols are in place-- How your system programmers installed the communication software-- What security firewalls and other options they have decided to go with

...etc, etc

You'd be best off contacting your own system programmers. They shouldhave those details and be able to tell you how to do what you need todo. *IF* you can at all!