Stream: analytics on FHIR
Topic: SQL Server
Paul S (Feb 01 2019 at 02:03):
Can anyone share SQL scripts for FHIR STU3 to generate tables? I am working on a project which requires parsing of JSON to SQL Server DB.
Grahame Grieve (Feb 01 2019 at 02:04):
@Ryan Brush @nicola (RIO/SS) but Paul you should look back through this stream
Paul S (Feb 01 2019 at 02:45):
@Grahame Grieve Thanks for pointing out this stream to me. I went through it. Lots of very useful information so it was time well spent but I couldn't find a script or schema. I'll appreciate if someone can help.
nicola (RIO/SS) (Feb 01 2019 at 08:16):
You can look at https://www.health-samurai.io/fhirbase - we use jsonb and schema is simple create table (id text, resource jsonb, ....)
nicola (RIO/SS) (Feb 01 2019 at 08:19):
If you use MS SQL - it also has some json support - so you can port this approach
Paul S (Feb 01 2019 at 14:00):
@nicola (RIO/SS) thanks.
Last updated: Apr 12 2022 at 19:14 UTC
