ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Reading Bulk Data from Oracle Database

Post new topic  Reply to topic
 Reading Bulk Data from Oracle Database « View previous topic :: View next topic » 
Author Message
prasunad
PostPosted: Thu Jul 10, 2014 9:41 am    Post subject: Reading Bulk Data from Oracle Database Reply with quote

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
View user's profile Send private message
Vitor
PostPosted: Thu Jul 10, 2014 10:19 am    Post subject: Reply with quote

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
View user's profile Send private message
prasunad
PostPosted: Thu Jul 10, 2014 12:45 pm    Post subject: Reply with quote

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
View user's profile Send private message
mqjeff
PostPosted: Thu Jul 10, 2014 1:15 pm    Post subject: Reply with quote

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
View user's profile Send private message
prasunad
PostPosted: Thu Jul 10, 2014 10:56 pm    Post subject: Reply with quote

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
View user's profile Send private message
Vitor
PostPosted: Fri Jul 11, 2014 4:37 am    Post subject: Reply with quote

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
View user's profile Send private message
prasunad
PostPosted: Fri Jul 11, 2014 11:53 am    Post subject: Reply with quote

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
View user's profile Send private message
Vitor
PostPosted: Fri Jul 11, 2014 12:16 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Reading Bulk Data from Oracle Database
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.