HP OpenVMS Systems

Datatrieve data import and export?

» close window

The Question is:

 
I have a one-time and will have a continuing
need to upload information from a Datatrieve
database to an Oracle database for a data warehousing
application.
Datatrieve represents several source databases,
MVS VSAM represents others, and Oracle on Unix
represents a third.  I would like to know what
extract tools, gateways, or procedures I could
use to easily access or port the data.
 
Thanks,
Chip
 
 

The Answer is :

 
    The files being accessed by DTR is surely an RMS (indexed) file
    and it would be straigthforward to write a program to read that
    directly for input and call Oracle to perfrom INSERTS with the
    data on the output side.
 
    As you have DTR available, it is probably more expedient to use
    the DTR power to search, sort and cleanup the input into an
    output 'domain' mapped on a flat sequential file. Then FTP the
    file over to the target system, and IMPORT into oracle with a
    control file. Withing DTR i'd probaly try to use the RESTRUCTURE
    function (use HELP) :  DTR> oracle_data = input_data_rse
 
 

  

     

     
answer written or last revised on ( 9-OCT-1998 )
     
» close window