Hi all,
Another way to move messages to SQL databases is the Soap Endpoint in SQL-Server (2005). We use a transalation from HL7 to XML, and wrap it in a soap envelope, TCP/IP will deliver it to the Soap Endpoint and from there a Stored Proc will pick it up and handle it. You may even store it as xml strings, if needed.
I think the handling of XML is a lot better in version 5.6 and upward, though.
yours sincerelly,
Chris Arts
Netherlands
