- This topic has 4 replies, 1 voice, and was last updated 8 years, 4 months ago by
.
-
Posts
-
-
Hello Biztalkers,
in our company we have one big ERP-System, which has to send small CSV files to about 140 shops which are located somewhare over europe. They are connected via VPN to our BizTalk 2006 Server. The BizTalk gets the data out of ERP, transforms it and then it should send it to all shops. Is there a problem that BizTalk will have to do a lot of sending (the ports (=shops) must be configured dynamically via a mapping table or something). I heard, that the BizTalk Server creates loads of messages while transforming/sending, which costs CPU-Load??
Example for the Mapping Table:
ShopNumber | UNC-PathThe shopnumber and the data to send comes out of the ERP system, the only thing needed is the UNC-Path within the VPN to send the transformed CSV File to.
Are there any better ways to fulfil this process?
-
THe most important thing is, that the UNC-Shares of our shops have to be easily configured! If a new shop is added in the ERP System and mapping table, there should be no need to change orchestration or something else…
-
Another thing is, which i am not sure of:
When using a dynamic port in this example i described above, will the BTS Server create a XML Message for each outbound file which is going to be sent to each shop? Or is it just ONE XML Message, which put through the pipeline and then the pipeline duplicates it to all shops?
Thanks a lot!!!!
-
[quote user="Anonymous"]
Another thing is, which i am not sure of:
When using a dynamic port in this example i described above, will the BTS Server create a XML Message for each outbound file which is going to be sent to each shop? Or is it just ONE XML Message, which put through the pipeline and then the pipeline duplicates it to all shops?
Thanks a lot!!!!
[/quote]
"The BizTalk gets the data out of ERP, transforms it and then it should send it to all shops. " – you haven;t given enough detail here to tell how this is going to work or meet your stated requirements. We would expect that the extract from the backend gets broken up into each individual message instance that goes to a partner.
Based on your description I don't think you will have volume concerns that you were afraid of.
I don't know how to do the delivery; maybe a different send port for each UNC?
I think you can add new ones from the BizTalk console without compiling and deployment as you add configurations. This is not auto-configuration, maybe you can script the thing from the ERP table, you might add a trigger on there to initiate the thing. But still, having an operator manually configure and watch this is not unusual.
– wa
-
-
[quote user="Anonymous"]THe most important thing is, that the UNC-Shares of our shops have to be easily configured! If a new shop is added in the ERP System and mapping table, there should be no need to change orchestration or something else…[/quote]
In this case, you could do something like what this link shows: http://geekswithblogs.net/edmundzhao/archive/2006/03/06/71555.aspx
1.To do this, just find all the unc paths that you need, loop through each one and put that into the destination part of the message. Send the message and go onto the next. In this instance, you would have a message from each unc path.
2. Another option would be to send through a send port group and then you can add or remove send ports from that group at any time and it doesn't change the orchestration. This is probably the most common way to do this since you won't need to do anything really dynamic and will save on the number of messages sent through your biztalk system.
I'm sure there are other ways but these are just a few that I thought of right now.
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.