<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:x="urn:schemas-microsoft-com:office:excel" 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;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.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>Just did our flash cut from CUCM 6.1.4, CER 2.0 and UCCX 7 to CUCM 9.1.2, CER 9.0 and UCCX 9.0 yesterday. Everything went flawlessly. Now we’re cleaning up the 3<sup>rd</sup> party stuff and licensing.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The biggest complaint is the gila-wallboard doesn’t work, and since Cisco hasn’t found a good realtime solution for how many calls are currently in queue, I need to get that back up.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>There’s extensive (41pages) comments on the forum about wallboards and such. From what I can gather, the Informix database should still be readable provided I install the IBM Informix drivers on the wallboard machine and get that going. Has anyone had experience with this? I’m following some online directions for getting the DSN up and it still won’t talk to UCCX 9.x.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Below is my post to the forum which should have additional info.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Happy Turkey Day to all!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Jon<o:p></o:p></p><p class=MsoNormal>-----------------------------------------------------------------------------------------------------------------------------<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p>I'm trying to integrate my GILA wallboard with 9.0 UCCX (worked in 7.0).<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>As i understand it from Anthony's post i need to get an ODBC link into the Informix database.<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>I've been using Monkey's post for my config on that:<o:p></o:p></p><p><a href="http://voipmonkeys.wordpress.com/2011/11/11/uccx-wallboard-development-part-2/">http://voipmonkeys.wordpress.com/2011/11/11/uccx-wallboard-development-part-2/</a><o:p></o:p></p><p>If i apply and test from the ODBC setup, i get "Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix]Cannot connect to database server (i10.20.18.20)"<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>I've set the passwords for uccxhruser and uccxwallboard in UCCX/Password Management.<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>In Realtime Snapshot Writing Config:<o:p></o:p></p><p>Data Writing Enable (Check)<o:p></o:p></p><p>Data Writing Interval (5sec)<o:p></o:p></p><p>Cisco Unified CCX CSQs Summary (Check)<o:p></o:p></p><p>Cisco Unified CCX System Sumary (Check)<o:p></o:p></p><p>Wallboard Server Name (IP of windows iis box being configured above)<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>Once I can get past step 3 (see below), i can try and figure out what step 4 means (no idea what to change on Gila-wallboard to use the DSN instead of the sql link)<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>Suggestions?<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>Jon<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>----------------------------------------------------------------------<o:p></o:p></p><p>Anthony's Post<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>You do not need to create a data source in UCCX 8.5.<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>The high level steps are:<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>1. Install the wallboard app on a windows web server running IIS<o:p></o:p></p><p>2. Install the Informix ODBC driver on your windows web server<o:p></o:p></p><p>3. Create a system DSN on your windows web server, pointing to the Informix database on UCCX<o:p></o:p></p><p>4. modify the connection string in the wallboard app to use the system DSN you created in step 3<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>The request connection should look like this:<o:p></o:p></p><p>User PC > [HTTP] > Web Server > [ODBC] > UCCX<o:p></o:p></p><p style='min-height: 8pt'> <o:p></o:p></p><p>And the response:<o:p></o:p></p><p>UCCX > [ODBC] > Web Server > [HTTP] > User PC<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>