Sql Loader

The Sql Loader tool allows users to connect to existing databases and directly query/retrieve HL7 messages from a database by writing SQL select statements. It can automatically detect which column contains message data and pipes this data to the Message Editor window.

Query Window

The Query Window is much like any traditional query window where you write SQL statements against a database. In the example below, we are querying a table (actually a view) called MessageBucket for all messages greater than a specific date. After hitting the "Execute" button, the results of the query are displayed in the grid below. The difference is that if an HL7 message is detected in the returned result set, these messages are extracted and displayed in the Message Editor window.

Once retrieved from the database, the messages can be operated on just like files (e.g., sorting, calculating field statistics, sending via HL7 MLLP, etc.).

Database Connection Settings

To connect to a database, you'll need to add a configuration entry with the appropriate settings for the type of database you are connecting to.