06-01-2010 01:41 PM - edited 03-14-2019 05:49 AM
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.
06-02-2010 01:56 PM
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.
01-27-2016 08:01 AM
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 :- ))
01-27-2016 08:16 AM
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.
01-27-2016 08:39 AM
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
01-27-2016 08:45 AM
Hi,
what is the error message you are getting?
Are you able to create the JDBC connection or does it fail, too?
G.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide