Solved

How to get data from a mainframe

Posted on 2004-04-16
3
214 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Google Maps 7 82
How to use MySQL Workbench to access remote MySQL databases hosted in a web site 4 102
Column Spacing 3 113
apply ddos protection on all network interface 2 130
In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

733 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