IDMS to Oracle/SQL SVR

Discussion created by ca.portal.admin on Jan 23, 2009
Greetings list,

We are currently on IDMS r16.2 and have a WebLogic application accessing
it, and with great success. This is done thru an TCP/IP connection.
There is now a project underway to do a proof of concept to have an IDMS
program access an Oracle, or SQL Server database.
I have been doing my homework and see that it can be done. Now I'm
trying to put together the pieces on the IDMS side for a very simple
test to pass one piece of data, and get a simple message saying it was
Being the mainframe bigot that I am, I thought it best to check with
this group for ideas and recommendations, before jumping into the pond.
So any ideas, war stories, victory dances, and recommendations would be
greatly appreciated.

Thank you,
Del Barlett
IDMS DBA for the State of New Hampshire
IDMS Public Discussion Forum


Re: IDMS to Oracle/SQL SVR
"IUA Connections, September 2008, had an article on page 10 that ought to
be useful. Also - at CA-World 2008 Terry Schwartz had a paper on just
this topic - I would suggest a download might be in order. Also the
Summer (September) 2007 issue had an article on page 9 (also by Kay
Rozeboom) titled ""Accessing Web Services from the Mainframe"". All IUA
Connections for the past number of years are available at

HTH - cheers - Gary=20

Gary Cherlet
Justice Technology Services
Department of Justice, SA Government
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613

This e-mail message and any attachments are qualified as follows:
Addressing: If you have received this e-mail in error, please advise by
reply e-mail to the sender. Please also destroy the original
transmission and its contents. Confidentiality: This e-mail may contain
confidential information which also may be legally privileged. Only the
intended recipient(s) may access, use, distribute or copy this e-mail.
Individual Views: Unless otherwise indicated, the views expressed are
those of the sender, not Justice Technology Services. Computer Viruses:
It is the recipient's responsibility to check the e-mail and any
attached files for viruses.