Forum Replies Created
-
AuthorPosts
-
Hi Abhishek,
You will have to implement content-based routing by creating a custom pipeline component and using it in the receive location where the SAP-generated reports are received. Check out the following BizTalkGurus blog on how to implement such a pattern:
Please note that the blog describes a messaging only scenario that calls a web service, but you can reuse the information on creating the custom pipeline component and the general idea remains the same.
Daniel.
Hi Daniel.
Ah ok … I understand now. I was looking on the wrong place.
Thanks a lot.
Wolfgang
July 20, 2010 at 11:49 PM in reply to: Switch Biztalk 2006 backend from SQL Server 2005 to 2008 #25311We’ve run BizTalk 2006 on a SQL 2008 server before with a previous client of mine successfully. However, we weren’t clustered on the SQL side, so it may not be a straight-up comparison.
July 20, 2010 at 9:11 PM in reply to: Consume Web service in BizTalk 2009 that uses WS-Security and SAML tokens #25310Hi,
Check the following MSDN forum thread to see if any of the information contained there might help you answer your questions:
Daniel.
July 20, 2010 at 5:40 PM in reply to: Need for a good corporate training center for Biztalk 2009 in Bangalore #25308Hi Manik,
QuickLearn offers BizTalk Server 2009 training(and very soon 2010!). You can see offerings at http://www.QuickLearn.com/Biztalk-Training
QuickLearn offers everything from intro training for developers and admins to advanced training for expert developers. QuickLearn has an excellent reputation and is endorsed by the BizTalk Product Team.
Hope this helps!
– Monique
July 20, 2010 at 2:39 PM in reply to: Consuming WCF service in Orchestration – action is invalid or unrecognized #25306Or, instead – you just can import binding file to your application and it creates all stuff you need (transport type, actions, definitions automatically)
July 20, 2010 at 2:35 PM in reply to: Consuming WCF service in Orchestration – action is invalid or unrecognized #25305Yep, that did the trick. Thanks much. tmc-
July 20, 2010 at 12:53 PM in reply to: Breakpoints aren’t hit when attaching custom pipeline component to Btsntsvc.exe #25303when i am attaching process BTSntsvc.exe in visual studio 2008. i am doing following thing before it.
a) Building teh component in debug mode. b)pipeline in debug mode. C) building the solution…keeping output path as C:/programfiles/microsoftbiztalk server 2009/pipelinecomponents/ d) placing the dll in gacutil. e) deploying the solution.. I have given break point in pipeline component. but its not stooping, when i am placing xml file to receive location…..I tried every possibility which i got from forum but still its not woking. Could any one sujjest me any solution…
Thanks in advance.
Ashwani Kumar
Hi,
I fail to understand why you don’t validate your map with input files. You can use the XML file from the orchestration to test your map and adjust it to account for the bad data. It does not matter if you use your maps in an orchestration dynamically or not, you should always test and validate your maps.
check your TNSNAMES.ORA file
When I test a map separately setting validate input/output to false – it’s working. But in orchestration where I have dynamic map it fails. I have a bad data in xml file, but I want to handle it my own way.
Hi Wolfgang,
See my response below…
[quote user="wal"]
I have a request schema with one element for the parameter from the txt-file (disassembled in the receive pipeline). And one more schema for the response from the SQL Adapter do I need one more schema?
And one more “mysterious” thing is, I can’t make the fields/elements to distinguished fields. As far as I know there should be in the element/field properties an distinguished area where I can handle this. Am I wrong?

[/quote]
When you generated your SQL Adapter schema from the wizard, you should have a Request-type node and a Response-type node under your top-level node in the schema, so you should make that field located under your Request-type node to be a Distinguished field (which will map to the parameter in your Stored Procedure).
Remember that you can only make a field to be a Distinguished Field if its parent record (or the field itself) is non reoccurring, which means that only one instance of that record (or field) is expected, so check the Max Occurs property of the parent record (or field) and make sure that it is either blank or set to 1. Once this is set, you right-click on the field node and choose the option “Promote” and underneath that, choose the sub-option “Show Promotions…”, which will bring up the Promote Properties window, then make sure the Distinguished Fields tab is active (on the right-hand side), and highlight the field node that you want to be Distinguished (on the left-hand side) and click on the “Add >>” button in the middle and click the Ok button to save the changes.
Hope this helps,
Daniel.
Hello Daniel.
Yes, sounds very good.
I have a request schema with one element for the parameter from the txt-file (disassembled in the receive pipeline). And one more schema for the response from the SQL Adapter do I need one more schema?
And one more “mysterious” thing is, I can’t make the fields/elements to distinguished fields. As far as I know there should be in the element/field properties an distinguished area where I can handle this. Am I wrong? [*-)]
But I like your way … I will try this out.
Thank you very much.
Wolfgang
Hi Wolfgang,
I would recommend not using the map, if you are just mapping that one parameter from the flat file schema to your SQL adapter request schema.
Basically, you can make both fields as distinguished fields, in both flat file and SQL adapter request schemas, and assign one to another in a Message Assignment shape with the following line of code (beforehand, you would declare two orchestration-level messages with their types respectively from the Flat File schema and the SQL Adapter request schema):
SQLAdapterSchemaMessage.Record.DistinguishedField = FFSchemaMessage.Record.DistinguishedField;
Then, in the same flow of your orchestration, you would have a logical Send shape and a logical Receive shape linked to a logical two-way Port that represents the call to your SQL adapter (which you would configure in the Administration console).
Does this scenario make sense to you?
Daniel.
Hi,
I don’t understand your post. Can you re-phrase your question so that I and/or others on this forum can better answer it?
-
AuthorPosts