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

Sql DB to Paradox Db using Mirth engine

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

  • Sql DB to Paradox Db using Mirth engine

    Hi I am using mirth engine to communicate between sql server db and paradox db. I have list of ids from a mssql table and for those Ids I have to grab results(columns) from paradox db and update them back in the mssql table.

    I would like to proceed this way. Can you guys suggest me whether it is the best option available?

    Initially I created a channel "Sender" which sends the list of ids (UNABLE TO EXECUTE USING STORE PROCEDURE AND JAVASCRIPT IN MIRTH) from MSSQL. And I will create a destination channel "Receiver" which gets the results from Paradox DB for those ids.

    Concerns:

    1) How do I execute the sp in channel "sender" and pass those ids to the "Receiver" and how do I get the results from the paradox db and update them back to MSSQL DB.

    Is there an example or a guideline to do this? Your help will be greatly appreciated.

    Thank You
Working...
X