This blog is to explain about BizTalk Correlations. What is Correlation? Correlations can be defined as binding incoming messages with the appropriate instance of an orchestration. Sample Scenario for Correlations: My Orchestration has to send a request message to a Message Queue, let’s say it is “Input Queue”. Some other process takes the input message … Continue reading BizTalk Correlations
XSL, XSLT AND BizTalk Map – First Look
What is XSL and XSLT? There is no difference between XSL and XSLT both are same and these also called XSL stylesheets. I can say these are synonyms. It is a one type of Language in computer world which contains different Types of Languages. And this type of language is also called stylesheet language or … Continue reading XSL, XSLT AND BizTalk Map – First Look
BizTalk Logical Ports & Port Bindings
This blog is to explain various ports and port Bindings in Orchestration. There are two types of ports in BizTalk. Logical Ports: Ports which are used in OrchestrationPhysical Ports: Ports which are used in BizTalk admin console Each logical port (Except Direct Binding) should have binding with a physical port in BizTalk admin console Since … Continue reading BizTalk Logical Ports & Port Bindings
Create First BizTalk Orchestration
Requirement: I need to drop a sample Xml message in a folder location. Sample Input Xml message: <ns0:AppraisalInput xmlns:ns0="http://SampleBTApp.AppraisalInputSchema"> <EmpNo>EmpNo_0</EmpNo> <EmpName>EmpName_0</EmpName> <AppraisalScore>4</AppraisalScore> </ns0:AppraisalInput> My BizTalk orchestration should receive the message and do below validations If Appraisal Score = 5, then Assign Grade = ‘A’ If Appraisal Score = 4, then Assign … Continue reading Create First BizTalk Orchestration
BizTalk Custom Pipeline to Convert Excel file to Flat file
This blog explains how to convert .xlsx to Flat file in BizTalk using Custom Pipeline. Below pipeline component is generic one which can be applied to any excel files for FlatFile conversion. Sample Input (Excel File): Sample Output (Flat File): Please follow below steps. Take a class library project and keep code which is present … Continue reading BizTalk Custom Pipeline to Convert Excel file to Flat file
Using Dictionary for BizTalk Instances
Sometimes in BizTalk, we may need to use Dictionary for checking various conditions for multiple messages/Records of the same BizTalk Instance. This can be achieved using Dictionary ThreadStaticAttribute. Requirement: My BizTalk Orchestration accepts envelop message (Multiple records), I need to loop through each record and insert the data in sql table. Here the condition is … Continue reading Using Dictionary for BizTalk Instances
