How to ingest a x12 file into database using adf?

Abhirup Saha 0 Reputation points
2023-04-19T17:59:23.1633333+00:00

I want to ingest an x12 formatted file using adf into databse.

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
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator
    2023-04-20T21:27:55.2833333+00:00

    HI @AbhirupSaha-5491 , Thanks for the question . Your ask motivated me to know more about the X12 file format . I did some reading from here At this time, I do not think that we do have any connector for X12 format. One thought which I had was using * as field/column separator but unfortunately this will not work out as its not same in all the lines. User's image

    Do you need to capture all the lines? Thanks Himanshu


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.