ASP.NET News from Blogger: Integration through Biztalk   Get the feed of: Integration through Biztalk

Total News: 48

EDI Reporting and curious case of missing 997

We all agree that out of box EDI reporting in Biztalk leaves lot of gaps. For example, it is not easy to find all messages which were sent to our partners that didn't send 997 back to us. One can go o...

Remote Desktop issue with VM role

While trying to connect to Biztalk VM image in Azure, if the remote desktop does not connect, try one or all of the following things:Reduce the size of VM image to small (smaller size and lesses proce...

SSIS Package Error

OLE Destination 1 shape would threw the following error:[OLE DB Destination 1 [421]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is a...

Microsoft BUILD

Starting this year, Microsoft rebranded its Professional Developer Conference (PDC) as BUILD. I have no idea what message they are trying to convey with this name change. For some strange reasons, th...

Death of Biztalk -- Are you kidding me?

Honestly, I am tired of statements like BizTalk is Dead or BizTalk is Obsolete. With every release of new technology around Connected System stack, the noise around speculated BizTalk demise gets loud...

Processing Empty Files in Biztalk

In my current integration project, there is a need to process empty files (0 byte) in Biztalk. Default behavior of FILE adapter is to delete an empty file and raise an event. This empty file is then d...

Configuring BAM portal on Biztalk 2010

So, I installed Biztalk 2010 on Win2008 server with SQL server 2008 R2 on a 32 bit machine. Biztalk configuration worked smoothly as one would expect it to until the wizard tried to enable BAM portal....

Biztalk and CEP (Complex Event Processing)

For people interested in integrating CEP with Biztalk, check out the white paper by Jesus Rodriguez at :http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6c1da607-4785-4668-a274-6898c38ea603...

Appfabric Connect Feature on Biztalk 2010

When Dublin (now Windows Server Appfaric) was close to being released, there was lot of talk around the speculative demise of Biztalk. Some of the key differentiators identified at that time were Mapp...

Little trick....that will help you long way

During the process of creating cloud project using VStudio, don't forget to mark external ""reference"" assemblies as ""Copy Local =True"". If this is not done, your application will run fine ...

Biztalk and the Cloud

I was in NY city on Dec 1 for the Azure Firestarter event at the Microsoft Office. It was a nice overview of Azure. For past year or so, I have been thinking of getting my hands dirty with this techno...

Integrating Biztalk with Mobile CE device

One of my recent projects involved developing Biztalk services to be consumed by Windows CE mobile devices. I got a chance to work with compact Microsoft framework. In an ideal world, one would expose...

Batching Non-EDI received documents

EDI Batching in Biztalk is done using Batching orchestration that is shipped with Biztalk. This batching orchestration is directly binded with MessageBox and picks up message with EDI.ToBeBatched=True...

Modifying Biztalk EDI Schemas

There are times when standard Biztalk EDI schemas need to be expanded to include additional validations. It is a 2 step process.1. Modify the relevant EDI schema and preferably modify the namespace to...

Extending VPC hard drive

It has been a while since I last blogged. During this period, lot of things have happened in my life. We were blessed with twins and I took a new role with a new company. A role that lets me focus on ...

Using Biztalk in transaction mode with a WCF client

While trying to use a WCF client to send a message to Biztalk as a transaction, I got the following error:""Cannot access a disposed object. Object name: 'TransactionScope' ""On investigation, I f...

Using SAP Biztalk 2006 R2 WCF adapter

Step 1: BIZTALK TEAMBiztalk side needs to define a Program ID. SAP adapter then registers this Program ID to the SAP gateway defined in the URL. This Program ID then needs to be registered from SAP si...

Accessing SQL data from Infopath Form Control

UserLogIn and UserGroup username() to populate UserName text box.UserGroup text box with following Xpath: PS: XML generated by the wizard marks the 2 user defined columns as ""attributes"". So the...

Integrating MOSS, WF and Infopath

I ventured into relatively ""unchartered"" territory of SharePoint world. I have been working on setting up a a framework involving MOSS, Windows WorkFlow and Infopath 2007. Business requirements ...

Implementing WCF

Why WCF?WCF aka Windows Communication Foundation services is latest product from MSFT for creating Distributive Applications. Year 2007 has been buzzing with new product releases on a weekly basis. It...

Rules for Successful BAM implementation

I learnt from my experience that observing following rules before deploying BAM solutions can go long way towards fewer errors.1) Configure BAM tools to ""Enable Analysis Services for Aggregation""...

Stange behavior of Biztalk 2006 on SQL cluster environment

While testing Biztalk application on server farm mode at one of my client, I came across something interesting. This biztalk application used SQL adapter to connect from orchestration to execute store...

Biztalk and SilverLight

Gloves are out. MSFT is going head on against Adobe. With recent launch of Silverlight, a product that will compete against market leader Flash. MSFT dreams to snatch some serious business from Adobe....

Implementing Business Rule Engine

(To be Updated)This weekend I got down and dirty with BRE (Business Rule Engine). It is a powerful tool for doing on the fly changes. I think it justify its usage in complex logic scenarios. I thought...

Biztalk Best Practices

We recently finished a Biztalk Project with one of our client. It was a 4 week project with tight deadlines. Our team did a great job to deliver quality product on time. I joined the project midway af...

Using Correlation in Loop

Using Correlation set within a Loop is not a straightforward process in biztalk. One way around this is to define a Scope and within the scope define the correlation sets . This scope will be within t...

DebugViewer in Biztalk

""DebugViewer"" is another cool feature that comes with Biztalk 2006. Actually it is part of Studio 2005. Simple steps to use it:1) Download and Install the tool from http://www.microsoft.com/tech...

