Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

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

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.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

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 :- ))

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.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
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

Hi,

Hi,

what is the error message you are getting?

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

G.

227
Views
0
Helpful
5
Replies
CreatePlease to create content