Sybase & Oracle

nivek on 2001-09-13T04:02:13

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!