Covast has announced that Advanced B2B and ebXML(Electronic Business using extensible Markup Language) capabilities to be Delivered in Microsoft BizTalk Server R3.This is a great news for the customers who were using BizTalk 2006 and Covast Separately implementing EDI and B2B solutions.Please see the Covast Press release
Covast Adds ebXML Capabilities to Microsoft BizTalk Server 2006 R3
http://www.covast.com/news/press.asp?id=92
Covast’s Advanced B2B Capabilities to be Delivered in Microsoft BizTalk Server 2006 R3
http://www.covast.com/news/press.asp?id=91
Tuesday, October 14, 2008
Monday, January 14, 2008
Inbound File Name Hipaa Accelerator BizTalk 2006
I have seen many blogs to get the Source File Name in Hipaa Adapter as the Hipaa Accelerator removes the file name properties when it converts EDI to XML format and the SourceFileName Macro also doesnt work.To solve this issue follow these simple steps
1.Original file name is stored in Hipaa Accelerator database and the Table name is audin and the column name is origfilename.
2.In Audin Table we have icr as control Number,sid as sender Id ,rid as receiver ID and Date and time (HHMM) format is stored in these tables
3.For each EDI file we can have only control number and also Hipaa accelerator does not allow duplicate files to process as per its design
4.Create Store Proc on Hipaa Accelarto Db as
Select OrigFileName from audin where icr=@controlnumber and sid=@senderid and rid=@receiverid and date=@datefield and time=@timefield
5.We all know these values comes from the edi file either use a store procedure functoid in the map to get the filename or you can use an SQL port to execute the store procedure
6.Once we have the file name in the map or in orchestration we can write the inbound filename
Please email me or send me request if you have questions or comments on this article
Thanks
1.Original file name is stored in Hipaa Accelerator database and the Table name is audin and the column name is origfilename.
2.In Audin Table we have icr as control Number,sid as sender Id ,rid as receiver ID and Date and time (HHMM) format is stored in these tables
3.For each EDI file we can have only control number and also Hipaa accelerator does not allow duplicate files to process as per its design
4.Create Store Proc on Hipaa Accelarto Db as
Select OrigFileName from audin where icr=@controlnumber and sid=@senderid and rid=@receiverid and date=@datefield and time=@timefield
5.We all know these values comes from the edi file either use a store procedure functoid in the map to get the filename or you can use an SQL port to execute the store procedure
6.Once we have the file name in the map or in orchestration we can write the inbound filename
Please email me or send me request if you have questions or comments on this article
Thanks
Friday, January 04, 2008
BizTalk Adapter for Oracle Database modifies the data in the DateTime field
There is a hot fix for this issue from Microsoft
http://support.microsoft.com/kb/921999
http://support.microsoft.com/kb/921999
Subscribe to:
Posts (Atom)