I have a Desktop system that every 1 hour makes a query in the database and generates a .xml file and a javaWeb system that reads this .xml . I developed this solution because the company I work with has some security rules where a system that will be on the Internet is not allowed to access the database directly. But when I do deploy of that system in the cloud it will have to connect with the company server so that it can read .xml and that would not be safe either.
The first alternative is to have my desktop system manage these files within a FTP server on which the web system has a connection and can read those files.
But I have been wondering if it would be more feasible to use the WebService concept to solve this problem, and if I created a local system that queries and my system that will be in the cloud consumed the data?
Which of the following seems to be the most viable and safe?