Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Using JDBC ODBC Bridge

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Using JDBC ODBC Bridge

    I am attempting to setup a source connector, database reader. I have run a simple test that selects rows from the DB based on a status value and sends the raw (XML) data to the destination filewriter to write a file. This work perfectly, the SQL that did the selection was simply done in the Database reader config screen in the SQL window. What I REALLY want to do is Select rows from the DB, join various tables based on certain columns and then format the results into HL7 messages. Upon completion update the status to "Complete".
    Should this be done in the Transformer using JavaScript ? (I am not a javascript developer but have coded in VB, Ansi C, and plenty of SQL). I'm sure I can hack away using javascript but not being familiar with Mirth I wanted to know where the most suitable place to do this would be.

    Thanks
Working...
X