BizTalk 2010

Insert with WCF-SQL-Adapter BizTalk 2010

by Ali Raza Zaidi on March 25, 2012

 

I decided to write a simple kick start tutorial for WCF-SQL Adapter for beginners.

In this tutorial where I just perform single operation insert. A simple BizTalk solution which read a value from file location and insert this value into table.

First of all I create a very simple category table. Which hold two fields. As

 

USE [Experiments]

GO

 

/****** Object:  Table [dbo].[CategoryWar]    Script Date: 03/25/2012 22:12:13 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE TABLE [dbo].[CategoryWar](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CategoryName] [nvarchar](255) NOT NULL,

CONSTRAINT [PK_CategoryWar] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

 

GO

 

 

Now I create a new solution with Name WCF_SQLAdapter. You can use as you like.

 

On solution explore, I right click  on add and then  select generate items.

 

Then select consumerAdapterServices  as follow.

 

 

 

 

Select SQLBinding from Consume Adapter Services Wizard. Like  as

 

Then click on Configure Button new popup windows  like that

 

 

Inter the Sql server Name. And Database Name in Initial Catalog. And press save button. Now URI look like as

 

Click on test button to verify the connection established. If connection is successful. Then Category section will below the connected button will populate as select from table all possible option appears at right side as follow.

 

 

Some Schemas and bind files generated as follow. Open schema name with

TableOperation.dbo.CategoryWar.xsd

 

 

Now we create one more schema, which will used as input to BizTalk solution. Like as

 

 

Now I create a map for send value from input schema to Request input message.

 

I used source input schema. And output schema I used to  insert schema from TableOperation.dbo.CategoryWar.xsd. Map will be like

 

After that I create new Orchestration with name InputProcessOrchestation.odx.

I create three message with One for input message, and two with Insert Request Method and one for Insert response.  Orchestation will be look like as

 

 

 

It is very simple orchestration, which reading input from file location transform it into request message. And request response call to WCF-SQL adapter and received message drop in other location.

For wcf-sql call I created send request port with specify later option. Remember the name of operation will be the same which will describe in binding. You can later change it. When I deploy the solution I found three ports on BizTalk console. I created two file ports one for receiving input and second for droping output. I import the binding which is created at the time of consuming the SQL Adpater. It will as


Generate instance form input schema and modify it and drop. This solution is works fine for me.  You can download solution from here.

 

 

 

 

 

{ Comments on this entry are closed }

XSLT In BizTalk Maps

by Ali Raza Zaidi on March 22, 2012

XSLT is by default used by BizTalk maps (XSLT engine) to transform source schema to destination schema so there is nothing new (If you just open the .cs file of a map you can see it clearly there) Intention of this post is to highlight different usages of custom XSLT.

1) WHEN to use XSLT ?
I would prefer to use XSLT in following scenarios,
Whenever you have implement a complex logic in map. Like Grouping, Sorting or joining multiple input messages or carrying out operations with those multiple messages etc.

2) WHY XSLT and not Functoids ?
I totally understand that these things can be done using functoids as well. But as per my expereince if you open a map which uses a lot of functoids and try to analyse the .cs file of a map you will realise that,
i) There are a lot of simplifications can be done in that code like inline xslt functions can be used but instead functoids create .net functions for them.
ii) Also lot of unnecessary variables are created in XSLT which is by default generated by functoids.
iii) If you can write a good xslt you can write much more optimized.(Learning XSLT is pretty simple I would say.) Which in turn positively going to impact on your map execution performance.
iv) Debugging XSLT independantly is very easy infact the Map debugging feature introduced in BizTalk intern uses the same XSLT debug functionality (remember the XSLT debug window which is opened at time of debugging a Map). You can keep you xslt seperate (custom xslt) and test it with your sample input messages independantly.

3) What is Extension XML ? When to use it ?
When you need to call external assembly you will need the reference to extension xml. Link below will explain the details of extension xml.
http://msdn.microsoft.com/en-us/library/aa547368.aspx.

4) XSLT Grouping ,Sorting samples.
Some typical samples of xslt grouping,
e.g. Input message is

This needs to be Grouped and Sorted we can use an XSLT as below,

and the Output will be

5) Different XSL Functions :-
Below link gives description of some of the XSLT 1.0 functions,
http://www.zvon.org/xxl/XSLTreference/Output/xpathFunctionIndex.html

Imp Note:- As of now Microsoft only supports XSL 1.0, XSL 2.0 is much more powerful and contains a lot of functions compared to 1.0. My Wishlist would include support for XSL 2.0 from Microsoft in future versions of XSLT engine.

{ Comments on this entry are closed }

Xpath vs Distinguished fields.

by Ali Raza Zaidi on March 12, 2012

Xpath consider to be slower, because when we get value using xpath, the whole message will be loaded into memory, so Xpath is memory hungry  solution Distinguished filed return value faster then xpath. Distinguished filed  has limitation. It failed to returning value when message contains multiple node contains the value. In this case Xpath works wonder.
Final point is depending on need, either to use Distinguished filed or Xpath. Distinguished fields internally contain Xpath.

{ Comments on this entry are closed }

All you need to know about the WCF-SQL Adapter

by Ali Raza Zaidi on January 10, 2012

Currently I am studying the WCF-SQL Adapter. I found very informative webcast by “Thiago Almeida” about WCF-SQL adapter. This webcast belongs to BizTalk 2009, but for beginners it’s still good starting point. I don’t think things will not much different in BizTalk 2010 at least not at beginner level.

 

http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521554268962766719

 

{ Comments on this entry are closed }

BizTalk Server Pipeline Component Wizard

by Ali Raza Zaidi on December 13, 2011

If you need to design BizTalk Pipeline custom component, Use the BizTalk Pipeline Component Wizard on codeplex
(http://btsplcw.codeplex.com), It is my favorite way to create pipeline components.
It is an easy-to-use tool that walks you through the pipeline component creation
process via a friendly wizard.

http://btsplcw.codeplex.com/

{ Comments on this entry are closed }

BizTalk Server 2010 R2 Announced

by Ali Raza Zaidi on December 11, 2011

A few days ago , Microsoft announced the forthcoming release of BizTalk Server 2010 R2 on the BizTalk Server blog site.  This is advanced notice, given that this new version will ship six months after the release of Windows 8, expected in the second half of next year.  On this basis, we can expect the new version of BizTalk Server to arrive in 2013.  Given the BizTalk team’s previous record of name changes, I wonder if this will eventually be released as BizTalk Server 2013.

 

More Infor read this http://blogs.msdn.com/b/biztalk_server_team_blog/archive/2011/12/08/biztalk-server-2010-r2.aspx

{ Comments on this entry are closed }

BAM Data read write from Dot net application

by Ali Raza Zaidi on September 20, 2011

You know that BAM is used to gather statistics from your BizTalk application. What you probably don’t know is that:

·          You can collect BAM data from your non-BizTalk applications such as external .NET components that BizTalk calls into.

·          Tracking profile editor (TPE) is not the only way to collect data you can use a set of APIs available in the Microsoft.BizTalk.Bam.EventObservation namespace to read and write directly into the BAMPrimaryImport database.

Check out some of the links here:

·          http://www.topxml.com/rbnews/BizTalk-BAM-activity/re-29195_Business-Activity-Monitoring–GenerateTypedBAMAPI-Tool.aspx

·          http://www.developer.com/net/net/article.php/11087_3587296_2

·          http://blogs.msdn.com/keithlim/archive/2006/02/02/522649.aspx

·          http://blogs.msdn.com/keithlim/archive/2006/03/08/545851.aspx   r

 

 

 

 

 

Original Article : http://geekswithblogs.net/benny/archive/2007/06/14/113219.aspx
 

 

{ Comments on this entry are closed }

How BizTalk Server 2010 Works

by Ali Raza Zaidi on September 13, 2011

I found a very beatiful article on msnd about how Biztalk 2010 works. here some extraction complete artilce you can read from here
http://www.microsoft.com/biztalk/en/us/messaging.aspx

At the core of BizTalk Server are the Messaging Engine and the Orchestration Engine, which provide the underlying architecture for integrating and exchanging messages between various services, both within and outside your organization.

The BizTalk Messaging Engine:

Receives inbound messages.
Parses inbound messages to identify their specific formats.
Evaluates message content to identify how the message is to be routed and processed.
Delivers messages to their respective destinations.
Tracks the status and state of documents.
The BizTalk Orchestration Engine, in contrast, coordinates and schedules message processing and performs complex logic on the message as it is passed through a defined workflow.

For Complete article is here  http://www.microsoft.com/biztalk/en/us/messaging.aspx

{ Comments on this entry are closed }

What is BizTalk message Type ?

by Ali Raza Zaidi on September 12, 2011

All messages in BizTalk are represents in XML. One important aspect of all XML documents is its namespace. Briefly, a namespace allows you describe the Student (for example) in one way without affecting anyone else’s description, possible student can mean different things to other applications, Second important aspect of all XML document is the name of document root node.

For example namespace of student XML is

urn:schemas-BiztalkHQ-net:Student:mapcontext:1

and Root Node of Schema is

Student .

The combination of message namespace and name of root node are represented as:

 

urn:schemas-citrite-net:licensing:mapcontext:1#Student

The hash symbol (#) separates the namespace from the name of the root node.

{ Comments on this entry are closed }

Microsoft BizTalk Server 2010 Unleashed

by Ali Raza Zaidi on August 22, 2011

Microsoft BizTalk Server 2010 Unleashed is the definitive, pragmatic guide to Microsoft’s latest and most powerful version of BizTalk Server. In this book, a team of world-class BizTalk Server 2009 experts bring together the deep practical insights .NET developers need to solve real business problems with BizTalk Server 2009 in any enterprise environment. Drawing on their immense BizTalk experience, the authors present best practices for the entire development lifecycle, from planning and architecture through deployment, and beyond. Writing at just the right level of technical detail for experienced .NET developers now starting out with BizTalk, they cover these and many other crucial issues: ” Architecting and designing effective, high-value BizTalk solutions ” Working with BizTalk schemas, maps, orchestrations, pipelines, pipeline components, and adapters ” Implementing business rules with the Microsoft Business Rules Framework ” Creating highly-available, high-performance BizTalk environments ” Monitoring business activity ” Collaborating effectively among BizTalk developers and users ” Using BizTalk’s leading-edge RFID capabilities Note: This is a 100% new book, NOT an update to Microsoft BizTalk Server 2004 Unleashed.

http://www.amazon.co.uk/BizTalk-Server-Unleashed-Brian-Loesgen/dp/0672331187/ref=sr_1_2?ie=UTF8&qid=1303139672&sr=8-2

{ Comments on this entry are closed }

← Previous Entries