cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
328
Views
0
Helpful
5
Replies
Highlighted
Beginner

UCCX 7 and SQL View

Does UCCX7 support SQL Views instead or a table? I see under the DB READ step that I can see all the available Views for the user but I'm getting a SQL connection error when I run reactive debugging. My SQL statement returns 1 row so I know the statement is accurate.

5 REPLIES 5
Highlighted
VIP Mentor

Re: UCCX 7 and SQL View

Yes, it does support Views.  In fact, using a view is a valid way around the current limitation of not being able to read records from different tables in one SQL statement.

i.e., This wont work in the editor:


SELECT a.name, b.age FROM people AS a, birthdays AS b WHERE a.name = 'Anthony'

Message was edited by: Anthony Holloway - Wow this forum software really upsets me.

Highlighted

Hi Anthony,

Hi Anthony,

can you please tell me, how to edit the jdbc driver URL in case I use a db view?

My customer gave me access to a view and I can't setup a successful db connection.

Many thanks in advance!

Best regards,

Michael

p.s.: In the meantime we're using Rel. 10.6 :- ))

Highlighted
VIP Mentor

I'm sorry, but I don't know

I'm sorry, but I don't know the answer.  I would ask that you post this question in your own topic thread for wider visibility and help.

Highlighted
Cisco Employee

Are you following the

Are you following the instructions mentioned in the below Admin Guide to setup DSN connection:

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_10_6/config/guide/UCCX_BK_CEC562D1_00_cisco-unified-ccx-administration-guide106.html

BTW which DB server are you using, make sure it is one of the supported one as mentioned in the below Compatibility Matrix:

http://docwiki.cisco.com/wiki/Unified_CCX_Software_Compatibility_Matrix_for_10.6(x)_and_Service_Releases

Regards

Deepak

Highlighted
Advocate

Hi,

Hi,

what is the error message you are getting?

Are you able to create the JDBC connection or does it fail, too?

G.