RE: cross platform replication -- MIDRANGE-L

Transformation Server requires journals.

I looked at Symbiator a few times for connecting an Oracle database to some AS/400 tables but never had enough time to finish it properly, but my recollection is that it used ODBC to connect to the target and source databases and somehow tracked what was synched and what wasn't. The separate box using ODBC would explain why it claimed it could send the data in either direction which was of interest to me at the time.

   You might also want to add into your decision process what hardware would
   be required.  I know for instance Symbiator requires a Windows base box to
   run on (other than your Oracle server if it is running on one).  When I
   worked with DataMirror and Mimix they didn't, but that was sometime ago.
   Also, Mimix (when I worked with it) required the files to be journaled,
   but I don't believe either DataMirror or Symbiator did.

I have no experience with RPG2SQL Integrator.

   >From: Jim Damato <jdamato@xxxxxxxxxxxxxxxxx>
   >Reply-To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
   >To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
   >Subject: RE: cross platform replication
   >Date: Fri, 14 May 2004 13:12:08 -0500
   >
   >So it really comes down to which product has the coolest name:
   >
   >1) Symbiator
   >2) Omni-Replicator
   >3) Transformation Server
   >4) RPG2SQL Integrator
   >
   >I kind of agree with Evan.  I'd really like to own a Symbiator regardless
   of
   >what it actually does.
   >
   >I may have to choose based on how well the company runs their website.
   >Mimix's site is designed to obscure and withhold information, encouraging
   >contact with Sales.  Data Mirror's "Contact Sales" button generated an
   >e-mail that gets bounced by their mail server.
   >
   >Thanks to everyone for their advice.
   >
   >-Jim
   >
   >
   >-----Original Message-----
   >From: don yattaw [mailto:neal_dy@xxxxxxxxxxx]
   >Sent: Friday, May 14, 2004 10:02 AM
   >To: midrange-l@xxxxxxxxxxxx
   >Subject: Re: cross platform replication
   >
   >
   >    There is also mimix's omni-replicator tool.
   >
   >    >From: Evan Harris <spanner@xxxxxxxxxx>
   >    >Reply-To: Midrange Systems Technical Discussion
   ><midrange-l@xxxxxxxxxxxx>
   >    >To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
   >    >Subject: Re: cross platform replication
   >    >Date: Fri, 14 May 2004 23:16:51 +1200
   >    >
   >    >Hi Jim
   >    >
   >    >Vision's Symbiator product (great name) and DataMirror's
   >    >Transformation Sverer are the two I'm aware of in this area though
   >    >I'm not entirely sure whether they exactly meet your needs or not.
   >    >
   >    >Cheers
   >    >Evan Harris
   >    >
   >    >
   >    >>We've been talking about buying Oracle's DB/2 AS/400 Gateway
   >    >>product.  In
   >    >>considering our application needs we've come to realize that it
   >    >>isn't going
   >    >>to do what we want because it's going the wrong way.
   >    >>
   >    >>We need to replicate data where the AS/400 is the source system.
   >    >>The
   >    >>gateway allows you to create an Oracle view to an AS/400 table.
   >    >>We're
   >    >>dealing with large AS/400 tables, updated frequently.  On the
   >    >>Oracle side
   >    >>we'd  have to pull all the data through the view instead of
   >    >>accepting
   >    >>periodic updates/changes.
   >    >>
   >    >>Is anyone working with replication from an AS/400 to an Oracle
   >    >>database?  I
   >    >>know IBM has an incredibly expensive solution, and I can think of a
   >    >>few
   >    >>complicated ways to roll my own.
   >    >
   >_______________________________________________
   >This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
   list
   >To post a message email: MIDRANGE-L@xxxxxxxxxxxx
   >To subscribe, unsubscribe, or change list options,
   >visit: http://lists.midrange.com/mailman/listinfo/midrange-l
   >or email: MIDRANGE-L-request@xxxxxxxxxxxx
   >Before posting, please take a moment to review the archives
   >at http://archive.midrange.com/midrange-l.
   >

----------------------------------------------------------------------

   FREE pop-up blocking with the new MSN Toolbar * get it now!
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.