How can i get db_cra from my uccx 8.5.1 (Historical Reporting) ??

[Vinod Kembhavi]

Hi,

I am migrating from IPCX 4.1 to 8.5.1. Successfully ported all scripts, applications, etc.

For historical reporting purpose, In old system, we used run sql backup to take the db_cra from production server to a processing server. From this processing server, seperate application/scripts (SQL) are used to extract and report the data as per end users requirement.

I have following queries w.r.t. uccx 8.5.1

1. How can I take out db_cra from uccx box to another server (in database format) ?

2. Is there any command available (cli) to make it in sql format ?

3. Any third party tool/appliation available for this ?

Thanks,

Vinod

[Ronald Reif]

Vinod,

Yes there is a 3rd party solution for you.  My company has been enhancing the reporting aspects of the UCCX since v3.5.

Please let me know if you would like to discuss the value we bring in historical reporting with easy customization of reports as well as current status views to better manage the call center.

Ron Reif

SMSI

rreif@smsi.com

651-635-2822

[Vinod Kembhavi]

Hi Ron,

Thanks for your response...

We are already using reporting tool with old UCCX 4.1 which based on SQL database, we just want to know how we can take out db_cra from UCCX8.5.1 which is based on Informix database?

is there any cli command or user which will have access to db_cra database?

Thanks,

Vinod

[Aaron Harrison]

Hi Vinod

Basically you can access Informix via ODBC - it's intended to allow you to develop custom reports etc, and you don't get full DB access.

Details of the ODBC settings are here :

https://supportforums.cisco.com/thread/2134968

I'm also from an MS background, so when using the UCCX/Informix system it seems more difficult as you no longer get all the MS SQL tools for doing things like exporting data.

I believe the only method to export the data from Informix is to basically 'select' out the tables you want. It would be nice to have some sort of export capability built in that ensured you get all the data without duplicates etc but I don't think that functionality exists.

Hopefully Jonathan or someone will have some more advice for you...

[Joseph Chirayath · Accepted solution]

Hi Aaron,

I am trying for a similar solution. I downloaded SQuirreL SQL client version 3.4.0. I installed the JDBC drivers on them and used the following URL to access the db_cra -

jdbc:informix-sqli://X.X.X.X:1443/db_cra:INFORMIXSERVER=ipccx001_uccx

X.X.X.X being the IP address of my primary UCCX server 8.5.

The drivers were successfully installed and I can see the blue check mark against it. Moving forward I created Alias with the same URL and driver. The username I used is uccxhruser followed by the password.

Unfortunately, when I try to connect I get the following error -

Unexpected Error occurred attempting to open an SQL connection.

Is there any extra configuration that needs to be checked?

Thank you.

Joseph Chirayath.

[Aaron Harrison · Accepted solution]

Hi Joseph

Your port number should be 1504, 1443.

Aaron

[Joseph Chirayath]

Hi Aaron,

I tried port 1504 and 1443. I was able to open a session using 1504.

Thank you so much for your support.

Regards,

Joseph Chirayath