| Author |
Message
|
| Seagull |
 Posted: Thu Jul 10, 2008 6:44 pm Post subject: Avoiding the use of JDBC Adapter.. |
 |
|
Novice
Joined: 05 Feb 2007
Posts: 11
|
I have a Database which will be updated daily and once its updated it needs send some data to Ariba app/DB.
Now is there any way I can avoid using JDBC adapter at the source, if so how should I kick off the message flow by getting a message onto my input node every time there is a database update on the source side.
Thanks in advance. |
|
| Back to top |
|
 |
| sridhsri |
| Posted: Thu Jul 10, 2008 8:23 pm Post subject: |
|
|
Master
Joined: 19 Jun 2008
Posts: 297
|
What database are you using ?
I have never done this before, but I have been told that DB2 has some extensions which are capable of putting a message on queue from a trigger. I have the link to the help of DB2 9.1 which talks about how this can be done (http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_webspheremqdb2.htm) |
|
| Back to top |
|
|
| SAFraser |
| Posted: Thu Jul 10, 2008 9:50 pm Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
| Oracle AQ can construct a message and use the Oracle Messaging Gateway to put (or get) a message. The Gateway is a client application to MQ. |
|
| Back to top |
|
|
| Seagull |
| Posted: Fri Jul 11, 2008 10:37 am Post subject: |
|
|
Novice
Joined: 05 Feb 2007
Posts: 11
|
We are using Informix Database version 11.5.
WMB version 6.1
I can write code in esql/c like a stored procedure to retrieve the data but how to put it on queue or input on broker? |
|
| Back to top |
|
|
| sridhsri |
| Posted: Fri Jul 11, 2008 12:30 pm Post subject: |
|
|
Master
Joined: 19 Jun 2008
Posts: 297
|
| I am not sure if what I said was application to Informix. But with DB2, in the SQL code you could write MQ calls to put a message on a queue. This message would then drive a message flow. |
|
| Back to top |
|
|
| Seagull |
| Posted: Fri Jul 11, 2008 1:29 pm Post subject: |
|
|
Novice
Joined: 05 Feb 2007
Posts: 11
|
| Any help from experts ould be ighly appreciated. |
|
| Back to top |
|
|
| Seagull |
| Posted: Tue Jul 15, 2008 12:43 pm Post subject: |
|
|
Novice
Joined: 05 Feb 2007
Posts: 11
|
|
| Back to top |
|
|
|
|
