Working on an interesting project at work at the moment. Have to collect data from a Sybase database sitting on a remote NT box and place it in an Oracle database residing on a remote Solaris box on a daily basis.
So its DBI, DBD::Sybase, DBD::Oracle to the fore!! Ok, so connecting to the Sybase database on the NT box from Solaris didn't go *exactly* as planned. But thanks to the folks at freetds that was resolved rather quickly.
Once the data resides in the Oracle database, have to create daily/monthly reports that get automatically e-mailed to various distro lists in various formats - tab delimited attachments, HTML email (I know HTML email is evil but that was one of the requirements for this project) and spreadsheets. So, using the rather fine Spreadsheet::WriteExcel module came in *very* handy. If you've never played with this module, you really should as it'd dead cool!
