Flat File data Integration
A flat file is a collection of data stored in a two-dimensional database in which similar yet discrete strings of information are stored as records in a table.
Problem Statement:
Flat file data to be fetched from a legacy system, and integrate it with the database data to add the quantity and weight details for success records if "wh_live_ind" == "Y" else write the details in Flat file format back to the legacy system.
Components Used:
➔ RAML : To design API and validate incoming data to API.
➔ MySQL Server DB
Sample Input File: (.dat format)
Sample Output File:
Error Data: (.dat format)
Success Data: (.xml format)
Architecture Diagram:
Sequence Diagram:
Input Flat File Schema:
1010BRU123456 12345 010050
Project Specification Document:
Project Document: