JDBC Connector, SQL Query and available variables

Q&A
1

Hello

I can use simple variables in my SQL queries inside JDBC connectors using ${ varname }.
Are complex variables available? Like objects from the BDM or java.util.List?

Is the SQL Query a velocity template or a groovy GString interpolation?

Thanks

2

Use the ecpression builder instead of the simple construct to use complex variables,

Much, much easier…

regards
Seán

PS: If this reply answers your question, please mark a resolved.

3

The expression builder is indeed a good solution for non-community editions. I solved my problem switching to a Groovy script returning the SQL statement which gives me all the flexibility I needed. Thanks for your answer.

4

It also works extremely well for Community editions… :slight_smile:

regards
Seán

5

I have both community and performance and I did not find the expression builder on the community edition (7.2)

6

Yep, it’s still there…

In 7.2.1 add SQL connector then when you get to enter query click the Switch Editor link…it changes the editor allowing the groovy editor…

regards

7

That’s what I did. I thought you were talking of the graphical query builder