Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

how to convert data generated by mainframe to oracle db/

how do i convert the data generated by Unisys A7-411 Mainframe to oracle database?  

thanks so much!
0
altair1975
Asked:
altair1975
  • 2
  • 2
  • 2
1 Solution
 
leolkkCommented:
mainframe! that means it is not a RDBMS database. Maybe convert mainframe data into text file and then using SQL*loader to upload text files into Oracle database. Certainly, tables in ORacle should be defined first.
0
 
altair1975Author Commented:

i already know how to convert from text file to oracle.  but from the data generated by mainframe to text file, that i still don't know how.  will anyone help?

thanks so much!
altair
0
 
lyonstCommented:
Hi,

You could start here ...

http://www.uvsoftware.ca/datacnv3.htm

Hope it helps ?

Cheers,

T.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
lyonstCommented:
Hi,

You can also have a look at

http://www-db.stanford.edu/~ullman/fcdb/oracle/or-load.html

Or you could look at SQL*LOADER which is described here ..

http://www.orafaq.org/faqloadr.htm#WHATIS

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Its syntax is similar to that of the DB2 Load utility, but comes with more options. SQL*Loader supports various load formats, selective loading, and multi-table loads.

Cheers,

T.

0
 
leolkkCommented:
my experience is that "I need to write program" to change data from Progress database to text file record by record.

0
 
altair1975Author Commented:
thanks!  i'll be doing the conversion in details on Sep.  the references u gave will surely help
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now