Re: Legacy Migration

Felina Urciuoli wrote:
[snip]
> We have mainframe applications currently written in CICS/COBOL
> pointing to VSAM files. We would like a way to migrate the VSAM data
> to an oracle database but still have the legacy applications stay on the
> mainframe for now until we can develop new applications using
> powerbuilder. Is there a way the CICS/COBOL programs can talk to the
> new oracle database that resides on a HP/UX server?
[snip]

Sounds like you might need a replicator to copy the mainframe data into the Oracle database on a periodic basis. If it is volatible, you want to capture all updates, queue them and redo them on the Oracle side. If it is static, you want to do a nightly copy from mainframe to HP/UX.

This is an alternative to a live ODBC connection.

You may need a more complex bridge - like DB2 on your mainframe side. Oracle can work cooperatively with DB2, and DB2 may be able to bridge to your VSAM files.

Why do you want both access methods at once? Are you going to use the Oracle system right away? How will you use the Oracle system, without your application running yet?

Perhaps you just need to do a regular production conversion from VSAM to Oracle on a daily basis so you can do Oracle report-writing. They call this a data warehouse. Don't listen to the marketing hype about warehousing. You simply need to get your VSAM files into your HP/UX box and SQL*LOAD into a database for reporting.

-- 
S. Lott
Consultant, NE Region
CTG
SLOTT_at_DELPHI.COM
S.LOTT_at_CTG.COM
800-992-5350 box 7053