topic Dynamic read schema from MSSQL database in Talend Studio

Dynamic read schema from MSSQL database

Anonymous — Fri, 23 Feb 2018 11:15:57 GMT

I'm trying to read 100 numbers of tables from MSSQL which having different schema.

And create accessDb files .accdb from that.

Is any one know how we can read all this tables dynamic?

manodwhb — Fri, 23 Feb 2018 12:58:08 GMT

If you are using enterprise edition u can find option as dynamic schema .By using it u can complete your job

Anonymous — Mon, 26 Feb 2018 10:48:18 GMT

Thanks for the reply,

But in the tAccessDBOutput, I'm getting that component does not support dynamic schema.

Is nay another method to write accessdb file from the dynamic data type.

Anonymous — Tue, 27 Feb 2018 08:12:24 GMT

tAccessDBOuput does not support dynamic schema so how I will write the data into the accessdb file dynamic.