Azure Api for FHIR managed service for SQL server DB

Question

I would like to use Azure Api for FHIR managed service by Azure (https://learn.microsoft.com/en-us/azure/healthcare-apis/overview) and not host my own FHIR Server.

• Do you have any documentation on how to import data from our legacy SQL DB into FHIR?.
• Do you have GUI for ETL process?
• Few APIs should be publicly available with Anonymous Access, how can we implement?.

Answer 1

Hi @Sln , welcome to Microsoft Q&A forum.

So currently I could not locate any step by step documentation to achieve the same but I would recommend you to please once go through the below code piece where its reading data from files and loading it to Azure FHIR server. We can replace the code to read from SQL database instead and follow the similar code to achieve our requirements.
https://github.com/hansenms/FhirLoader

You can check if this fulfils you requirements and in case more information is needed please let us know.

Also anonymous access would work only with publicly available server:
https://learn.microsoft.com/en-us/power-query/connectors/fhir/fhir-authentication#anonymous-access

----------

If answer helps, please select 'Accept Answer' as this could help other community members looking for similar queries.

Answer 2

Can some one from MSFT help me on the above questions?

Answer 3

Can some one from MSFT help me on the above questions?