How can I read a business pool variable inside a database conector?

Q&A
1

Hi experts,

In the script section of a Database Connector I can refer to local or contract variables like this:

${contractVariable} ${localVariable}

But… is it possible to read directly the value of a pool business variable?

Thanks,
Jose.

2

Hi,

Still not sure if it’s a bug or not. But a workaround is to switch to Groovy Editor instead of a SQL Editor in the Oracle connector. Then you have access to the BDM objects.

Cheers

3

Hi Jose,

Reads a bdm variable should not be different than reading a local variable.

Any chance you can share a sample process?

Cheers

4

Hi Lio, thanks for helping.

In the “Enter query or Batch Script” dialog of the DB Connector, if I press ctrl+space I get this:

[Image Link][https://josegante.tinytake.com/sf/NzU2NTMyXzM0NTIxODU]

Y can only select parameters or local variables, but no bdm variables.

Regards,
Jose.

5

Hi,

I have the same problem . I want to use BDM in the Body of the email connector .

Regards,
Yassine.

6

Hi Lio, thanks for help,

Can you please explain your workaround a bit more?

BR