How can I use tSQLTemplate component?

gko1610709171 — Sat, 16 Nov 2024 00:49:15 GMT

Hi. I`m a new in Talend.

Making a new development format with Talend, I have a trouble with common SQL.

I`d like to make common SQL to get common value each job and tried below.

I chose tSQLTemplate to set SELECT SQL

but tSQLTemplateAggregate.

but I don`t know how I can use tSQLTemplate properly. Talend manual said just detail of component but usage.

Is there somebody who help me plaese?

like connection usage,

tDBConnection - tSQLTemplate - nextComponent(?)

Re: How can I use tSQLTemplate component?

Anonymous — Thu, 21 Jan 2021 09:49:12 GMT

Hello,

As a start component, tSQLTemplate component is used with other database components, especially the database connection and commit components.

Such as, tDBConnection -->OnSubjobOK--> tSQLTemplate_1 --> tDBClose

Best regards

Sabrina