To parse edi file and generate pdf file for each claim data in the synapse notebook

Sadaiyappan Theivarayan 0 Reputation points
2023-03-14T09:54:53.6766667+00:00

I need to parse EDI 837 file and convert it into PDF for each claim in EDI 837 based on predefined template. Consider the volume & no of Edi files is huge , We are planning to handle the EDI parsing and pdf generation in the synapse notebook using pyspark /python Open libraries. Will it be optimal solution, instead of going for Logic apps?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA 90,641 Reputation points Moderator
    2023-03-15T06:21:47.72+00:00

    Hello @Sadaiyappan Theivarayan,

    Thanks for the question and using MS Q&A platform.

    It is possible to parse EDI 837 files and convert them into PDFs for each claim in EDI 837 using a Synapse notebook and PySpark or Python open libraries. Whether this is an optimal solution compared to using Logic Apps would depend on the specific requirements and constraints of your use case.

    If you have a large volume of EDI files and need to process them efficiently, using PySpark or Python open libraries in a Synapse notebook may be a good option. PySpark provides a distributed computing framework that can handle large amounts of data, and Python open libraries can be used to parse EDI files and generate PDFs.

    On the other hand, if you need a more streamlined and low-code solution, Logic Apps may be a better option. Logic Apps provides a visual interface for building workflows and integrating with other Azure services, which can simplify the process of parsing EDI files and generating PDFs.

    It is recommended to evaluate both options based on your specific requirements and constraints, and choose the one that best fits your needs.

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.