Solved

How to get data from a mainframe

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Domain Name E-mail Address & Outlook Integration 3 39
Blue Coat API portal URL 2 145
Has my website been infiltrated? 21 64
Ways to assess https/ssl websites 3 87
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
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 connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now