FHIR - SQL Server Database Question

Neeraj Shrivastava 41 Reputation points
2022-06-22T19:13:39.093+00:00

Hi,

I have setup a FHIR Server for Azure by selecting database option as SQL Server, I inserted few patient and observations data using POSTMAN and could verify via Postman also through the Query editor (Azure - SQL Database) using DBO.RESOURCE table

My question is :-
How can we see the actual Patient details or any other Resources data directly in SQL Server database using a SQL Query, we dont have direct resource specific tables so was wondering how to check the data using a SQL Query. Is there a conversion function i need to run in my SQL Query to convert RAW data to JSON or any other format or is it not possible to see the data via SQL Query ?

Thanks,
Neeraj.

Azure Health Data Services
Azure Health Data Services
An Azure offering that provides a suite of purpose-built technologies for protected health information in the cloud.
79 questions
No comments
{count} votes

Accepted answer
  1. JananiRamesh-MSFT 9,301 Reputation points Microsoft Employee
    2022-07-11T04:21:13.417+00:00

    @Neeraj Shrivastava Thanks for reaching out. From the description I understand that you have created a FHIR server by selecting database option as SQL server you have inserted few patients and observations data via postman, and you wanted to know how to see the actual patient details directly in SQL server database using a SQL query. I had a discussion internally and Product Group confirmed that we do not support this type of queries, you must use the REST API's to retrieve and query for data.

    you can also leave your feedback here https://feedback.azure.com/d365community/forum/c2115f96-0625-ec11-b6e6-000d3a4f0858

    Please let me know incase of further queries, I would be happy to assist you.

    To benefit the community find the right answers, please do mark the post which was helpful by clicking on Accept Answer’ & ‘Up-Vote’.


0 additional answers

Sort by: Most helpful