[cisco-voip] IPCC / UCCX custom reports and archiving database.

[Bill Riley]

Currently running IPCC 5.0 in HA deployment. We will upgrade to UCCX 7.0 in
the next 30 days and then upgrade to 8.0 30 days after that both in HA.

All of the reporting is currently being done using Crystal reports and not
the HR client. We changed the SQL authentication from Windows to mixed mode
authentication. During the upgrade I am going to change this back to Windows
only. I want to keep it at Windows only moving forward but I need to know
how to give the developers and about 30 end users that run reports access to
the database. What I want to do is copy the db_cra database to our primary
MSSQL server that houses several other custom databases used for reporting
and other process.  

What is everyone else doing for custom reports on the windows based UCCX
systems? Are you just changing it to mixed mode and letting the users run
the reports directly from the production database?

Has anyone setup a SQL job to copy the db_cra to another server to report
from? 

The current db_cra database is around 10 gig in size.

Does anyone have UCCX 8.0 in production? What are you doing for custom
reports? I see that you can create an ODBC connection to the Informix
database directly. Are you just using that ODBC connection to perform your
reporting?

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20101228/fbc2bafb/attachment.html>