HELP Variabilize ELT Component and Context

[gimgi69]

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]

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]

Try to do:

"" + context.something +""

and see if this works

[gimgi69]

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

[gimgi69]

I don't understand where I put the tLogRow ?

This component isn't working with ELT components

[Anonymous]

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