[cisco-voip] Exporting CCX historical reports to SQL Server 08 Express

[Ed Leatherman]

Hi folks,

Looking for some advice on exporting UCCX data to an external server
.. hopefully someone else has been down this road before.

I have UCCX 7 w/SQL Server 2000 installed, and I have a SQL 2008
Express server ("data warehouse") that I would like to export
historical reporting data. We have multiple customers that would like
to do some custom reporting development - would much rather they
thrashed around on a separate system than on the production contact
center.

I have successfully exported the relevant tables and stored procs
manually, and used this to build a DTS package so that this operation
can be scheduled to run nightly. Running the package manually also
works fine. The developers can hit the data warehouse server and do
what they need to do just fine. At this time though, I have to
manually push the data over to it every morning.

I am having trouble figuring out how to get this to work as a
scheduled job, as the SQL Agent service runs as the "CRSAdministrator"
account, and when it runs my DTS package it tries to use this account
to access the data warehouse server. Since I don't know the password
for CRSAdministrator, I can't set up a duplicate account on the data
warehouse for this to work. Am I missing something? I can change the
account SQL Agent runs as, but this will also change the account the
other CRS jobs are run as, which I'm going to assume is a big no-no.

The only option I see is to use the admin tool to change the password
for CRSAdministrator.. something I am loathe to do if there is any
other better options. Has anyone else used an external reporting
server, and if so how did you schedule nightly updates?

Have a great weekend!

-- 
Ed Leatherman