I'm looking for a Python (scripting) based ETL (Extract - Transform - Load ) package. There seems to be a few options available and I'm looking for something fairly stable and which can support the tasks:
Read xml files
read through ftp connection, with authentication
read through web service, with authentication
write to postgresql
Scheduled to run daily on windows server
Looking forward to your advice!