How to extract UCCX call data into SQL?

[aalbrecht27]

I'm trying to find a way to extract the UCCX call statistic data into SQL for a project my manager is working on with aggregating all of our organization's reporting data.

Is this possible, and if so, what is the best way to pull the data?  I know UCCX has a built in reporting tool, but the data needs to be imported into a SQL database for it to be usable for my managers project.

I'm really not a database guy so I don't really know where to start with this.

[Deepak Rawat]

It is possible to connect to the UCCX db_cra database and then look for all the tables containing historical data and use them for Custom Reporting.

For this, you will need to use the "uccxhruser" username. Password for this user can be set fro UCCX >> Tools >> Password Management and you can then create your own stored procedure using third-party tools such as SQuirrel SQL Client and AGS Server Studio. More details below:

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_11_5/reference/guide/uccx_b_uccx-report-developer-guide_new/uccx_b_uccx-report-developer-guide_new_chapter_010.html#UCCX_TK_CA87049C_00

You can also refer to below link in order to set this up using Squirrel client. Though the post is for 8.0 and 8.5 but the process remains same pretty much for the later UCCX versions as well:

https://supportforums.cisco.com/document/64301/squirrel-sql-client-setuppdf

Regards

Deepak