topic Re: How to get dynamic schema for queries in Talend Studio

How to get dynamic schema for queries

Anonymous — Sat, 16 Nov 2024 07:19:47 GMT

Hi,

I have a file where it has list of queries that generate different schemas. I would like to iterate this file and execute each query and write to excel file. Schema for each query has to be generated dynamically.

tFileInputExcel-->tFlowTolerate-->iterate-->tDBInput-->tfileOutputExcel

Can any one help me out?

Thanks in advance,

Meghana.

Re: How to get dynamic schema for queries

root — Fri, 09 Nov 2018 10:42:23 GMT

What do you need to write back to the excel file?

You can use this component to execute the statements on a db.

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F565&pi=marketplace%252F1%252Fproducts%252F565%252Fitems%252F845

HTH

Re: How to get dynamic schema for queries

Anonymous — Fri, 09 Nov 2018 10:47:20 GMT

I am using input excel to read list of queries to execute and the output excel is to store the result of each query.

Re: How to get dynamic schema for queries

root — Fri, 09 Nov 2018 11:18:02 GMT

Kool. The component I shared with an help execute your listed queries

Re: How to get dynamic schema for queries

Anonymous — Mon, 12 Nov 2018 05:15:29 GMT

I cannot see tSQLScriptParser

Re: How to get dynamic schema for queries

root — Mon, 12 Nov 2018 15:29:56 GMT

Its supposed to be downloaded from the Talend MarketPlace. I use this daily.

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F565&pi=marketplace%252F1%252Fproducts%252F565%252Fitems%252F845