| Author |
Message
|
| Nishant |
 Posted: Fri Feb 28, 2014 2:41 am Post subject: database update using mapping node in message broker |
 |
|
Newbie
Joined: 28 Feb 2014
Posts: 3
|
Hi
I m new to message broker and i am trying to update database using mapping node in message broker v8 but but in graphical data map there is only one option 'select from database' how to get other option like insert delete or update. pls help |
|
| Back to top |
|
 |
| Gralgrathor |
| Posted: Fri Feb 28, 2014 2:53 am Post subject: Re: database update using mapping node in message broker |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
| Nishant wrote: |
| trying to update database using mapping node |
Why would you want to *update* a database from *within* a mapping node? What might you achieve by such a thing that could not be more elegantly achieved by first mapping and then updating to a database in a subsequent node?
_________________
A measure of wheat for a penny, and three measures of barley for a penny; and see thou hurt not the oil and the wine. |
|
| Back to top |
|
|
| Nishant |
| Posted: Fri Feb 28, 2014 2:58 am Post subject: |
|
|
Newbie
Joined: 28 Feb 2014
Posts: 3
|
| yes you are right but i was going through infocenter and they have these option in mapping node but i could not locate. |
|
| Back to top |
|
|
| Gralgrathor |
| Posted: Fri Feb 28, 2014 3:16 am Post subject: |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
| Nishant wrote: |
| they have these option in mapping node |
Right. One can write the results of a mapping to a database by choosing the target from a Data Target, I forgot. Is this what you meant?
_________________
A measure of wheat for a penny, and three measures of barley for a penny; and see thou hurt not the oil and the wine.
Last edited by Gralgrathor on Fri Feb 28, 2014 4:22 am; edited 1 time in total |
|
| Back to top |
|
|
| praj1740 |
| Posted: Fri Feb 28, 2014 4:00 am Post subject: |
|
|
Apprentice
Joined: 05 Feb 2013
Posts: 29
Location: INDIA
|
| Hi,Be sure that you are able to see the target side in the message map pane.since you can do the select in the source side of a message map.In the target side you will find data targets where you will find a option to update a existing table.IF you are still unable to see try creating a database definition. |
|
| Back to top |
|
|
| Nishant |
| Posted: Fri Feb 28, 2014 4:25 am Post subject: |
|
|
Newbie
Joined: 28 Feb 2014
Posts: 3
|
|
| Back to top |
|
|
| Gralgrathor |
| Posted: Fri Feb 28, 2014 4:41 am Post subject: |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
Well, not exactly. But as @praj1740 noted: updating to a database requires you select a database *target*. Source only offers select.
_________________
A measure of wheat for a penny, and three measures of barley for a penny; and see thou hurt not the oil and the wine. |
|
| Back to top |
|
|
| martinb |
| Posted: Fri Feb 28, 2014 11:49 pm Post subject: |
|
|
Master
Joined: 09 Nov 2006
Posts: 210
Location: UK
|
|
| Back to top |
|
|
|
|
