Biztalk Blog

DMZ & non-DMZ Configuration

2010-12-30T18:54:00.000-08:00

Some companies may not wish to keep biztalk and sql server in DMZ. But they use a lot of http/s,soap adapters to receive the inbound messages. To implement this environment, We need to configure as follows

a seperate webserver -> DMZ
biztalk server -> non-DMZ
SQL server ->non-DMZ
use WCF or reverse proxy

BOM Remover for passthrough receive pipeline

2010-04-20T02:10:00.000-07:00

If text file has utf-8 signature (BOM), we want to remove that without using disassambler, I used the following code
byte[] buffer = new byte[streamLength];//new byte[originalStrm.Length];

originalStrm.Read(buffer, 0, Convert.ToInt32(streamLength));

byte[] preamble = Encoding.UTF8.GetPreamble();

//239 187 191

if (preamble[0] == buffer[0] && preamble[1] == buffer[1] && preamble[2] == buffer[2])
{
System.Diagnostics.Trace.WriteLine(" file has utf-8 signature and removed ");

byte[] bufferN = new byte[streamLength-3];//new
Buffer.BlockCopy(buffer, 3, buffer, 0, streamLength - 3);
buffer = bufferN;
}
else
System.Diagnostics.Trace.WriteLine(" file does not have utf-8 signature");

Biztalk consulting & training

2009-09-30T23:56:00.000-07:00

I am doing the following services

1.Biztalk consulting (soltution, architect,implementation for enterprise)
2.Biztalk training for indivual as well as corparate
3.Freelance work

Updating multiple tables from BizTalk and validating the incoming message in SP

2009-03-04T06:18:00.000-08:00

Sometimes, we may have the requirements to insert/update more than one table in SQL server from BizTalk using SQL Adapter as well as we have to validate the passing parameter - message in SP before updating database. This will help us to check the data type as well as data.

We need to follow the following steps

Step 1:
Create xml schema collections in SQL 2005

CREATE XML SCHEMA COLLECTION [dbo].[TableSchema] AS N''

Step 2:
Create the stored procedure as below

CREATE PROCEDURE [dbo].[iu_Table_sp]
@xmlTable AS XML (TableSchema)

Pulling records from SQL data as tree structure (multi-level) xml

2009-03-04T05:53:00.000-08:00

If you want to create multi level(root ->child record-child record)xml message from SQL for biztalk inbound, then you have to use for xml explicit keyword for t-sql and the example is given below

SELECT
Tag
,Parent
,'Table' AS [Table!1!sEntity!element]
,sTable_GUID AS [Table!1!sTable_GUID!element]

,sPhone_no AS [Tablephone!2!sPhone_no!element] ,sPhoneType_cd AS [Tablephone!2!sPhoneType_cd!element]
,sAddressType_cd AS [Tableaddress!3!sAddressType_cd!element]
,sAddress_nm AS [Tableaddress!3!szAddress_nm!element
FROM
tbTableDetails
FOR XML EXPLICIT, BINARY BASE64

Finding biztalk installation directory

2008-02-16T09:04:00.000-08:00

SET BMPATH=
FOR /F "tokens=2* delims= " %%A IN ('REG QUERY "HKLM\SOFTWARE\Microsoft\BizTalk Server\3.0" /v InstallPath') DO SET BMPATH=%%B
IF "%BMPATH%" EQU "" (
ECHO ERROR Locating the BizTalk Installation directory
ECHO Updates not completed
)
GOTO :EOF

Biztalk Map - Adding (Carriage Return, Line Feed) / New Line in element

2008-01-11T18:59:00.000-08:00

We have three fields as address1, address2 and address3 in source schema and in destination side; we want to concatenate them with new line between address1, address2 and address3. if we want newline between data in element, we can achieve it using ASCII to Character functoid with passing input value as 13.

Biztalk - Sending an email with html tags and non html tags (<, >, &)

2007-11-15T08:30:00.000-08:00

Sending an email with html tags and non html tags (<, >, &)

For example, if we want email body output as below

click here to see kannannova.blogspot.com
Thanks & Regards

We have to do the following steps for above output
1.Create custom send pipeline with MIME/SMIME encoder
2. Set the part's SetPartProperty as "text/html". If needed, do url encoding too
3.Do html encoding for html tags only
4.Use escape sequence characters for non html tags (< , > ,&)
<'s escape character is < >'s escape character is >
&'s escape character is &

Technorati Profile

2007-11-13T12:37:00.001-08:00

Technorati Profile

Biztalk Cross Reference

2007-11-07T10:47:00.000-08:00

I created two sample projects ( biztalk and C# winform application ) and Biztalk project has the sample xml data as well. If you want to test these sample, you have to import these xml data into BiztalkMgmtDb using btsxrefimport tool. Then you can test the maps as well as windows application. Cross reference functiods and cross reference API are used when referencing values differ from one system to others. If you want to call api directly without maps, add reference to Microsoft.BizTalk.CrossReferencing.dll, then All database functiods/methods will be available to your class. Sample source code is here http://cid-ce1e6be7cab35183.skydrive.live.com/self.aspx/biztalk/CrossReferenceSample.zip