| Author |
Message
|
| voyager |
 Posted: Tue May 17, 2005 7:41 am Post subject: Updating multiple Destination Tables in ICS |
 |
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
All,
Thank you very much for sharing your wonderful responses for my previous posts.
I have a requirement to update two destination tables from one single source table using ICS Maps.
When the data from source BO comes, I will be calling a stored procedure to get some keys
and then I will be updating one of the two destination table.
Now, in order to update the second table, what is the method I should employ..
Do I have use submaps? If so, how do I use them?
I appreciate if you could share your valuable comments...
Thank you!
_________________
voyager |
|
| Back to top |
|
 |
| vennela |
| Posted: Tue May 17, 2005 9:44 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I have never done this but my thoughts on it.
One way to do that is using polymorphic maps.
The other way is to use a transactional collaboration and make two service calls, one for each DB update. |
|
| Back to top |
|
|
| Ratan |
| Posted: Tue May 17, 2005 10:06 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
I never did that, but I think all you need is your ASBO reflecting both those tables.
_________________
-Ratan |
|
| Back to top |
|
|
| voyager |
| Posted: Tue May 17, 2005 10:30 am Post subject: |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
Thank you Vennela,
Initially, I thought I could make use of Polymorphic maps. But I have been told by IBM that
I can use Ploymorphic Maps in case of single source business object to map to one of many
potential destination business objects. ie., I could update any one of the destination BO's based
on some condition. But, I wat to update both the destination BO's. And moreover, there is no
relationship between these two tables.
I am not really sure how to do this either with using ploymorphic maps or the other method of
using transcational collaborations.
If you have some samples or examples, that would help me a lot to proceed.
I appreciate if you could send some samples on Polymorphic maps.
Thank you Ratan,
Could you please let me know how do I construct ASBO reflecting two tables in that and
how do I map from source BO to destination BOs. Moreover, I will be calling stored procedures
to get keys to update the destination BOs. I appreciate, if you could elaborate little bit.
Thank you very much!
_________________
voyager |
|
| Back to top |
|
|
| vennela |
| Posted: Tue May 17, 2005 10:49 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Quote: |
| I never did that, but I think all you need is your ASBO reflecting both those tables. |
The condition for this I think is both the tables should be in the same Database. Isn't that correct? |
|
| Back to top |
|
|
| voyager |
| Posted: Tue May 17, 2005 10:53 am Post subject: |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
Yes, in fact both the tables are in the same database.
But, unfortunately there is no connection between these two tables.
I just get the keys by executong some stored procedures and then update in both the tables.
Any ideas/leads geratly appreciated.
Thank you!
_________________
voyager |
|
| Back to top |
|
|
| Ratan |
| Posted: Tue May 17, 2005 11:40 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
| Quote: |
| The condition for this I think is both the tables should be in the same Database. Isn't that correct? |
The database connection is at the connector level, so they have to be in the same database.
I was thinking having a child business object (table 2) in the main BO (table1) can solve this. I have not done it, so this is just a thought.
_________________
-Ratan |
|
| Back to top |
|
|
| voyager |
| Posted: Tue May 17, 2005 12:43 pm Post subject: |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
Thank you Ratan,
I will keep trying and keep you all posted just in case.
Thank you for your comments
_________________
voyager |
|
| Back to top |
|
|
|
|
