Friday, July 6, 2018



What is BizTalk ?

BizTalk is a  message based integration tool. It is used to integrate  many  applications which   can be written  in any  language.

BizTalk supports  two  types   of environment –
1- EAI – EAI stands   for “Enterprise Application Integration” . It is used to integrate applications within an Organisation.
2- B2B – B2B stand for “Business to Business Integration“. It is used to integrate applications across the organisation.




Advantages of BizTalk Technology?

BizTalk enables companies to integrate and manage business process by exchanging
business documents between business applications within or across the organisation
boundaries.

What is Pipeline ? Types of BizTalk Default Pipeline ?

Pipeline – Pipeline provides the ability to perform data processing and validation operation on incoming  and outgoing messages.

There are 4 types of default pipelines available in BizTalk –
1- Pass Thru Receive.
2- Pass Thru Transmit.
3- Xml Receive.
4- Xml Transmit.

Pipeline Stages

Receive Pipeline Stages –
  • Decode
  • Disassembler
  • Validate
  • Resolve Party


Send Pipeline Stages –
  • PreAssemble
  • Assembler
  • Encode



Difference between Promoted Properties and Distinguish Field


The primary difference between promoted properties and Distinguish field is that promoted properties can be used for routing, correlation, Tracking message and also access these properties inside the orchestration and other artifacts but distinguish field accessed only inside the orchestration. Other difference is Distinguish filed has no character limit but promoted data is limited to 255 characters.

So, the rule here is, if you don’t want the schema element to  appear in send  port filters/ debugging information then  make it as Distinguish  filed.


What is XPath ? Describe benefit of it ?

XPath is  a navigation language for finding information held  in   an  xml document.

Benefits –
XPath is  used   by  BizTalk Orchestration to retrieve interesting piece of data from a message, which  can then be used  to route the message or perform a conditional business  logic.

Update Gram Vs. Stored Procedure

Update Gram  used with the Classic  SQL Adapter enable  you to run SQL Update/ Insert/ Delete operations.
The basic  difference between Update Gram and Stored  Procedure is that the Update Gram only has the Success element is the response Schema but if the business process require multiple operation across  database tables, It is best to encapsulates these in Stored Procedure instead of Update Gram.

What is Message Type? How it is used in BizTalk ?

Message Type is a Context property which   is write  by receive adapter and receive pipeline. You can access this property  inside the orchestration through BTS. MessageType.
In Other words, Message Type  is   a Biztalk System  Property that is promoted  inside by a pipeline and  adapter. It is made  up of Document Namespace and Root Node Name.
Namespace#RootNodeName.
If schema does not contain   any  namespace then Message Type  should  be #RootNodeName.


What is BizTalk ?

BizTalk is a  message based integration tool. It is used to integrate  many  applications which   can be written  in any  language.
BizTalk supports  two  types   of environment –
1- EAI – EAI stands   for “Enterprise Application Integration” . It is used to integrate applications within an Organisation.
2- B2B – B2B stand for “Business to Business Integration“. It is used to integrate applications across the organisation.

Can we use custom xslt in BizTalk map?

Yes ,  There are two options   available for that –
  1. You can  choose  scripting functoids.
  2. Custom XSLT path of  map grid   property.

What is the use of Correlation?

You  need  to send a message  out of an orchestration and receive response back into the same orchestration instance.
Part of Correlation process-
Correlation Type
Correlation Set

You  can  use a correlation set to tell an   orchestration to accept only message that have the same information as a message sent by the orchestration.

What is EDI?

EDI stands for “Electronic  Data Interchange“.
  • Electronic File Change
  • Standard Format
  • Automated, no human intermediaries.
So, In other words, EDI is an electronic   communication medium that is used to exchange documents between  different Trading  Partners.
For a conversation to be effective, both parties must speak the same language.
The same is true for the use of EDI. In order for computer-to-computer
communication to be successful, both of the computers involved must be able to
read and understand data the same way.
■ Note To access the EDI schemas with BizTalk, browse to the Microsoft
BizTalk Server  root folder and go to XSD_Schema\EDI. In this directory
you will find a file called MicrosoftEdiXSDTemplates.exe. Running this
file will extract all available schemas.

EDI Process flow.png

Difference between XSDL and DTD ?

XSDL stands for Extensible Schema Definition Language.  Schema  define the structure and content of the message that you will be processing. Schema   can   be used  to validate that incoming message are properly formatted or not.

DTD stands for Document Type Definition.
In a DTD,
(i) sets of elements and their attributes are defined;
(ii) the names that are used as tags are assigned; and
(iii) the element relationships or transaction is defined.
If a DTD is used then programs can validate the transaction’s structure. The best known example of a DTD is HTML, which is defined by a SGML-DTD describing the structure of HTML documents.

What is Property Schema?

The property schema is used to define the message Context properties.
These can be type of MessageDataPropertyBase & MessageContextPropertyBase.
MessageDataPropertyBase property value can be used inside the orchestration.
MessageContextPropertyBase property value only exist within the message context and can be set by adapters, pipeline or within orchestration.