hapi fhir existing system database?

860 views
Skip to first unread message

mthak...@gmail.com

unread,
Aug 1, 2018, 12:27:40 PM8/1/18
to HAPI FHIR
I got the JPA server example project up and running. It took me and helpful community members a few days!!! 

I am very new to java and FHIR. I am going to read up the hapi fhir website but can you please guide me on some points:
1. I plan to allow third party systems to perform CRUD on various entities that I deal with (patient, care plan). Where exactly should I write that code?

2. I have MS SQL Server in which my current system database is stored. I believe the FHIR structure and data is being stored in derby database. Say, a read on patient is performed who is actually in MS SQL database. How can I fetch that patient and then provide it to the third party caller via FHIR server?

3. Say there are two databases. FHIR server's database and my system's database. Is it mandatory to keep these databases in sync? If yes, how?

Thanks

Kevin Mayfield

unread,
Aug 1, 2018, 1:22:18 PM8/1/18
to mthak...@gmail.com, HAPI FHIR
Have a read of this


That’s a simplified description of what we did (and helps navigate our bigger sql based server)

That is working with a mongodb, our main server uses Postgres via Jpa/hibernate orm. Jpa does database access via entities and our data access layer maps these to hapi fhir objects. 

Sent from my iPhone
--
You received this message because you are subscribed to the Google Groups "HAPI FHIR" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hapi-fhir+...@googlegroups.com.
To post to this group, send email to hapi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/hapi-fhir/2ec3b9ea-0e99-4154-b680-d4c0bed6c0a2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Malay Thakershi

unread,
Aug 2, 2018, 7:39:25 AM8/2/18
to mayfiel...@gmail.com, HAPI FHIR
So you mean I should start with the "Patient server" and then better my understanding with CCRI?
--
Malay Thakershi

Kevin Mayfield

unread,
Aug 2, 2018, 11:24:22 AM8/2/18
to Malay Thakershi, HAPI FHIR

Yes, the Patient server was deliberatley simple. Aiming to show the layers/elements that both the HAPI JPA server and CCRI do.

I would look over the code base for both. We actually evolved our system from JPA Server, I think only the CodeSystem, Concept and ValueSet remains. I would probably do the same if I was starting from stratch.

Malay Thakershi

unread,
Aug 3, 2018, 2:43:04 AM8/3/18
to Kevin Mayfield, HAPI FHIR
Could you please tell me where is the code base for both approaches?

Yes, I am starting from scratch as far as FHIR servers and specs are concerned. So I believe you are suggesting I start with JPA server approach.
I want to allow third-party systems to call API and enroll patients in personal health management care plan.
Then third-party systems shall query progress of each enrollment using API.
These APIs shall be FHIR DSTU3 compliant.
I am going to read up and try out both approaches but any further guidance on my requirements would be appreciated.

--
Malay Thakershi

Kevin Mayfield

unread,
Aug 3, 2018, 3:35:21 AM8/3/18
to Malay Thakershi, HAPI FHIR
Main hapi site has this

http://hapifhir.io/doc_jpa.html

It's repo is here
https://github.com/jamesagnew/hapi-fhir/tree/master/hapi-fhir-jpaserver-example

CCRI the equivalent is here:
https://github.com/nhsconnect/careconnect-reference-implementation/tree/master/ccri-fhirserver

The main difference in the implementation is the CCRI uses the RESTful
server (http://hapifhir.io/doc_rest_server.html) and the database
structure is very different (see attached). Using tables to store the
data also means a lot of the queries/resources aren't supported (because
they have to be built).
p.s. CarePlan is a work in progress at the moment
CCRI-Postgres.JPG

Malay Thakershi

unread,
Aug 6, 2018, 12:35:05 PM8/6/18
to Kevin Mayfield, HAPI FHIR
Hey Kevin, Is fhirbase a CCRI?
--
Malay Thakershi
Reply all
Reply to author
Forward
0 new messages