Pros and Cons of Flat File Integration
Flat file Integration
Standard Format for each of the document will be defined.
Standard Mapping between the document and the receiving sending application must be in place.
Whichever applications takes in or sends out this document must have developed a interface like API or a function to interact.
All such documents are placed in a defined repository where the APIs or equivalent will access and process.
Pros:
- Flat Files integrations are cheaper solution in terms of cost if the source and target systems are fixed.
- Low Cost Solution
- Quick to develop
Cons:
- Needs FTP Infrastructure and SQL Loader licenses and Programming skills