HAL and Customers are maintaining separate RDBMS for various types of orders placed on HAL. There is a requirement of exchanging data between the two Databases. HAL & Customer network are Separate and the data in the form of CSV/ XML file will be uploaded on a separate server in a common template. The common template needs to be updated through CSV/ XML. A sample common Template for Customer Order is as follows:-
|Order No||Order Date||Part No.||Quantity||Cleared Date||Receipt Date|
|(a)||(b)||( c )||(d)||(e )||(f)|
Column (e) will be updated by HAL and column (f) by Customer. The data in the CSV/ XML file should be secure and cannot be modified in transit. Device a solution for securely achieving the Data exchange and update the common Template on a daily basis.
Sample Data Required: No