More info about portable subfile conversion.... the customer
is on a REALLY old version of PH.
Hoppe, Eric EP
Eric.Hoppe@steelscape-inc.com
Mon, 3 Jun 2002 08:15:19 -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_01C20B11.795C5900
Content-Type: text/plain;
charset="iso-8859-1"
We use CONNX to allow the users to write their own ad-hoc queries against
our RMS PH data on the Alpha and are very pleased with the results. We (the
PowerHouse folks) keep being told SAP is coming. The CONNX people also
assure us their tool is an excellent venue for porting data.
The installation of the CONNX server on the Alpha was the easiest bit of
software I have EVER installed on that machine.
I don't work for SolutionsIQ or any of that... I just wanted to share our
satisfaction with the product.
---ehops
-----Original Message-----
From: Jones Allen (Van) [mailto:Allen.Jones@vpgroup.com]
Sent: Thursday, May 30, 2002 12:40 PM
To: 'semma@sysinc.com'; powerh-l@lists.swau.edu
Subject: RE: More info about portable subfile conversion.... the customer is
on a REALLY old version of PH.
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_01C20B11.795C5900
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 5.00.3315.2870" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=169030715-03062002>We use
CONNX to allow the users to write their own ad-hoc queries against our RMS PH
data on the Alpha and are very pleased with the results. We (the
PowerHouse folks) keep being told SAP is coming. The CONNX people also
assure us their tool is an excellent venue for porting data.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=169030715-03062002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=169030715-03062002>The
installation of the CONNX server on the Alpha was the easiest bit of software I
have EVER installed on that machine.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=169030715-03062002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=169030715-03062002>I
don't work for SolutionsIQ or any of that... I just wanted to share our
satisfaction with the product.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=169030715-03062002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=169030715-03062002>---ehops</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jones Allen (Van)
[mailto:Allen.Jones@vpgroup.com]<BR><B>Sent:</B> Thursday, May 30, 2002 12:40
PM<BR><B>To:</B> 'semma@sysinc.com';
powerh-l@lists.swau.edu<BR><B>Subject:</B> RE: More info about portable
subfile conversion.... the customer is on a REALLY old version of
PH.<BR><BR></DIV></FONT>
<DIV><SPAN class=939383919-30052002><FONT color=#000080 face=Georgia>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 align=left class=OutlookMessageHeader dir=ltr><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></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C20B11.795C5900--