Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to get data from a mainframe

Posted on 2004-04-16
3
Medium Priority
?
223 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Plucka earned 500 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
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. …

604 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