| Author |
Message
|
| prasunad |
 Posted: Thu Jul 10, 2014 9:41 am Post subject: Reading Bulk Data from Oracle Database |
 |
|
Novice
Joined: 10 Jul 2014
Posts: 22
|
Hi experts,
Can you please advise me on how we can use ESB to read bulk data from database and generate XML data to be sent to Target systems.
to be precise - one row = one xml payload.
Thanks |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Jul 10, 2014 10:19 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Read the data from the database
Itterate over the result set generating one output XML per row.
From what you've said of your requirement, there's nothing more we can sensibly add
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| prasunad |
| Posted: Thu Jul 10, 2014 12:45 pm Post subject: |
|
|
Novice
Joined: 10 Jul 2014
Posts: 22
|
Thanks vitor.
Was thinking if there is any adaptor or support PAC which can do this. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jul 10, 2014 1:15 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| prasunad wrote: |
Thanks vitor.
Was thinking if there is any adaptor or support PAC which can do this. |
Why would you need to use anything other than the basic features of the product? |
|
| Back to top |
|
|
| prasunad |
| Posted: Thu Jul 10, 2014 10:56 pm Post subject: |
|
|
Novice
Joined: 10 Jul 2014
Posts: 22
|
| as Vitor mentioned, iterative approach is a very good option, so was wondering if there is another alternative other than that. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jul 11, 2014 4:37 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| prasunad wrote: |
| so was wondering if there is another alternative other than that. |
Such as?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| prasunad |
| Posted: Fri Jul 11, 2014 11:53 am Post subject: |
|
|
Novice
Joined: 10 Jul 2014
Posts: 22
|
that is the question..
was reading about Oracle Gateway for MQ, not sure it can do... as I have just started reading about it. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jul 11, 2014 12:16 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| prasunad wrote: |
| was reading about Oracle Gateway for MQ, not sure it can do... as I have just started reading about it. |
Wouldn't have thought that.
You could use one of the ETL tools I imagine. Not sure that would be better / easier / cheaper than WMB/IIB
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
