EDI Processing

X12 EDI into Delta tables

DeltaForge parses X12 EDI documents into Delta tables. Load a 837 claim file or an 850 purchase order, then query it with SQL like any other table.

X12, EDIFACT, and TRADACOMS parsing
Healthcare, supply chain, and finance transaction sets
Query parsed segments with SQL on your own infrastructure
Raw X12 EDI ISA*00* *00* *ZZ*SENDER GS*HC*SENDER*RECV*... ST*837*0001~ BPR*C*100.00*... NM1*IL*1*DOE*... CLM*ABC*100.00*... parse DeltaForge EDI parser ISA / GS / ST segments + loops store edi.claims clm_id | amount | npi | ... edi.orders po_num | buyer | total | ... edi.remittances chk_num | payee | paid | ... Query parsed EDI with SQL SELECT clm_id, amount FROM edi.claims WHERE amount > 500 ORDER BY amount DESC;

EDI formats

Parsing support for the major EDI standards

ANSI X12

North American standard. Full envelope parsing: ISA/IEA, GS/GE, ST/SE, loops, and segments.

UN/EDIFACT

International standard. UNB/UNZ interchange, UNH/UNT message, composite element handling.

TRADACOMS

UK retail standard. Order, invoice, delivery, and acknowledgment message types.

X12 transaction sets

Built-in transaction lookup table with 200+ codes; common sets shown below

Healthcare

837 (claims), 835 (remittance), 270/271 (eligibility), 834 (enrollment), 820 (premium payment).

Supply chain

850 (purchase order), 856 (advance ship notice), 810 (invoice).

Transportation

204 (load tender), 214 (shipment status).

Bring EDI into your lakehouse

Parse X12 and EDIFACT documents into Delta tables and query them with SQL on your own infrastructure.

Get Community License Read Documentation