topic Re: Talend Open Studio -Create or replace the row1 schema in runtime in Talend Studio

Talend Open Studio -Create or replace the row1 schema in runtime

Anonymous — Wed, 05 Sep 2018 03:20:49 GMT

Hi,

I'm using Talend Open Studio 7.0.1

I'm trying to create or change the schema of 'tDBInput' at the runtime with the help of global variables or context variables.

Is this possible in community edition?

Though not a straight solution but any workaround also would help.

Thanks

Deepa

Re: Talend Open Studio -Create or replace the row1 schema in runtime

Anonymous — Wed, 05 Sep 2018 06:48:01 GMT

I'm trying to iterate the tables in a database and copy data to another table in different DB with same structure as source table.
I have one 'tFlowToIterate' which iterates and gives source_table,destination_table and columns as global variables, 'tDBInput' consumes the source_table and columns. 'tDBOutput' consumes the destination_table variable and inserts data respectively.

Re: Talend Open Studio -Create or replace the row1 schema in runtime

Anonymous — Fri, 07 Sep 2018 08:35:36 GMT

HI Deepa,

At present, the schema for the DBInput or Output have to be defined while table creation. But another opportunity is to use Talend Component Kit to create a custom component for your use case.

https://help.talend.com/reader/q9sIDoqWg3R5cxZE38OKrQ/BiTmgCx_O7lH_OpFspAdrw

Warm Regards,

Nikhil Thampi