uccx 11 DB Read step with no return values

[mbarekfadil]

Hello 

I wish to create IVR,  our customers will have to call a phone number, dial a pin code, when the client will authenticate, the UCCX must forword the call to an agent,  To do, I have to create a sql server 2012 table (Clients) with the following strings:

• AccountNo: the code that must be entered by the customer
• Last Name
• First Name
• Number: the number of its agent

 I tried set DB Read, uccx field selection numbers of rows returned 0

Thank you for your help.

[Anthony Holloway]

Do you have Premium licensing?

Do you already have a DB integration working on UCCX now? (I.e., Database Subsystem)

Do you need to have this in a DB?  Could you maybe hold it in a file in the document repository?

[mbarekfadil]

Hi Anthony
Yes, i have CCX Premium

This is the only DB that you want to integrate with SQL.
Indeed, we want to use a DB for our IVR.

Thank you for your feedback.

[Anthony Holloway]

Ok, excellent.

What are you typing in for the DB Resource Name?

Do you see your datasource in the drop down?

Have you clicked Refresh Database Schema?

Can you prove that your SQL query on the Field Selection tab actually returns records?

Is this your first DB integration with UCCX?

[mbarekfadil]

Hi,
Thank you for your feddback
The DB Resource Name: uccxdb

Yes i see my datasource in the drop down, i also have Refresh Database Schema.
At tab records, I have 0

This my first DB Sql 2012 integration with UCCX

Please see the screenshot configuration,

Thank you

[Anthony Holloway]

Things look pretty good.  Though I'm not a SQL expert.

Can you post the text you're using in the JDBC URL field on the web page?

[mbarekfadil]

thank you,

Below the url:

jdbc:jtds:sqlserver://10.240.120.223:1433;instanceName:MSSQLSERVER;databaseName:uccxdb;user=sa;password=DbP@ss2016

[Vuong Ngoc Trac]

I have the same problem too.

Any advice please?

[Vuong Ngoc Trac]

I figured it out, the problem is due to the SQL query on UCCX script.

Let say I have a database named Testdb with one table named Order.

I can execute the following query SELECT * from [dbo].[Order] successfully on SQL Management Studio but if I use the same query on UCCX script, SQL Server returns an incorrect query error.

The query used on UCCX Script should be SELECT * from [Testdb].[dbo].[Order]

[mbarekfadil]

Hello,
I think it's an ODBC pb:
1- open the Microsoft Windows ODBC Data Source Administrator
2- Select the System DSN tab and click on the Add ... button.
3- Select the SQL Server
4- Specify the data source name, description and the SQL Server instance name. Click Next to proceed.
5- Select the authentication mode as per the requirement. For SQL authentication, specify the SQL login name and password. Click Next to proceed.
6- Select the desired application from drop down list and click Next.
7- Click on Finish and test the data source connectivity.
In PJ my configuration, thank you to test and to keep me informed.