Author: Imran Sabir

About The Author

How to consume HL7 2.6 messages in BizTalk Server 2013R2

With the release of BizTalk Server 2013R2, BizTalk HL7 Accelerator (BTAHL7) now supports HL7 2.6 schemas. There are two BTAHL7 installation packages, 32 bit and a 64 bit, only install 32 bit on a 32 bit machine. The 64 bit package enables the MLLP adapter and pipeline to run in both 32 bit and 64 bit mode. The BTAHL7 installation package installs the following project templates related to HL7 in Visual Studio. Empty BTAHL7 Project BTAHL7V2XCommon Project BTAHL7V21Common Project BTAHL7V22Common Project BTAHL7V23Common Project BTAHL7V231Common Project BTAHL7V24Common Project BTAHL7V25Common Project BTAHL7V251Common Project BTAHL7V26Common Project BTAHL7Common contains Header and Acknowledgement schemas...

Read More

BizTalk: Consuming Messages from PeopleSoft Advance Queue (AQ)

In a recent project we were faced with a problem of De-Queueing messages from PeopleSoft Advance Queue using BizTalk. BizTalk LOB adapters pack have both a “Microsoft BizTalk Adapter for Oracle Database” and a “Microsoft BizTalk Adapter for Oracle E-Business Suite,” but none of these options will let you consume Oracle Advance Queue directly, rather you can use these adapters to connect to Oracle. You can use 3rd party adapters to consume AQ but here is a simple approach. As using these adapters allows you to call the Store Procedure (SP) in Oracle, a simple approach is to let...

Read More