How to get data from a mainframe

I need to do a proof of concept for Family Services, they have a mainframe (Unisys).  What information do I need to run a pilot.

business question:
How can I pull data from a mainframe to determine foodstamp status?
It will be read only, a web interface, allowing local centers to pull up the secure site and determine the status of the food stamp request.

Reason,
it will give people in service centers ability to use web interface for data from mainframe.


Question:
How do I connect and find the information from the mainframe?
Oracle 8i, coldfusion 5.

Options
1) connect to mainframe somehow
2) dump data from mainframe to Oracle table/database - coldfusion query oracle for status... (how would I dump to oracle). Heterogeneous services?

TIA,
let me know if you need more info.
astro26Asked:
Who is Participating?
 
PluckaCommented:
The mainframe will have the data in a database of some sort. Could be DB2 or something similar. So for most databases you will be able to talk directly to the data by setting up an ODBC connection. What you need is

1. Determine what the mainframe database is
2. Install / purchase the necessary ODBC drivers for the mainframe
3. Configure the datasource in CF

That's it, we do this all the time when talking to old databases, we find there's prety much an ODBC driver for everything these days.
0
 
PluckaCommented:
astro26,

Any luck determining if there are any ODBC drivers on the Mainframe, another way (if possible) is to have the Mainframe expose the data as a webservice and then consume it from Coldfusion.

Let me know.

Regards
Plucka
0
 
astro26Author Commented:
I am waiting to work on the project, I just wanted a heads up.  I appreciate your help, and may add additional question if needed.  Thanks for all the help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.