Heya folks,

I'm looking for a way to grab all the data from a database (running on an
ACD call center) into a mysql or postgres database running on a linux
system.  The call center system is network attached, and it can be
accessed via ODBC.

Here's the scenario...

The call center system is slow.  It stores all of its logs/call-detail
stuff in an SQL database, and it takes about 20 seconds to do a pretty
simple query, hence the desire to pull all the data into a different
database running on a dedicated system.

The goal is to grab the data files every night and import them into mysql 
or postgres, and then build a web interface with Zope so that the PHBs can
view their reports via the intranet.  Some of them like to grab the report
and import it into excel so they can further customize their reports
themselves for their records.  To support that, I'm thinking about
generating a tab delimited text file for each report every night that they
can download.  The formating will be atrocious, but they will be able to
get their raw numbers without trying to cut/paste an html document into
excel.

The web interface also lets us build some predefined queries with some
variables that some of the PHBs have been asking us for, giving them a
little more control over the reports that they get.  Hopefully if I can
make this work the way I want it to we won't need to spend our time doing
custom reports whenever they want to see something specific that the
generic reports don't show very well.

Anyway, I know how to do everything except sucking the data out of the
call center in one big chunk and importing it into mysql or postgres.
I'm thinking I could write something in python to do a query on the call
center (select everything from each table) and import the results of the
query into the appropriate table in mysql, but my python skills aren't
stellar just yet so I'm hoping there's an easier and more direct way that
I've overlooked.

The data files total about 750 megs on the call center, so I want to grab
all the data once, and then every night grab the previous days data.

Thanks,

Jeff