SQL on FHIR

Unlock the full value of your FHIR® data.

sql-on-fhir-2

A 1upHealth Compute Data Solution

It’s no secret that the current state of healthcare analytics leaves much to be desired. Based on decades-old tooling, systems, and simple rule-based models the current system is simply inadequate. A modern, well-built, easy to use data platform for analytics is essential to achieve and sustain an improved operating model across care, risk, quality and reimbursement – providing the foundation for better care and cost management across the industry. 

Unlocking FHIR® is the Key

sql-on-fhir-3

Transforming legacy healthcare data into the FHIR format is only the first step. Now that the legacy claims and clinical data has been converted into clean, uniform FHIR it’s time to take the next step. It’s time to unlock the true potential of your FHIR data – not only to better understand it but to leverage it to its fullest potential. 

sql-on-fhir-4

To enable customers to unlock FHIR, 1upHealth has developed SQL on FHIR. With SQL on FHIR, it’s possible to easily ask hard questions of your data using tools you are familiar with to get rich answers to make real world decisions. 

sql-on-fhir-5

FHIR on its own is not queryable – it needs to be flattened in order to be used within a relational database. SQL on FHIR takes your FHIR data and facilitates it through a process so that it is queryable for SQL purposes. Making FHIR data available and computable in a timely, relational manner enables customers to reduce costs, increase revenue, smooth operations, and gain new capabilities.

How It Works

SQL on FHIR provides read-only, timely access to a client’s data in our secure FHIR server using standard SQL tooling. This makes it easy to start discovering insights and creating compelling visualizations using common tools such as Power BI and Tableau, as well as many other SQL-oriented tools.

Additionally, we’ve designed SQL on FHIR with ease of use in mind. Easy to implement and usable by any sized company, your data team doesn’t need to know how to program in FHIR. Our SQL on FHIR solution provides you the capability to apply the tools your data teams are already familiar with using.