BizTalk Server Applications Integration - Will BizTalk do this??

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Applications Integration > June 2004 > Will BizTalk do this??





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Will BizTalk do this??
Kevin Buchanan

2004-06-02, 11:55 pm

Ok - first, I am new to BizTalk...but have been programming about 7+yrs.

I want to feed HL7 message into SQL server - can the HL7 Accelerator and BizTalk 2004 be used to process and parse the HL7 messages?

Anyone working in healthcare will know about the HL7 - basically, it is a message schema. For ADT messages, some will be for admissions/registrations, discharges, updates, transfers, etc...

The real trick I am look for is that BizTalk recognize the message type - and then know whether to update a record or to create a new record. Parsing the HL7 message is real pain if handled programatically with sockets and streams...SO...can BizTalk 2004
and the HL7 accelerator do the trick?
John

2004-06-04, 2:55 am

This is perfect job for BizTalk!!!

"Kevin Buchanan" <anonymous@discussions.microsoft.com> wrote in message
news:B8FD12BE-7793-43E3-8E1F-95001211F418@microsoft.com...
> Ok - first, I am new to BizTalk...but have been programming about 7+yrs.
>
> I want to feed HL7 message into SQL server - can the HL7 Accelerator and

BizTalk 2004 be used to process and parse the HL7 messages?
>
> Anyone working in healthcare will know about the HL7 - basically, it is a

message schema. For ADT messages, some will be for
admissions/registrations, discharges, updates, transfers, etc...
>
> The real trick I am look for is that BizTalk recognize the message type -

and then know whether to update a record or to create a new record. Parsing
the HL7 message is real pain if handled programatically with sockets and
streams...SO...can BizTalk 2004 and the HL7 accelerator do the trick?


Oliver Nee

2004-06-04, 7:57 am

>SO...can BizTalk 2004 and the HL7 accelerator do the trick?

Sure. If that's all you want to do with those HL7 messages,
BTS&BTAHL7 might be overkill, though. BizTalk can do
so much more!

--


Nick Malik

2004-06-04, 11:56 pm

Oliver has a point. If all you want to do is parse HL7, there are some
inexpensive apps that will do this for you, very quickly and efficiently.
On the other hand, if you have more than one place you need to pass the
information to (like billing systems, diagnostic systems, registration
systems, etc) then Biztalk is an excellent choice. It's not that the tool
is difficult to use (it has a learning curve, but so does anything worth
having)... it's just that Microsoft priced it so high that cost justifying
it is a challenge, especially when using it for simple things like this.

--- Nick
Biztalk Bum

"Kevin Buchanan" <anonymous@discussions.microsoft.com> wrote in message
news:B8FD12BE-7793-43E3-8E1F-95001211F418@microsoft.com...
> Ok - first, I am new to BizTalk...but have been programming about 7+yrs.
>
> I want to feed HL7 message into SQL server - can the HL7 Accelerator and

BizTalk 2004 be used to process and parse the HL7 messages?
>
> Anyone working in healthcare will know about the HL7 - basically, it is a

message schema. For ADT messages, some will be for
admissions/registrations, discharges, updates, transfers, etc...
>
> The real trick I am look for is that BizTalk recognize the message type -

and then know whether to update a record or to create a new record. Parsing
the HL7 message is real pain if handled programatically with sockets and
streams...SO...can BizTalk 2004 and the HL7 accelerator do the trick?


Kevin Buchanan

2004-06-11, 5:44 pm


Nick: I agree totally. We installed the 120 day version yesterday and hope to get some communications established today...although I am not exactly 'counting' on it. The sample version that shipped with the HL7 accelerator didn't work. Maybe we c
an create one (from the "step-by-step" guide) that will work!

I was a little lax with the explanation of what we want it to do...if we can get the data into SQL - that is the primary need. Secondary needs are much greater - like physician notification (text paging) for lab results, excessing wait times, new arrival
s, etc...(long laundry list here).

-Kevin


----- Nick Malik wrote: -----

Oliver has a point. If all you want to do is parse HL7, there are some
inexpensive apps that will do this for you, very quickly and efficiently.
On the other hand, if you have more than one place you need to pass the
information to (like billing systems, diagnostic systems, registration
systems, etc) then Biztalk is an excellent choice. It's not that the tool
is difficult to use (it has a learning curve, but so does anything worth
having)... it's just that Microsoft priced it so high that cost justifying
it is a challenge, especially when using it for simple things like this.

--- Nick
Biztalk Bum

"Kevin Buchanan" <anonymous@discussions.microsoft.com> wrote in message
news:B8FD12BE-7793-43E3-8E1F-95001211F418@microsoft.com...[vbcol=seagreen]
> Ok - first, I am new to BizTalk...but have been programming about 7+yrs.
BizTalk 2004 be used to process and parse the HL7 messages?[vbcol=seagreen]
message schema. For ADT messages, some will be for
admissions/registrations, discharges, updates, transfers, etc...[vbcol=seagreen]
and then know whether to update a record or to create a new record. Parsing
the HL7 message is real pain if handled programatically with sockets and
streams...SO...can BizTalk 2004 and the HL7 accelerator do the trick?



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com