topic Re: [resolved] Dynamic table name for tPostgresSQL in Talend Studio

[resolved] Dynamic table name for tPostgresSQL

Anonymous — Mon, 13 Mar 2017 13:25:59 GMT

Hello all,
I would like to migrate all my ETL jobs from pentaho to talend. The job schema is described below.
tMongoDBInput-->row1(Main)-->tSetGlobalVar-->row2(Main)--> tPostgresSQL
In the tSetGlobaVar component I used as key "tbn" and value row1.id. The Postgres output table name have the following value: (String)globalMap.get("tbn").
When I run the migration the table name is always null and I am not able to pass the current value from the global variable.
Below my transformation schema.

Could someone give me a hand of this?
Thank you in advance.

Re: [resolved] Dynamic table name for tPostgresSQL

Anonymous — Mon, 13 Mar 2017 20:39:23 GMT

This approach cannot work because the tPostgresqlOutput components setup there SQL statements just before the flow starts - also before you get your table name from tSetGlobalVar.
You could use tPostgresqlRow component, this component creates the statements within the flow.

Re: [resolved] Dynamic table name for tPostgresSQL

vapukov — Mon, 13 Mar 2017 21:49:31 GMT

Other possible way - make 2 steps Job
[list=1]

prepare list of tables

iterate thru list of tables

Re: [resolved] Dynamic table name for tPostgresSQL

Anonymous — Tue, 14 Mar 2017 11:38:51 GMT

Hello all,
I've used the solution proposed by jlolling. It works perfect. Regards the other solution I could not prepare the ids because are dynamic in each document comping from mongo.

Thank you very much,
Jaume