UCCX DB integration

[alexgrinberg]

hello,

I am working on the UCCX 11 SQL DB integration. 

I completed the connection to DB, and connected successfully.

next I tested connection with DB read and used the stored procedure and test was successful. I got 1 filed return.

But for DB get step I don't know if I can use stored procedure. How can I add stored procedure here? any suggestions?

Thank you

[Deepak Rawat]

Refer to below post:

https://supportforums.cisco.com/discussion/12931401/fetch-customer-name-sql-database

Regards

Deepak

[alexgrinberg]

Hi Deepak,

Thank you for your response. But in the post that you provided is nothing about  stored procedure.

Just about regular tables in database. My question is how to use stored procedure in the DB get step.

Thank you

[Deepak Rawat · Accepted solution]

Alex, please note that it is not possible to use/query Stored Procedure using DB steps in the script. If you want to do this then you will need to use some third party app like Squirrel or Razor and then establish a connection to the db_cra using uccxhruser and then do it that way.

Regards

Deepak

[alexgrinberg]

Thank you Deepak