topic Re: Dynamic source SQL query and dynamic mapping to tDBInput component in Talend Studio

Dynamic source SQL query and dynamic mapping to tDBInput component

Anonymous — Wed, 18 Mar 2020 17:19:47 GMT

Dear Experts,

Please advise your approach on the use case.

use case: build the SQL source query dynamically from csv file and apply dynamic schema for tDBInput component.

Metadata.csv: file contains

"column name", "column data type", "length", "table name", "where condition (optional)"

Note: the number of column might increase based on the business need.

Step1: i want to read the column details and table name from .csv file

Step2: build/form a sql query

Step3: generate the schema from the same

Step3: send query to tbDBInput component and map the schema

Thank in advance for all your advises.

I am using Talend Open Studio DI version 7.2

prithivt

manodwhb — Thu, 19 Mar 2020 03:52:41 GMT

With open studio,you will not have dynamic option to use dynamic schema.in enterprise edit only you will have dynamic option.

Anonymous — Thu, 19 Mar 2020 06:03:49 GMT

Is there any other way of workaround to achieve this like writing javacode? or ?