Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

IDMS Replication to Oracle

76 views
Skip to first unread message

BRUCE SWIST

unread,
Sep 13, 1996, 3:00:00 AM9/13/96
to

I am working with a client that is attempting to use a subset of their
IDMS data on an Oracle database. Does anyone have a recommendation
for a commercial tool or software that can be used to replicate IDMS
data on an Oracle database.

Thank You,
Bruce Swist

Marc Niegowski

unread,
Sep 15, 1996, 3:00:00 AM9/15/96
to

Hello Bruce,

Remember me? It's certainly been a very long time. Anyway, I can't claim to
know very much about Oracle, but I'm just begining to research some of CA's
OpenIngress products which include a gateway to IDMS/R. You may want to talk
to our friends at CA regarding the OpenIngress stuff. Additionally, you'll
need the IDMS/R SQL Option. The OpenIngress/Oracle gateway and the
OpenIngress/IDMS gateway should allow your Oracle instances to read and write
IDMS/R tables, and the OpenIngress/IDMS gateway should allow your IDMS/R CV's
to read and write Oracle tables. It will use Ingress as a virtual DB to
translate SQL queries back and forth. Hope this helps you to get started.

Regards,
Marc Niegowski
Mnie...@InterServ.com

BRUCE SWIST <BRUCE...@FMSO.NAVY.MIL> wrote in article
<2395F8...@fmso.navy.mil>...

Willakka

unread,
Sep 16, 1996, 3:00:00 AM9/16/96
to

Check with ALLEN SYSTEMs GROUP in Naples Florida, they are working
with CA to produce a product that replicates IDMS data to Oracle, Sybase,
DB2, and others. I beleive this product will be available sometime next
year.

Andrew Levy

unread,
Sep 17, 1996, 3:00:00 AM9/17/96
to

CGI Systems, Inc. An IBM Company currently has a solution available.
Contact idm...@cgisystems.com

Steve Machnik

unread,
Sep 17, 1996, 3:00:00 AM9/17/96
to

> I am working with a client that is attempting to use a subset of their
> IDMS data on an Oracle database. Does anyone have a recommendation
> for a commercial tool or software that can be used to replicate IDMS
> data on an Oracle database.

I know this probably won't help you if your looking for a single utility to do
the whole job, but...

We use our own home-grown batch programs to create extract files on the
mainframe,
ftp the files to the Oracle (UNIX) server, then use the Oracle SQL*Loader
utility
to load the data into our Oracle database.

Steve Machnik; DBA; Clemson University; Clemson, SC; USA; s...@clemson.edu

George MacIntosh

unread,
Sep 18, 1996, 3:00:00 AM9/18/96
to

Bruce,

You could try International Software Products. Their DARS product has
been replicating to Oracle and Sybase since sometime early in 1995 in
a very large IDMS site up here in Canada. From their marketing lit,
they can 'Replicate to any RDBMS' on any platform'. I also know
through a fiend that works at the site that they have successfully run
to IBM's DataPropagator product and DB2 on OS/2, RS/6000 and MVS as
well as Sybase.

George MacIntosh
BRUCE SWIST <BRUCE...@FMSO.NAVY.MIL> wrote:

> I am working with a client that is attempting to use a subset of their
> IDMS data on an Oracle database. Does anyone have a recommendation
> for a commercial tool or software that can be used to replicate IDMS
> data on an Oracle database.

> Thank You,
> Bruce Swist

0 new messages