Along the way you're going to discover LWP::UserAgent, WWW::Mechanize, and a few others that facilitate scraping.

You'll probably end up using a module like Text::CSV. And for your XML... there are dozens of parsers on CPAN. But there's one that looks very useful for your situation: XML::EasySQL. I've got no experience with it, but if it works as advertised... *wow*!