How to create a complex SQL query with multiple database connections

[Eva_Hamel]

Hi everyone,

I'm looking for a way to create complex SQL queries in Talend.

Those queries have to connect to multiple schemas in order to join a table from a schema to another table in another schema.

I know I can do that with Tmap, but the problem is that I have a huge amount of data, and complex WHERE conditions too, so if the Tmap try to operate them it'll be in Java code and the performances will be degraded way too much.

Though, as far as I understand, the component tOracleInput can use only one connection at a time, is that correct ? If that is, is there any alternatives ?

Regards,

Eva

[Eva_Hamel]

Ideally, I would like a component able to create very complex SQL queries (with sub-request, group, joins etc...) with a graphical mode. Is such a component exist? Maybe a third component I could use?

Eva

[bob_lemley]

Did you ever get a solution?