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.
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.
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!
p.s.: In the meantime we're using Rel. 10.6 :- ))
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.
Are you following the instructions mentioned in the below Admin Guide to setup DSN connection:
BTW which DB server are you using, make sure it is one of the supported one as mentioned in the below Compatibility Matrix: