| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ to Database connectivity |
« View previous topic :: View next topic » |
| Author |
Message
|
| halbe01 |
 Posted: Thu Sep 15, 2005 12:51 am Post subject: MQ to Database connectivity |
 |
|
Novice
Joined: 02 Feb 2005
Posts: 16
|
Hi,
We have a requirement to be able to take incoming MQ messages and put them in a database table (Oracle, as it happens), and to also be able to do the reverse (ie take rows from a table and convert to messages).
We're not running a Broker, so apparently can't buy the JDBC adapter (which otherwise would work perfectly). I've been searching for 3rd party tools to do this job, but can't find any which seem suitable.
I'm aware that there are some Oracle add-ins which might do this, but as I'm not an Oracle expert, a 3rd party tool should be simpler to get to grips with.
Has anyone done this - preferably without writing a bespoke tool (which we could do, but it'd never be as reliable as something we purchase). Can anyone recommend any tools?
Many thanks for any advice,
Ben. |
|
| Back to top |
|
 |
| Cliff |
| Posted: Thu Sep 15, 2005 2:15 am Post subject: |
|
|
Centurion
Joined: 27 Jun 2001
Posts: 145
Location: Wiltshire
|
Ben,
what you are describing is quite simple. All you need is to choose a language that can talk to Oracle and can talk to MQ - there are plenty that can do this including Assembler, COBOL, PL/1, Perl, C, Visual Basic, Java .....
Depending on your requirements you may want to consider XA transaction coordination. Oracle is XA compliant, so no problems there.
Hope this helps -
Cliff |
|
| Back to top |
|
|
| halbe01 |
| Posted: Fri Sep 16, 2005 12:39 am Post subject: |
|
|
Novice
Joined: 02 Feb 2005
Posts: 16
|
Thanks for the reply Cliff - that seems to be the response I'm getting in general to this query. And of course you're right, I can write a tool for this if that's the best option, however I'm just very surprised there isn't anything commercially available. It seems like it would be a common requirement.
Guess I'll just have to make the tool good and then sell it..!
Cheers,
Ben. |
|
| Back to top |
|
|
| Cliff |
| Posted: Fri Sep 16, 2005 1:23 am Post subject: |
|
|
Centurion
Joined: 27 Jun 2001
Posts: 145
Location: Wiltshire
|
Ben,
if your requirement is to talk to Oracle for a specific application, then there may well be an adapter in the marketplace. The Crossworlds product used to provide this kind of functionality - it's now evolved into some other part of the Websphere product set though, and I can't remember what it's now called. If you need other transformation and routing too then you could consider the Message Broker as this can also do what you want though it's far too big (and expensive) a product just to be used to stash and retrieve messages to and from Oracle!
If you are going to write some code yourself, don't forget there are lots of good code examples around to help you get going. There is the code repository here and also one on Roger Lacroix's Capitalware site. And I expect a post here would elicit a response from someone willing to share code.
Good luck -
Cliff |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Fri Sep 16, 2005 12:00 pm Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
