| Author |
Message
|
| new_to_wmb8 |
 Posted: Fri Jul 05, 2013 3:39 am Post subject: Database Mapping |
 |
|
Centurion
Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India
|
Hi All,
i need some help to starting creating my message flow as per my requirement.
the flow is data from SAP goes to End Point application database(SQL Server 2008). from SAP the messages are coming and i have map those values with the Database tables,
example : field 1, field 2, field 3 needs to be mapped to Single field of Address at database. the values must be concat and updated in Database.
i am working on Broker V8. In MB v8 databse update node is removed, so i have to use mappping node right ?
my flow wud be like
SAPInput Node--->Mapping Node
using grapical map i have to update the database, for using graphical map i have create the database defination  |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Fri Jul 05, 2013 3:40 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| new_to_wmb8 |
| Posted: Fri Jul 05, 2013 3:42 am Post subject: |
|
|
Centurion
Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India
|
| with database node...how can i do mapping of Input values to Database values |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Jul 05, 2013 4:03 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| new_to_wmb8 |
| Posted: Fri Jul 05, 2013 4:12 am Post subject: |
|
|
Centurion
Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India
|
thanks for the links and code snippet, i wil try  |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Jul 05, 2013 4:15 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| new_to_wmb8 wrote: |
| thanks for the links and code snippet, i wil try |
You're welcome. But just don't blindly copy & paste because that won't do what you want. You need to think, and apply knowledge, and become skilled in writing WMB functionality. The required training takes nine days.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| new_to_wmb8 |
| Posted: Fri Jul 05, 2013 4:28 am Post subject: |
|
|
Centurion
Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India
|
yes i know i have to think on this, 1st SAP connectivity then SQL sever database connection, code ect. that training is not available in India 
and its costly too  |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Jul 05, 2013 4:45 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
|
|
