Looking for an FTP and file parser application

Question

Our team has been tasked to create an application that can download a bunch of client files on schedule, parse the file content and upload the content to a database (into a set of tables). I am sure a lot of applications/teams have this need.

Is there an open source application (desktop or web based) that we can use to accomplish this task? We can create this application ourselves but are trying not to reinvent the wheel.

TIA rams

Answer 1

Wouldn't this be a task for perl or python glue? At least in the perl world there's lots of modules supporting FTP and DBI, and the language was basically made to parse files...

Answer 2

Take a look at Mule. It's quite a bit larger in scope than what you've aked for, but Mule should certainly be able to do this kind of task.