Solved

How to get data from a mainframe

Posted on 2004-04-16
3
210 Views
Last Modified: 2013-12-24
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.
0
Comment
Question by:astro26
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Plucka earned 125 total points
ID: 10847501
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
 
LVL 18

Expert Comment

by:Plucka
ID: 10856574
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
 

Author Comment

by:astro26
ID: 10878164
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question