| Author |
Message
|
| Twilight |
 Posted: Tue Jun 14, 2005 10:39 am Post subject: MQ Oracle adaptor selection |
 |
|
Apprentice
Joined: 04 Aug 2004
Posts: 49
|
Hi, There.
I'm trying to select a S/W that MQ from/to Oracle interface and researching for it.
IBM has one and Oracle has one( I believe it is called Oracle Interconnect Adapter for MQ).
Also, I found Oracle has AS(Application Server) does samething also.
But, I couldn't tell which one offers simple way to use and configure.
I want to update Oracle DB from MQ without using any other program.
Please advice me.
Thanks in advance. 
_________________
WMQ/WMQI/WBI Consultant
Toronto, Canada |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Jun 14, 2005 10:44 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You will need to configure something to map the contents of the message into the appropriate fields in the database and vice versa.
This almost always requires writing code of some sort or another.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Twilight |
| Posted: Tue Jun 14, 2005 10:49 am Post subject: |
|
|
Apprentice
Joined: 04 Aug 2004
Posts: 49
|
| jefflowrey wrote: |
You will need to configure something to map the contents of the message into the appropriate fields in the database and vice versa.
This almost always requires writing code of some sort or another. |
As I know, IBM or Oracle has XML inteface include in their product for both MQ to Oracle or Oracle to MQ message transfer.
Thanks, Steve
_________________
WMQ/WMQI/WBI Consultant
Toronto, Canada |
|
| Back to top |
|
|
| vennela |
| Posted: Tue Jun 14, 2005 10:51 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I used Oracle Interconnect to update Oracle DB with MQ messages.
You need MQ Aapter to read/write to MQ Queues, and you need DB adapter to READ/WRITE to Oracle DB and you will use Oracle Interconnect (or Oracle Application Server or something like that) as the broker.
This definitely needs lot of work. You need to use iStudio or something that Oracle offers to map the fileds.
What is the IBM product that you are referring to? |
|
| Back to top |
|
|
| vennela |
| Posted: Tue Jun 14, 2005 10:53 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Quote: |
| As I know, IBM or Oracle has XML inteface include in their product for both MQ to Oracle or Oracle to MQ message transfer. |
AFAIK, the MQ adapter for Oracle Interconnect can read XML messages or FIXED Width Messages or Tag Delimited messages. |
|
| Back to top |
|
|
| Twilight |
| Posted: Tue Jun 14, 2005 11:11 am Post subject: |
|
|
Apprentice
Joined: 04 Aug 2004
Posts: 49
|
| vennela wrote: |
| Quote: |
| As I know, IBM or Oracle has XML inteface include in their product for both MQ to Oracle or Oracle to MQ message transfer. |
AFAIK, the MQ adapter for Oracle Interconnect can read XML messages or FIXED Width Messages or Tag Delimited messages. |
Great ! folks.
Your replies help me a lot.
BTW, Has Anybody used/been using IBM Oracle adapter ?
I need a some feedback on IBM adapter.
Thanks again.
_________________
WMQ/WMQI/WBI Consultant
Toronto, Canada |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Jun 14, 2005 11:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Twilight wrote: |
BTW, Has Anybody used/been using IBM Oracle adapter ?
I need a some feedback on IBM adapter.
Thanks again. |
What is the actual name of the product you are referring to?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Twilight |
| Posted: Tue Jun 14, 2005 11:15 am Post subject: |
|
|
Apprentice
Joined: 04 Aug 2004
Posts: 49
|
| jefflowrey wrote: |
| Twilight wrote: |
BTW, Has Anybody used/been using IBM Oracle adapter ?
I need a some feedback on IBM adapter.
Thanks again. |
What is the actual name of the product you are referring to? |
IBM WebSphere Adapter for Oracle Applications.
Thanks, Steve
_________________
WMQ/WMQI/WBI Consultant
Toronto, Canada |
|
| Back to top |
|
|
| vennela |
| Posted: Tue Jun 14, 2005 1:50 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I looked at the WBI Adapters. The above mentioned adapter is listed under Applications.
Well you will also have to tell what broker, you are gonna use with these adapters.
If for example you use ICS as the broker and use MQ adapter and Oracle adapter on each sie, you will have to create BO's and MAPS along with PASSTHRU collaborations. I have done a similar POC where the DB was SQL Server. We used JDBC adapter to update the DB and MQ adapter to read from the QUEUEs. That worked really well.
BUT, I cannot tell you which one will prove to be a better choice because I have not seen the IBM adapter in production. Supportwise, IBM offers better support. |
|
| Back to top |
|
|
| Twilight |
| Posted: Wed Jun 15, 2005 12:04 pm Post subject: |
|
|
Apprentice
Joined: 04 Aug 2004
Posts: 49
|
| vennela wrote: |
I looked at the WBI Adapters. The above mentioned adapter is listed under Applications.
Well you will also have to tell what broker, you are gonna use with these adapters.
If for example you use ICS as the broker and use MQ adapter and Oracle adapter on each sie, you will have to create BO's and MAPS along with PASSTHRU collaborations. I have done a similar POC where the DB was SQL Server. We used JDBC adapter to update the DB and MQ adapter to read from the QUEUEs. That worked really well.
BUT, I cannot tell you which one will prove to be a better choice because I have not seen the IBM adapter in production. Supportwise, IBM offers better support. |
I'll try it Oracle version and see what happens.
Thanks a lot.
_________________
WMQ/WMQI/WBI Consultant
Toronto, Canada |
|
| Back to top |
|
|
|
|
