Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> get data from mainframe files, ADA

get data from mainframe files, ADA

From: <johnbishop_at_atl.mediaone.net>
Date: Tue, 22 Jun 1999 20:26:35 GMT
Message-ID: <7korhd$j9e$1@nnrp1.deja.com>


Anyone know of a cheap way to get data form a mainframe into ORACLE.

All options will be considered (as long as it's cheap). We are doing a proof-of-concept project and do not have the $ right now.

The best (and cheapest) we've come up with is

  1. cron calls FTP to move the data
  2. PERL transposes data (if need be)
  3. SQL*Load data in.

The next best thing we came up with was something like an EDA/SQL gateway.

I'm open to just about anything.

TIA, JB

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 22 1999 - 15:26:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US