How to connect my azure sql to Azure API for FHIR

Ramesh Kanagaraj 1 Reputation point
2022-09-13T15:32:11.07+00:00

I'm spinning up Azure API for FHIR but I need to connect my Azure SQL as backend for that. I couldn't find any document to connect Azure API for FHIR with Azure SQL. Can you please help me to resolve this use case.

Azure SQL Database
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.
149 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee
    2022-09-13T17:14:06.72+00:00

    Hi @Ramesh Kanagaraj Welcome to the Microsoft Q&A forum, and sorry for the trouble you are facing
    As we understand the ask here is you want to connect Azure API for FHIR with Azure SQL and looking for some documentation.
    Are you trying the OSS version or the managed services?
    You can choose the backend only while deploying the OSS version. Managed services do not give you an option to change the backend.
    Azure API for FHIR internally uses Cosmos DB backend, and the FHIR server in AHDS uses SQL backend. Unfortunately, you cannot change these. Also, you do not have direct access to the backend in managed services
    You can find the git repo on OSS Here for more information on Managed service please check here

    Please let e me know if you are looking for any additional information.

    Regards
    Geetha

    Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.