Skip to content

One platform for the formats healthcare uses

DeltaForge parses FHIR resources, HL7 v2 messages, and X12 EDI documents into Delta tables. Query them all with SQL. No Spark cluster. Your data stays inside your network.

FHIR R4 and R5 resources parsed into Delta tables
HL7 v2 messages (ADT, ORU, ORM and more) parsed into Delta tables
X12 EDI claims, remittances, and eligibility parsed into Delta tables
FHIR JSON/XML Patient, Observation, Claim... HL7 v2 Messages MSH|ADT^A01|PID|PV1|OBX... X12 EDI ISA*00*...*ST*837*0001~ DeltaForge healthcare parsers FHIR / HL7 / X12 store Δ Delta tables Correlate across formats with SQL SELECT p.id, p.family_name, o.value AS lab_result, c.amount AS claim_amount FROM fhir_patients p JOIN hl7_observations o ON p.id = o.patient_id JOIN edi_claims c ON p.id = c.patient_id;

FHIR resources

Common FHIR R4 and R5 resources parsed directly into Delta tables from JSON, XML, NDJSON, or RDF/Turtle. Clinical, medication, financial, and document resource types are covered.

See full FHIR details

HL7 v2 messages

Pipe-delimited HL7 v2 messages parsed segment by segment into Delta tables. ADT admission events, ORU lab results, and ORM orders each land in typed columns and are joinable with SQL.

Read: HL7 to SQL without an interface engine

X12 EDI

Healthcare and supply-chain X12 documents parsed into Delta tables. Covers 837 claims, 835 remittances, 270/271 eligibility, 834 enrollment, 850 purchase orders, and more. EDIFACT and TRADACOMS also supported.

See full EDI details

HIPAA, PHI residency, and air-gapped deployment

DeltaForge is installed and operated by you, so protected health information never leaves your environment. Run it on-premises, on VMs in your own AWS, Azure, or GCP account, or in a fully air-gapped network with no outbound connectivity required for query execution. For de-identified research extracts and limited data sets, built-in pseudonymisation replaces identifiers consistently across tables, and role-based access control and audit logging govern who can see what.

Frequently asked questions

Healthcare formats and PHI handling, in practice

Which healthcare formats does DeltaForge handle in one platform?

Three families on a shared SQL surface: FHIR R4 and R5 resources, HL7 v2 pipe-delimited messages, and X12 EDI documents. EDIFACT and TRADACOMS are also supported.

Can clinical, message, and claims data be joined in one query?

Yes. Each parser writes Delta tables with typed columns. A single SELECT can join FHIR Patient to HL7 v2 OBX observations to X12 837 claim lines on shared identifiers.

How does DeltaForge handle HIPAA and PHI residency?

DeltaForge is installed and operated by the customer on their own infrastructure: on-premises, customer cloud VMs (AWS, Azure, GCP), or air-gapped environments.

Is a Spark cluster required to run healthcare workloads?

No. DeltaForge has its own SQL engine that reads and writes the Delta Lake on-disk format directly. The same engine parses FHIR, HL7, and X12 and serves queries.

Further reading

For the HL7 side, HL7 to SQL Without an Interface Engine walks through parsing ADT and ORU feeds. FHIR Analytics Without Spark covers resource flattening, and Query EDI Files with SQL shows 837 and 835 claims analysis end to end.

All your healthcare formats in one lakehouse

FHIR, HL7, and EDI parsed into Delta tables on your own infrastructure. Query across all three with SQL.