So scenario is from SAP to HL7, using the BATHL assembler in the send side to serialize the HL7 stream to flat file format then relay via MLLP adapter. Lesson leant, To help debugging, I took the BTAHL assembler pipeline component, reflected to be my custom pipeline component. This way, I have a debuggable component […]

This is for connecting SharePoint Foundation 2010 from BizTalk 2010, after deploying the adapter web service on the SharePoint server, adjust the TPM registry setting in the BizTalk server, my BizTalk server keep complaining although I confirmed many times the BizTalk host instance account is one of the group members. ‘The Windows SharePoint Services adapter […]

Here are some tips for building the custom WCF LOB Adapter leant in the past days… § Design time § xxxURL.cs: This is where the custom connection string will go, i.e. for my scenario, the binding string is fax://faxserver/?enableTracing, the schema is fax, the fax server is host, enable tracing is custom query parameter which […]

Just to repost an entry to undeploy BRE rule a few years back in my another blog. USE [BizTalkRuleEngineDb]GO/****** Object:  StoredProcedure [dbo].[usp_un_rule]    Script Date: 04/27/2009 22:34:05 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO Create Procedure [dbo].[usp_un_rule](@rulesetName varchar(255),@verMajor int,@verMinor int)AsBeginDECLARE @RuleSetID intSELECT @RuleSetID = nRuleSetIDFROM RE_RulesetWHERE strName=@rulesetName AND nMajor=@verMajor AND nMinor=@verMinor UPDATE RE_RulesetSET nStatus = 0   WHERE nRuleSetID […]

It turns out SAP is leveraging the same concept as BizTalk load balancing concept, with a message server and buntch of application servers. The connection should be setup to the message server instead of the specific application server behind it. This is something new, took me sometime to figure it out. Steps below, Change the […]

The HL7 flat file disassembler use the logic below for body document spec, if party defined, use configured namespace, else use standard HL7 namespace append with #MSH9_1 append with #MSH9_2 append with #MSH12_1 without ‘.’ if MSH12_2 present append it, else append ‘GLO’ if MSH12_3 present append it, else append ‘DEF’ <still not clear> It […]

Problem is if you come up with a custom trigger event within a domain, i.e. ADT_ZZZ, the accelerator requires not only update the MSH schema, but also create the custom schema, i.e. ADT_ZZZ_231_GLO_DEF.xsd. It would be nice if to get rid of this behavior and a single schema handles all custom trigger event within a […]

// if set passthrough to true, then this disassembler is a passthrough componentobject obj2 = inMsg.Context.Read(“PassThru”, “http://HL7Schemas.HeaderPropertySchema”);if ((obj2 != null) && ((bool) obj2))                {                    this.mCalledFirstTime = false;                    this.mMessageList[0] = inMsg;                }                Technorati Tags: BizTalk,HL7 // either individual or batch// determined by HL7DataReaderthis.mType=Individual // source partyMSH3_1, MSH_3_2,MSH_3_3 // ProcessIndividualMessage1) process message headerHL7MessageProcessor wrap documenspec i.e. http://microsoft.com/HealthCare/HL7/2X#MSH_25_GLO_DEFpass […]