<plug> Quest Software has the industry standard extract tool for capturing
data on a HP3000 with low overhead and providing a facility for any Data
Warehousing tool to load data into virtually any heterogeneous database.
This tool provides for the highest speed with minimal overhead compared to
many competitors products.

Quest Software has several products in it's family called MiddleWare
Solutions http://www.quest.com/middleware/index.html . Specifically a
product called BridgeWare that is widely accepted in the industry and has
been sold for several years now with many references moving data from the
HP3000 to a Oracle, SQLServer or Informix target. Take a look at the White
Paper on our website. It is real-time or scheduled delta refreshes to the
target application database with low overhead. It works off Quest Software's
Shadowing product that can capture transactions without the need for turning
on a resource hog like TurboIMAGE/SQL Logging.

As business-critical databases and information systems continue to grow
exponentially, so does the need to obtain data from legacy applications or
databases and transition them to new platforms/data structures. Keeping
legacy systems in sync with open systems is a complex and time-consuming
task. Database size alone usually prohibits downloading all vital legacy
data into a format that can be easily selected, converted and loaded into
the new systems - quickly and easily.  To promote harmonious coexistence of
MPE and open systems in the corporate network, it's imperative to adopt an
automated process that allows transparent access to legacy data from
emerging decision-support systems. Ensuring data consistency across your LAN
or WAN is a difficult process, Quest Software offers BridgeWare(tm) for MPE.
BridgeWare, the cooperative endeavor of Quest Software and Taurus Software,
enables data movement between HP 3000 and open systems. BridgeWare addresses
one-time data migration; continual data movement to data warehouses, data
marts or new open system applications; and consolidates data into a
centralized common database or data warehouse. BridgeWare provides real-time
or scheduled posting of TurboIMAGE, KSAM, or updates to MPE files to an
Oracle RDBMS running on UNIX or NT systems, giving users the power to access
and update data across multiple platforms.

Quest's technology is used as the extract tool of choice for
Hewlett-Packard's Data Warehousing, Taurus Software's BridgeWare,
Smith-Gardner's Data Mining System and several of the other 450 Data
Warehousing solutions on the market. Quests delivers the data seamlessly and
without the overhead in real-time or scheduled timeframes.

Please contact:

John Saylor
U.S. MPE Sales Manager
Quest Software, Inc.
"Expect a Solution"

Main        (949) 720-1434
Toll Free   (800) 306-9329 x8422
Direct      (949) 754-8422
Fax         (949) 754-8999
[log in to unmask] <mailto:[log in to unmask]>

-----Original Message-----
From: [log in to unmask] [mailto:[log in to unmask]]
Sent: Wednesday, October 13, 1999 8:33 AM
To: [log in to unmask]
Subject: Re: MPE to Unix conversion: Data conversion vendors


In article
<[log in to unmask]>,
  Richard Gambrell <[log in to unmask]> wrote:
> Robert Pastor wrote:
> >
> > We're looking at using several different vendors to convert the data
we
> > have on IMAGE databases to Oracle databases running under Unix.  The
> > vendors (most notably, Metalogic Systems and Cognizant) claim that
they
> > don't need to know the applications to do the conversion.  They have
> > automated processes to catalog the data, then suggest data models
for
> > the Oracle tables.
> >
> > Naturally, the vendors promise that our applications will run faster
w/
> > Oracle and Unix than they do under MPE and Image.  (btw, thanks
Richard
> > Gambrell for your reply to David Debus original question - it was
very
> > timely, my management needs to see this kind of info).
>
> We have other numbers that support the same conclusion, but the
> differences in the applications are so great that it would be apples
to
> oranges.  But, producing an invoice is nearly identical, so it makes a
> good comparasion.  It also clearly takes longer to enter comparable
data
> in the Oracle GUI Forms than in our interactive terminal screens, but
I
> don't have numbers on that one - and that is also likely an
application
> dependent things. These Oracle forms require use of F keys and
> ctrl-nextpage combinations or mouse clicks that make data entry take
> longer to key (due to moving the hand off the home keys).
>
> >
> > 1) Does anyone have any experience w/ these vendors or this type of
> > conversion? Good things, bad things, tales of woe, precautions to
take?
>
> What not use the Oracle gateway on MPE to get to the Image datasets
from
> Unix just like it was Oracle?  Meanwhile, your MPE applications keep
> running just like that do now.
>
> >
> > 2) Any other people that you would recommend that we look at?
>
> Quest Software makes Bridgeware that replicates the data between
Oracle
> and TurboImage.  Please note, I have not used this product - just know
it
> exists.
> --
> Richard L Gambrell
> Database Administrator and
> Consultant to Computing Services at UTC
>
> ** UTC business:
>   University of Tennessee at Chattanooga
>   113 Hunter Hall, Dept. 4454
>   615 McCallie Ave., Chattanooga, TN 37403-2598
>   fax: 423-755-4025
>   phone: 423-755-4551       email: [log in to unmask]
>
> ** other business or private:
>   voice mail/phone: 423-874-0261  email: [log in to unmask]
>
>
Hi
I've used oracle open gateway to hp/mpe (allbase sql) over one year in
both way - getting info and writing other info to hp tables. The thing
realy works but very few people know how to configure it. We've used it
and still using it to retrive and store data online and offline.
response time vary a lot usually due to the hp workload. If U just want
single move from hp to oracle then it is a very good tool, altough
expensive. One known bug/feature is that when U create a table in oracle
according to the hp like 'create table a as select * from b@hp' then all
the fields will be created as 'not null', I belive U can fix it
manually. If U need more info then write to [log in to unmask]


Sent via Deja.com http://www.deja.com/
Before you buy.