topic Re: HELP Variabilize ELT Component and Context in Talend Studio

HELP Variabilize ELT Component and Context

gimgi69 — Fri, 15 Nov 2024 21:43:38 GMT

Hi !

I'm working on TOS 8.0.

Due to the large volume of data in my project (more than 60billion lines), I need to use ELT Component.

My goal is to import data from a Progress DB (connected in JDBC) then transform it then export into a Postgre DB.

BUT I need to load my context from the outside (I can't use the referential because I switch between different final DB).

Until now, I load my contexts within a tDBConnection and I use this existing connection in my components.

BUT with the tELTPostgresqlInput I don't have the possibility to choose an existing connection.

When I put context.schemaname it's not working --> it's working well when I write the schema name but I don't want to hardcode

Thank you by advance for your help

Lord-Vader — Mon, 05 Jun 2023 13:16:58 GMT

Try to logrow your context variable to see if its getting read.

You can make your job run after the context was loaded too.

Vader out💪.

Anonymous — Mon, 05 Jun 2023 14:01:29 GMT

Try to do:

"" + context.something +""

and see if this works

gimgi69 — Mon, 05 Jun 2023 14:31:52 GMT

No I already tried and it's not working.. I also tried juste with "context.PostgresClient_Schema" but it isn't working

gimgi69 — Mon, 05 Jun 2023 14:32:45 GMT

I don't understand where I put the tLogRow ?

This component isn't working with ELT components

Anonymous — Mon, 05 Jun 2023 15:18:52 GMT

What if you add ( ) around your input?

I remember I was able to add a full select * query there but I can't find the job where I did it.

I know that studio does some sanitization there so we might need to be creative to bypass that