Open source tool for connecting disparate legacy medical/clinical databases

Open source tool for connecting disparate legacy medical/clinical databases

Since most of us in IT spend at least part of our time combining data from multiple databases, it might be worth taking a look at an open source toolkit called Hydrate that eases the process. From their description:

Hydrate is a Java tool that provides for fast efficient and error-free transformation of data between three different representations: relational databases, objects in an object-oriented programming language and extended markup language (XML).

Here are few example situations in which Hydrate is helpful:

  • You want to lay a domain object model view over an existing database or set of databases.
  • Your project involves taking various data files fed from external systems that you want to pull into an object model on your server before writing the results down to a fully relational database.
  • You are building a data warehouse in which you have the broad specifications for the model, but want to provide for flexibility and adaptability for future unpredicted requests.
  • You need to integrate data from many different data sources in a highly performant manner.

Here are reasons not to consider Hydrate:

  • If you are working on a green-field application where you have plain old Java objects (POJOs) that you need to make into persistent objects.
  • If you are looking for a straight in-memory object cache for an underlying database.
  • If you want complete abstraction from your persistence mechanism, and are looking for a tool that completely isolates you from the data storage mechanism.
  • If you have an XML document, particularly if it has an XML schema, and you are trying to map this to and from Java objects, while not caring about any other persistent representation.

Shahid N. Shah

Shahid N. Shah

Shahid Shah is an internationally recognized enterprise software guru that specializes in digital health with an emphasis on e-health, EHR/EMR, big data, iOT, data interoperability, med device connectivity, and bioinformatics.


Will at The Candid CIO wrote a great article today: “This is no way to run a project”. Having been in my share of demos that have no defined purpose or evaluation criteria I had a great chuckle.

Did you find this useful?

Medigy Innovation Network

Connecting innovation decision makers to authoritative information, institutions, people and insights.

Medigy Logo

The latest News, Insights & Events

Medigy accurately delivers healthcare and technology information, news and insight from around the world.

The best products, services & solutions

Medigy surfaces the world's best crowdsourced health tech offerings with social interactions and peer reviews.


© 2023 Netspective Media LLC. All Rights Reserved.

Built on Jan 17, 2023 at 9:26am