Total Submissions : 4

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