Processing an EDI 834 file in Azure

sam nick 286 Reputation points
2021-03-18T18:20:37.187+00:00

Hi,
I am new to Azure and have the task of parsing an 834 EDi file and convert it to a csv / load it to a sql table completely via Azure Data Factory. I should sftp the file from the client site to our blob storage and from there, pickup that file and parse it. Is this possible just by using the Logic apps or do i need to have BizTalk Server.

Also any recommendations if this can be done any other efficient way ? Been scouring the internet, but just not able to narrow down the right path.

Thank you.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,983 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,127 questions
0 comments No comments
{count} vote

5 answers

Sort by: Most helpful
  1. Mike Urnun 9,786 Reputation points Microsoft Employee
    2021-03-19T23:46:19.883+00:00

    Hello @sam nick ,

    Welcome to the MS Q&A, and thank you for posting here!

    You can implement all of the tasks (in a single or a separate workflow) in Logic Apps.

    Here is the list of resources that'll help implement each task:

    If the above seems like an overwhelming resource to go through and you'd rather need a minimal working sample, let me know and I'd happy to answer any further questions you might have and help you arrive at a working solution as soon as possible.

    1 person found this answer helpful.

  2. sam nick 286 Reputation points
    2021-03-24T01:33:18.697+00:00

    Hi Mike,
    sorry for the delayed response. I tried going through the "exchange x12...link", but am stuck at the integration account. Not sure how to proceed. Not many tutorials either on the integration account > schema, artefacts etc..

    Any other guidance or a path to understand your current recommendation would be greatly appreciated.

    0 comments No comments

  3. Mike Urnun 9,786 Reputation points Microsoft Employee
    2021-03-25T03:52:20.173+00:00

    Hi @sam nick - Could you elaborate on which particular step was confusing? I'm part of the Azure team that's in charge of improving our docs, so at your convenience, please consider sharing your feedback by using the "This Page" button found towards the bottom of the doc. We'd love to work with you to address the issue in the doc so that others won't hit the same issue.

    With that said, Integration Account is a must-have when working in B2B scenarios with EDI files but at its core, it's simply a container for your integration artifact files -- by hosting your artifacts so, it provides scalability and management features for your Integration workflows that run in your Logic Apps.

    I agree with your point that useful docs may be scarcely available (hence my request for you to share feedback). However, I did find the following video quite helpful in getting an end-to-end understanding of this topic: Session 9 - Logic Apps - Enterprise Integration Pack

    0 comments No comments

  4. sam nick 286 Reputation points
    2021-04-02T20:42:27.21+00:00

    @Mike Urnun - The integation account is where I am getting stuck at. From the provided link, it talk about mapping and xsd which are artefacts that need to go into the Integration account. It also says that only 2015 Visual studio works and not 2017. With me, i have the core xml file that was developed by an earlier developer for the 834 file. How to proceed from this ?

    I found another link explaining the process. https://vnbconsulting.com/2018/03/develop-end-to-end-b2b-edi-supply-chain-solution-with-azure-logic-apps-part-2/

    But in the above link, in the provided EDI schema link, there are multiple versions of the 834 ex: x12_00401, X12_00301 etc.


  5. Wang, Jane 61 Reputation points
    2021-10-12T22:19:27.123+00:00

    any success using logic app to transform x12 to other formats? thanks,

    0 comments No comments