Category Archives: BizTalk

When working with EDI in BizTalk, you will encounter an issue when the incoming EDI file of any format (X12 820 3040) will fail at the receive port (using EDIReceive Pipeline) due to data format or non-compliance with EDI Schema … Continue reading →

When working with monetary amount (X12 R/N type) that has trailing zeros then you may run into issues when the transactions are suspended with the following error:   Invalid character in the Data element (Field error).   The invalid character … Continue reading →

What is EDI? Originated in 1970s to facilitate the delivery of data between businesses Computer to Computer exchange is much less expensive than traditional methods of document exchange Benefits – reduced human error, speed, faster transactions, etc Drawbacks – tightly … Continue reading →

When you set the date format to YYMMDD for an EDI interchange, BizTalk changes the format to CCYYMM especially when sending batched EDI interchange. This is a known bug that Microsoft has identified and released a hot fix for the … Continue reading →

You can specify multiple (mapping action) or single SOAP action on a Send Adapter when using WCF adapter for Oracle Databases 3.0 (WCF-Custom adapter). The single format would like below:     the multiple SOAP actions format look like below:   Related articles: … Continue reading →

BizTalk Oracle Adapter 2.0 uses System DSN to look up Oracle Instance and connect to it. WCF Adapter 3.0 for Oracle databases uses tnsnames.ora file. So when migrating to WCF Custom Adapter remove the System DSNs from the Data Sources … Continue reading →

Microsoft is planning to release BizTalk 2009 (dropped the name 2006 R3 as it is feature complete) sometime in the first quarter of 2009. This release will support Visual Studio 2008 SP1, Windows Server 2008 SP1 and SQL Server 2008. … Continue reading →

In this scenario, I would like to poll a Oracle database table checking for a certain column (default value is null), get back a bunch of rows that match my select condition, update the column with some value and send … Continue reading →

Software Prerequisites Download this document for step by step instructions with screen shots. Make sure you have the following components installed on the system where you will install the BizTalk Adapter Pack: Microsoft .NET Framework 3.0. Microsoft BizTalk Server 2006 … Continue reading →

  BizTalk Adapters Processing Generation of BizTalk schemas based on SQL statements, Stored Procedures (in, out, return parameters), multiple tables Periodic polling of data source Oracle alerts (send and receive) can send asynchronous notifications based on some events. Uses DBMS_ALERTS … Continue reading →