Connecting to external sql database using UCCX Script Editor

[Mariela Montero]

Hello;

I am trying to write some data in external database from CCX script (UCCX 10.1), but DB Write step. I am using correct SQL syntax. I have checked it through MS SQL Management studio and everything works.  Another weird thing is that making test from "DB Write" step properties shows "Rows altered 1 or 2  but it really does not change anything on the database.  Also, what is the best way to use the DB write step?

Thanks,

Mariela

[cristian.campos]

Hi Mariela

To connect an external DB, you need :

1.- Install a  JDBC driver. (subsystem>Database>Drivers).

2.- Connects  to a external DB, add new DataSource and verified test connection (subsystem>Database>DataSource).

3.- Then you can use , DB Read, DB Get, DB Write.

To DB write select a database, enter SQL insert, update o delete statements.

e.g.

insert into TBL_IVR_OPERATION (ID,COD_OSIN,CLAVE_OSIN,FUNCION) values ($prID,$prUserID,$prPassword,'validaracceso').

Regards.

[Gergely Szabo]

Hi,

"test" is test, so it's not supposed to change anything, it just validates your SQL syntax.

The best way to use it is to make sure you have a DB Release step in your script as well, in order to free resources.

G.