Yes, you will need/want a 3rd party app to translate your HL7 data. You
can write your own, but handling the record sequences and variable
fields is quite a pain. I have used Interfaceware's Chameleon in the
past. While a bit pricy, it will save literally weeks of time trying to
write a custom solution.

=======================
Mark Harr


> -----Original Message-----
> From: grea
> [mailto:mssqldba-ezmlmshield-x45159894.[Email address protected]
> Sent: Thursday, May 27, 2004 10:39 AM
> To: LazyDBA.com Discussion
> Subject: HL7 message import
>
> Hi folks,
> I've got a MSSQL DB that I want to receive updates from an
> Oracle DB via
> TCP/IP Messaging (HL7). Anyone know how to get these messages
> in? Do I need
> 3rd party SW to listen for them?
> Regards
> Gab
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> NCHT
> **********************************************************************
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>

MS Sql Server LazyDBA home page