More info about portable subfile conversion.... the customer
is on a REALLY old version of PH.
Jones Allen (Van)
Allen.Jones@vpgroup.com
Thu, 30 May 2002 12:39:59 -0700
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C20811.C89F6230
Content-Type: text/plain;
charset="iso-8859-1"
Check out www.connx.com <http://www.connx.com> . They have a product that
can access RMS files and Oracle databases.
-----Original Message-----
From: Sal Emma [mailto:semma@sysinc.com]
Sent: Thursday, May 30, 2002 12:29 PM
To: powerh-l@lists.swau.edu
Subject: More info about portable subfile conversion.... the customer is on
a REALLY old version of PH.
Roll out the wayback machine, and dust it off this is a puzzler....
The customer is on version (gulp) 6.10E on a microvax. No chance of
upgrading. No TCPIP available either, so I can't even think about using an
ODBC driver to read the RMS files. The only way I can connect to the
machine is through RLAT. (Reflections LAT) I can transfer the files off at
high speed like FTP.
I need to transfer the data into Oracle.... I can't use QTP to go directly
to Oracle because the version of PH doesn't support Oracle. I think my
only alternative is to get the data to portable subfiles.
I have the schema already built in Oracle, though.
The customer was running a legacy ERP system called Visibility. They want
to get their history data into Oracle so that it can live on forever and
ever! From what I understand, Visibility used portable subfiles and their
own scripts to pump the data into Oracle. Any takers?
Thanks,
Sal Emma
------_=_NextPart_001_01C20811.C89F6230
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=939383919-30052002><FONT face=Georgia color=#000080>Check out
<A href="http://www.connx.com">www.connx.com</A>. They have a product that
can access RMS files and Oracle databases. </FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Sal Emma
[mailto:semma@sysinc.com]<BR><B>Sent:</B> Thursday, May 30, 2002 12:29
PM<BR><B>To:</B> powerh-l@lists.swau.edu<BR><B>Subject:</B> More info about
portable subfile conversion.... the customer is on a REALLY old version of
PH.<BR><BR></FONT></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>Roll out the
wayback machine, and dust it off this is a puzzler....</FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>The customer is on
version (gulp) 6.10E on a microvax. No chance of upgrading.
No TCPIP available either, so I can't even think about using an ODBC
driver to read the RMS files. </FONT></SPAN><SPAN
class=306191319-30052002><FONT face=Arial size=2>The only way I can connect to
the </FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>machine is through
RLAT. (Reflections LAT) I can transfer the files off at high speed
like FTP. </FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>I need to transfer
the data into Oracle.... I can't use QTP to go directly to Oracle
because the version of PH doesn't support Oracle. I think my only
alternative is to get the data to</FONT></SPAN><SPAN
class=306191319-30052002><FONT face=Arial size=2> portable
subfiles. </FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>I have the schema
already </FONT></SPAN><SPAN class=306191319-30052002><FONT face=Arial
size=2>built in Oracle, though. </FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>The customer was
running a legacy ERP system called Visibility. They want to get their
history data into Oracle so that it can live on forever and ever!
From what I understand, Visibility used portable subfiles and their own
scripts to pump the data into Oracle. Any
takers?</FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>Sal
Emma</FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C20811.C89F6230--