Passed my Certification Exam!

I passed by Biztalk 2006 Certification Exam Today. I scored about 77%. I would say that I am more relieved than happy. I have One regret though, I wish I was working on Biztalk in my Current project....

MOM Architecture

MOM is another great tool to monitor distributed Biztalk environment. It can easily configure alerts to trigger some activity. This activity can be like sending an email to a person or a group. It can...

Another Successful Implementation

Months of hard work finally helped us execute another successful BizTalk Implementation this week. This was the reason that I was not able to Blog for past few months. I spent past 3 months managing a...

Flat File Schema and Early Termination

For those who have worked with Flat File Schemas, must have used or at least heard the property called "Early Termination". This Property is exposed with Biztalk SP2 but otherwise it can only be edi...

Validating an Instance in Biztalk

How can one validate an instance of the input file and ensure that the required fields needed for business process are present, data type is correct and min/max lengths are conformed with. This is don...

Creating FF Schemas in Biztalk - Different Approach

One of my projects requires integrating a file from Bank into our financial system. The Bank file is a positional flat file with 8 records. The structure is as follow: 1 File header......2 Transa...

"Debugging is not supported under current trust level settings"

If you get the following error while trying to open ASP.net page on the host server. "Debugging is not supported under current trust level settings" You will also get 500 error if you hit th...

Biztalk Server 2006 Clinic- Summary

I attended the Biztalk 2006 clinic on Wed 4 th April at MSFT Office in Iselin,NJ. It was very informative. I left wanting to know more about BAM though. For some reasons it feels as there is so much t...

Migration from Biztalk 2004 to Biztalk 2006

I recently converted a Biztalk 2004 project to Biztalk 2006. Believe me this time MSFT is right when they say that "Migration is very Simple". From my experience, all the orchestrations, pipeline, s...

Coming soon!

I am in process of writing a research paper on Business Integration in general and how Biztalk positions itself in the grand schema of things.Shashikant Raina...

Some New Features in 2006

2006 has some little changes here and there that can contribute to efficiency. Some of them are: 1) Having a "drop" down on the top pane of Solution Explorer window. As in 2004 version there was...

Some New Stuff in 2006

2006 has some little changes here and there that can contribute to efficiency. Some of them are: 1) Having a "drop" down on the top pane of Solution Explorer window. As in 2004 version there was...

Biztalk Installation Errors

We recently got new laptops with Windows XP Pro- Service Pack 2. While installing Biztalk in them we faced several issues. Some of them are listed below with possible solutions: 1) Biztalk installati...

Event Name: BizTalk Server 2006 First Look Clinic - Iselin, NJ

I registered for this seminar. For interested people : Session Code: 1032288971Session Name: BizTalk Server 2006 for DevelopersSession Location: Microsoft NJ Office/Long Beach Conference Ro...

Aggregating the "Split-Gatherer" Pattern using SQL

One of the limitations of BTS 2004 as compared to BTS2006 is its inability to gather the transactions it has split from the original file. Splitting can be achieved by combination of Document and Enve...

Biztalk 2006 is cool!!

Finally I got some time to review 2006. Here are some features that you might find very useful in Biztalk 2006. 1) Calling Pipelines from Orchestrations using expression box This can help in creatin...

Interesting Observation regarding HTTP adapter receive codes

I had an interesting discussion with my co worker. The ASP.Net page I deigned to pass XML through HTTP POST to Biztalk was returning code "200" for succesful submission. The discussion rotated aroun...

Biztalk Macros for FileNames

I want to thank Jan Tielen for the following formats: %datetime%:Coordinated Universal Time (UTC) date time in the format YYYY-MM-DDThhmmss (for example, 1997-07-12T103508). %datetime_bts200...

ASP.Net issue

In my present project, I had to create an ASP.Net page to receive XML documents and pass it do biztalk on basis of Query string: This is what I found out. 1) Ensure that the "Virtual Directory" in ...

Seperating Items from Order without Orchestration

Recently, a co worker approached me with a problem. He had the following xml struture: 1 ABC 01123 35 300.50 45221 27 1430.50 45222 127 11430.50He wanted the following structure as output: 1 ABC...

Biztalk and Integration Patterns

I found this very nice white paper on Integration Patterns. It gives a very macro level view of Solution Architecture and then breaks it down to specific Biztalk level. I recommend this paper to every...

View Other bloggers