FHIR - SQL Server Database Question

Question

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.

Answer 1

@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’.