| Author |
Message
|
| muks |
 Posted: Fri Apr 12, 2013 4:01 am Post subject: Using .MDQ file in WMB |
 |
|
Newbie
Joined: 11 Apr 2013
Posts: 5
|
Hi, I have created a map using Design Studio and .mdq file using DATABASE INTERFACE DESIGNER. The map uses database as an adapter and requires a query from the .mdq file to run. The map runs successfully in Design Studio. But the map doesn't work in the flow. How to give input to the query file used in the database adapter on the input card? The query is something like this.." select * from emp where empid=#dummyvalue#"; The value for empid is dynamic. I have used an MQ input node and wtx node after dat. Can anyone help me how to integrate this map with the flow and how to give input so as to trigger the map to run and generate the output ? Desperately looking for the solution. Any help is appreciated.
Thanks & Regards
Muks |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Fri Apr 12, 2013 4:08 am Post subject: Re: Using .MDQ file in WMB |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| muks wrote: |
| Desperately looking for the solution. Any help is appreciated. |
When you attended the required training class or read the InfoCentre, what was the solution presented?
WTX integrates with WMB flows just like any other node. If you need empid as part of your WTX input card, you query the database through a COMPUTE node or a DATABASE node to retrieve the proper value.
Maybe I'm not understanding your question, but it seems like you are asking for help on how to get empid from the database? No?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| muks |
| Posted: Fri Apr 12, 2013 4:26 am Post subject: |
|
|
Newbie
Joined: 11 Apr 2013
Posts: 5
|
| Thanx a lot lancelotlinc for replying. m sorry if the question wasnt clear. My map uses a query from the .mdq file as an input. The query has a where clause which expects a string value. Based on that value the query is triggered and the records are fetched and given as an input to the map. So basiscally for the query "Select * from emp where empid=?"; if the empid=1 all the respective records are fetched and the map runs. My problem is how to give input (i.e value for variable empid) through WMB flow? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Apr 12, 2013 4:32 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| muks wrote: |
| Thanx a lot lancelotlinc for replying. m sorry if the question wasnt clear. My map uses a query from the .mdq file as an input. The query has a where clause which expects a string value. Based on that value the query is triggered and the records are fetched and given as an input to the map. So basiscally for the query "Select * from emp where empid=?"; if the empid=1 all the respective records are fetched and the map runs. My problem is how to give input (i.e value for variable empid) through WMB flow? |
http://publib.boulder.ibm.com/infocenter/wtxdoc/v8r2m0/index.jsp?topic=/com.ibm.websphere.dtx.wtx4wmb.doc/concepts/c_wtx4wmb_node_overview.htm
| Quote: |
| The WTX Map node uses one or more broker message trees as its input. If the message tree that arrives at the input terminal consists of a single message, select which input card receives the message. If the message tree that arrives at the input terminal is a message collection, containing multiple messages, each message in the collection is delivered to the appropriate input card. Then the WTX Map node runs the map. |
Did you attend the required training? WMB training consists of 9 days of training. WTX consists of another 12 days.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| muks |
| Posted: Fri Apr 12, 2013 4:39 am Post subject: |
|
|
Newbie
Joined: 11 Apr 2013
Posts: 5
|
| Nope. But i have used wtx map nodes in my earlier wmb flows. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Apr 12, 2013 4:41 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| muks wrote: |
| Nope. But i have used wtx map nodes in my earlier wmb flows. |
Thats great. Perhaps you may have missed some information in the InfoCentre. Please read about WTX nodes there.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Apr 12, 2013 4:50 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| If you didn't use the WTX node at all, and used a DatabaseRetrieve node, you could expect a much simpler solution. |
|
| Back to top |
|
|
| muks |
| Posted: Fri Apr 12, 2013 5:06 am Post subject: |
|
|
Newbie
Joined: 11 Apr 2013
Posts: 5
|
| I used the wtx node to convert the fetched results into the desired xml. And I have hands on experience on wtx. Bt the problem comes when we integrate it with wmb. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Apr 12, 2013 5:17 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| muks wrote: |
| I used the wtx node to convert the fetched results into the desired xml. And I have hands on experience on wtx. Bt the problem comes when we integrate it with wmb. |
That's because WMB is easier to use than WTX. WTX has trained you to think in really complicated metaphors that have very little relationship to modern concepts... "input card"? Really? there haven't been physical input cards for at least 30 years, much less output cards.
But you can't use WTX within WMB until you know how to use WMB....
If someone has said "Oh, you know how to use WTX, so you must be able to just do Broker", then someone has done you a misservice and you should correct their understanding.
As lancelotlinc has said, the documentation on the WTX node - in the WTX info center - tells you how to determine what message in Broker is assigned to which 'input card' of the map.
But again, if you just use Broker directly, it will be a much simpler solution and much easier to maintain and use over the lifetime.
And supported for longer.... |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Apr 12, 2013 5:28 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
| And supported for longer.... |
Spock: Mr. Scott, since the Enterprise is obviously functional, I suggest we return to our starting place at top warp speed.
Scotty: Aye, but it'll take a while.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| muks |
| Posted: Fri Apr 12, 2013 5:46 am Post subject: |
|
|
Newbie
Joined: 11 Apr 2013
Posts: 5
|
Thats not the case mqjeff. I have atleast a basic understanding of WMB for sure.Thats why i was able to create few flows with the wtx node in it earlier.
It seems u r much in love with wmb than wtx . If i go by ur suggestion, then the basic question arises "Why did the IBM guys introduced wtx node in wmb?" |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Apr 12, 2013 6:00 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| muks wrote: |
| Thats not the case mqjeff. I have atleast a basic understanding of WMB for sure.Thats why i was able to create few flows with the wtx node in it earlier. It seems u r much in love with wmb than wtx . If i go by ur suggestion, then the basic question arises "Why did the IBM guys introduced wtx node in wmb?" |
Because IBM has long standing (read sixty year old) customer relationships that had millions of lines of code wrapped around WTX.
WTX, as much as we love it, is a legacy product and destined for the parking spot where all beloved legacy products go: Sterling or equivalent. WTX will still be used sixty years from today because once code is put in production by these long standing customers, its likely not to come out.
DFDL and WMB industry packs are the future.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Apr 12, 2013 7:08 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| muks wrote: |
| If i go by ur suggestion, then the basic question arises "Why did the IBM guys introduced wtx node in wmb?" |
Why not? Why would IBM introduce an artifical boundary between products. As has been said by everyone on this thread, and I echo the comments, it's possible to do what you want by embedding a WTX node in a WMB flow. It's not the simplest way of doing what you want, nor is it the cheapest way of doing what you want but if you have previous experience with WTX it may be the "best" way for you to do it and the documentation will guide you. Me, I'd do it directly in WMB & leave WTX well alone.
DFDL and the Industry Packs have indeed removed a lot of the use cases for WTX. Legacy product? Only when you can move a DFDL transformation out of WMB and into DataPower directly.
And yes, that's probably 2 years from now.....
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Apr 12, 2013 7:27 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Vitor wrote: |
| DFDL and the Industry Packs have indeed removed a lot of the use cases for WTX. Legacy product? Only when you can move a DFDL transformation out of WMB and into DataPower directly. |
Will the caped crusader and his junior sidekick escape the Joker's labrinth? Tune in next week at this same Bat time, same Bat channel to find out.
Impact is coming with many announcements. The future is here already for many features.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Apr 12, 2013 7:49 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| Impact is coming with many announcements. The future is here already for many features. |
True. I will be watching that space.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
