I am using php to refresh oracle data to a mysql database, that part is fairly smooth. I need a way to run this code every 15 minutes. I do not have to have the refresh run on a website, and would prefer to do this through an application (ex. Java). Does anyone know the best way, or best programming language to do the following that could be automated?
Currently I query an Oracle database, send info to Mysql database (currently using php via an intranet website to send to txt file, then using DATA FILE INLOAD to write to mysql.