UCCX & Power BI

[mightyking]

Hello Everyone,

Has anyone done UCCX and Power BI integration? If so, could you please share or send me some documentations that I can use to complete the integration?

Thanks,

MK

[david.macias]

What I've seen done is to move the data to a central location and then do the analytics from there. Hitting UCCX directly is not going to scale very well. I recommend you do the same thing.

david

[mightyking]

Thanks David,

Would you happen to have any documentation supporting the solution?

MK

[david.macias]

No I don't. I've seen it pretty much done by hand. Pick out the tables you want to push out and just ETL them out. Look at the CUIC documentation to get an idea of the tables you will want to tap into.

david

[mightyking]

Thanks David, I will wait to see if someone who has done it before replies with the instructions.

MK

[rikardkrvaric]

So, MK, You're looking/waiting for instructions on how to copy/export data from UCCX to SQL server, now then?

I'd like to see this data/instructions too...

[mightyking]

I have found the following document but not sure if it's helping.

Creating ODBC connection with UCCX – CCX Stuff (wordpress.com)

Let me know if you can make it work.

Thanks,

MK

[cdrguru]

Metropolis here! We manufacture a product called QBI for UCCX that integrates with Power BI. Our integration includes comprehensive documentation to help you complete the integration process. In addition, we also have integrations for Power BI for WebEx and Cisco UCM.  Let me know if there is anything I can do to help.

Please reach out to us directly at metropolis.com , and we will be happy to assist you with the integration process and provide you with the necessary documentation.

[Markus Welscher]

Hi there, 

so this is already an old post, but maybe someone still finds this Information useful.
So I just spent a week building Power BI Dataflow Report for UCCX and building an adaptive Report that works for every application/CSQ. But here I am only gonna go through the rough steps:

So first thing that you want to get is a 64 Bit Informix ODBC Driver, this is honestly the most difficult part because of IBMs Website Design. So you want to do those steps (I hope they still work by the time you are reading this):
- Go to this Link: https://www.ibm.com/support/pages/download-informix-products
- Then click on IBM Informix Client SDK downloads: https://www-01.ibm.com/marketing/iwm/iwm/web/pickUrxNew.do?source=ifxdl 
- Fill out the marketing survey
- Then you should have a list of downloads, I went with "Informix Client SDK 4.10.FC16 Windows 64 bit"
Then just simply install the driver on your On Prem Gateway Server for Power BI.

In the next step you need to configure the actual ODBC DSN Connection on said Server, for this you can use the following guide:
https://gaman-gt.com/articles/uccx_with_powerbi.html
In summary, in case the link doesn't work anymore: 
- Open "ODBC Data Sources (64-bit)"
- Go to "System DSN" and "Add.."
- Choose IBM Informix ODBC DRIVER
- Choose a Data Source Name (Remember the Name for later)
- Now in the Connection Tab you want to put in exactly what you can find in the "Cisco Unified Intelligence Center" -> "Configure" -> "Data Sources"
So the Schema is:
- "Server Name" = "Instance"
- "Host Name" = FQDN or IP of Reporting Node
- Service = 1504
- Protocol = onsoctcp
- Database Name = "Database Name" 
- User ID and Password of User
Then click "Apply" first, then Test and you should get an Error "locale mismatch".  After this switch to "Environment" and change Client Locale to "en_US.UTF8" and then check "Use Server Database Locale". Now you can test again and it should work. It was a bit weird in my case, so you might just have to refill and retry a few times.

Now we are done with the annoying setup. Now simply head into your Power BI Dataset/Dataflow and choose the connector "Odbc", the Connection String will be "dsn=" and then the Data Source Name you picked before, and of course as Gateway you need to choose the server we just set up.

Now thanks to the 64 ODBC Driver you should get a list of all available tables. For the actual reporting part this document will be your best friend 
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
But I think the rest you can do without a Step for Step Instruction ;).
Don't hesitate to contact me if someone is ever reading this and needs some assistance. No super expert in all of this, but I got mine to work so that must count for something.

Markus 

[mpirrone]

Thank you for sharing this. Very helpful