<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:0in;
line-height:115%;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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.<o:p></o:p></p><p class=MsoNormal>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. <o:p></o:p></p><p class=MsoNormal>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?<o:p></o:p></p><p class=MsoNormal>Has anyone setup a SQL job to copy the db_cra to another server to report from? <o:p></o:p></p><p class=MsoNormal>The current db_cra database is around 10 gig in size.<o:p></o:p></p><p class=MsoNormal>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?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>