[community-content]

I got lost a little bit on what you were saying.

Do you not have any access to the parameters on the message?

It might be because the field you want is not a distinguished field inside your schema?

[community-content]

Here is a general idea of what you need to do:
1. Create a Receive Port and Location to pick up the file via FTP
2. Create a Send Port with a Filer on the Receive Port Name to send the file to a local private MSMQ on the other server
3. Crease a Receive Port and Location on the 2nd Server to pick up the file off the queue

I would use MSMQ rather then MSMQt – basically because it is just easier to work with.

Hope this helps.

[community-content]

You might want to be careful here, there are many ways to integrate two databases and Biztalk might not be the best way.

Biztalk can not directly react to triggers.

You could have your trigger gather up the required data and send it to Biztalk via a queue. Or write the data to a SQL table and use the SQL adapter to extract out the data.

Hope this helps.

[community-content]

Probably should also not that you can not access the message context inside your map.

I’m not a big fan on Receive Port mapping in BizTalk 2004 due to the complexity in error handling.

[community-content]

Sure, you could do that if you wanted using an Oracle Adapter for Biztalk. Might be a little overkill for your purpose though.

I’d just make a simple function call. But either way should work.

[community-content]

Let me see if I have this right, you have multiple Receive Shapes that you want to route your message to?

If that is the case, you can not really do that. You can only have one Active Receive per Orchestration unless you have a Convoy – and I don’t think that fits here.

Maybe a better approach would be to receive all the different messages in through a single Receive Shape and then use a decision shape to get into the right branch.

Or, you can create separate Orchestration and route the message to the one.

Would this work for you?

[community-content]

Thanks for the feedback.

The next sample I’m working on is a direct binding sample. I hope to have it posted in a week or so.

Make sure you use the subscription viewer to help you resolve any issues. With direct biding, something the message namespace can get in the way.

Best of luck.

[community-content]

Hi,

How did you manage to write the soap headers ???

Can you send me sample code ???

My mail id is [email protected].

Thanks

[community-content]

Hi Stephen,

Thanks for the advice but can you bit elaborate how to add context properties in orchestration as i am relatively new to biztalk as am not sure where to find .

Thanks,

Shaik Nagul

[community-content]

Hi Mr. Stephen W. Thomas,

Would it be possible to send a request to the oracle Database, from the Orchestration, and to receive the value of a variable, that I woud put in a message that I would use in the \”if condition\” of the \”Decide\” form ????
And then I could do what I want … No ???

Isn’it easier ??
What do you think ???

thank you – A.C.

[community-content]

I have found my own answer thanks to the awsome work of [url=http://msdn.microsoft.com/msdnmag/find/?type=Au&phrase=Aaron%20Skonnard&words=exact]Aaron Skonnard[/url]

Aaron has produced [url=http://msdn.microsoft.com/msdnmag/issues/05/11/ServiceStation]An XML Guru’s Guide to BizTalk Part 1[/url] and [url=http://msdn.microsoft.com/msdnmag/issues/05/12/ServiceStation]An XML Guru’s Guide to BizTalk Part 2[/url]

Anyway, the answer is the pipeline completes its processing and then applies the map. Once the map has been applied, it is sent to the MessageBox awaiting subscribers to the mapped message.

Hope this is clear, if not be sure you read Aaron’s work (read it anyway, it’s worth it!)

Thanks

Scott

[community-content]

You could do inside the mapper if you wanted.

The key is to write a little .net component to do exactly what you want. Might take in an input (such as database name) and return a boolean. I’d put all the configuration stuff either hardcoded for now or inside a config file.

It’s easy to test out using a Windows Form.

Then, you just have to GAC it and you can then call it using a Scripting Functoid or call is inside an Orchestration.

I’d just look at MSDN for a sample of the code using the OracleClient.

Hope this helps.

[community-content]

I think those are context properties. SOAP.Username and SOAP.Password. Or something like that. I think that is all you need to set.

You can do this easily inside an Orchestration otherwise I think you would need a custom pipeline component.

[community-content]

No Stephen. I am not using BizTalk mapper per se… Instead, an expression that calls .Net component to do this…

(Within a BizTalk mapping screen, there is an option to select the encoding, that I am aware of… thanks)

Thanks…

[community-content]

Thanks to all of you for helping me out but now i am struck with another problem,

I am using WSE adapter to consume the web service but again like i am struck with how will i be able to create soap header as the webservice need username and password in the soap header.

Thanks again.

[Author]

Posts