Integrate Tableau app with CCX for reporting

[HusseinLTD]

hi, 

I have another team (Dev) trying to integrate their application (Tableau) with our UCCX to get access to the DB for reporting.

I provided for them the uccxhruser password but it wasn't enough, they need information about the DB, type, port...etc.

I couldn't find any information online about that.

i'm hopping I can find someone here already went through the same process and they know what we need to integrate Tableau with UCCX.

[rikardkrvaric · Accepted solution]

I also have a Tableau team in our organization - I'd love to send them this data.

The DB for UCCX is IBM Informix.

And here is a link to the database schema.
https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_11_6/reference/guide/UCCX_BK_CF9FAD2A_00_cisco-unified-ccx-database-schema/UCCX_BK_CF9FAD2A_00_cisco-unified-ccx-database-schema_chapter_00.html

[HusseinLTD]

Hi @rikardkrvaric 

thanks for the tip, I would love if you can provide a link to guide about the integration from Tableau side or Cisco side so I can understand what to provide to the team.

what's the port number that can be used to communicate with the DB?

are the usernames (uccxhruser & uccxwallboard) the same users to connect to the DB?

[Shalid Kurunnan Chalil · Accepted solution]

Hi , 

The port number to connect to the UCCX DB is 1504 

The different users and its purposes are outlined in one of the Cisco doc. please find it as below;

• uccxhruser - This user has select permissions to many configuration and historical tables in the UCCX database and should be used only for custom historical reporting and Cisco Unified Workforce Management (WFM). Queries and stored procedures executed by this user might perform complex, long running queries. Due to the profile of a typical historical reporting or WFM user, these queries and stored procedures should not be executed frequently as would occur for a wallboard application.
  
  Although many wallboard applications require data contained within the configuration and historical tables to which the uccxhruser has access, it is technically not supported to use this user to execute complex, frequent queries against the UCCXdatabase for the purposes of a wallboard application.
• uccxworkforce - The uccxworkforce user has access to the Team, Resource, and Supervisor tables and should be used for Cisco Unified Quality Management (QM). Workforce Management should use uccxhruser as it requires access to historical data tables that are not accessible by the uccxworkforce user.

• uccxwallboard - This user has select permissions only on the real-time database tables that contain snapshots of real-time statistics written from the UCCX Engine's memory. The select permissions restricted to tables RTCSQsSummary and RTICDStatistics mean the uccxwallboard user should be used to query the UCCX database frequently with simple, non-complex queries intended to be sourced by a wallboard application.

Regards,