UCCX Wallboard Development Part 2

Well i guess i better share my finding and research with you guys as promised.

I am going to take this from the beginning so for the more advanced guys out there please stay with me.

Setting up the Data Connection

first thing we need to do is get a connection between the web server and the Cisco Contact Centre Express server, additional information can be found in the historical reporting and admin guides if required.
This is a little different depending on what web server you are using but i am sure it wont be too hard to spot the differences.
I will be using a 2008 web server so all screen shots will be from this OS. 1 small note before you get configuring as the Cisco Contact Centre Express solution is not a 64-bit application you need to make sure you use the 32 bit IBM Informix Drivers not the 64 bit drivers. if you do use the 64 bit drivers a nasty error will follow, so use the 32 bit drivers which i will give a link to later in this post.

Download and install the IBM Informix Drivers

To download the IBM Informix Driver go to the IBM site and go through a lot of pain to login and accept EULA’s etc. or simply download the 32bit 3.50 TC9 Server from here (This is 100MB+ so be patient).

Once downloaded then run through the install clicking next next next (Usual Windows Install)

                     

                     

                     

Now When you have nearly finished the install you need to make sure you install the Drivers package that comes with the SDK, click the link and click finish will launch it. Accept all the defaults.

 

                     

When you have completed this step then you are ready to setup the connection to the server.

Setting Password on the UCCX Servers

Before you can configure the ODBC Source you have to reset two password on the UCCX server. Login to the UCCX Admin and then go to Tools –> Password Management

Reset the Wallboard user and the Historical Reporting User password to anything you like we will use these later on. One thing to note here is do not use Special Characters like &!”$£ if you do you will break the Historical reporting tool. You have been warned !!!!

If you have a cluster make sure you do this on both nodes.

Setup ODBC Connection

Under admin tools on the web server launch the ODBC Connection Manager (ODBC Data Sources)
If you are using a 64bit OS for the wallboard server then you need to use the ODBC manager from the wow64 subsystem, if you don’t you will not see the INFORMIX Connections.

Under the System DSN add a New DSN

Select the IBM Informix ODBC Driver ( I know ODBC is not the best thing in the world for all you budding developers out there but it works well and with a wallboard you need stability)

Give the data source a name and description this can be anything you like.

Now it comes to the Connection setup, In the server name you need to add the name of the uccx server generally in lower case with the post fix of _uccx after it. The host name is simply the ip address of the uccx server.

Set the following options

• Server Name = Name of Server with the _uccx extension (If you have – in server name use _ instead)
• Host Name = This is the IP Address of the UCCX Server
• Service = Set this to 1504
• Protocol = The Protocol must be set to onsoctcp
• Options = Leave these blank
• Database Name = As before is db_cra
  • UserId = You can use Two Different Usernames here (WallboardUser and uccxhruser) if you use Wallboard user then you do not get access to agent state information so for our purposes use uccxhruser)

Password = this is the password you set earlier in this post.

Environment Settings

Set the Client and database settings to en_US.UTF8 to match the server. now your are done you should no click apply then under connection select Apply and test, this should come back saying successful of you get an error go back and try checking the settings again. Looking at the case of the server name is always a good place to start as Linux is case sensitive.

Wallboard Preview

Just to keep you guys watching i thought i would add a little teaser to this post and show you what i am trying to achieve with this series of posts.

Wallboard No Logo

Wallboard with Logo

Additional Boards

I am working on additional boards with graphs and nice SLA stats but you will have to wait and stay tuned to see these.

Until Next Time !!!