This project is to take the provided XML file and import all the data into a database in numerous tables. The program designed should be able to have an interval set to import such file every X seconds.
The XML file never changes in format, only the data. When a new file is found (different file name) new rows, etc.. should be created to keep the files separate. When the same name is found, the data should append.
The idea is we need to run Queries on the data from the imported XML.
The program can run on Windows or Linux, preferred Windows.
The XML files are uploaded to the server via FTP