Dynamic read schema from MSSQL database

Highlighted
Six Stars

Dynamic read schema from MSSQL database

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?

Forteen Stars

Re: Dynamic read schema from MSSQL database

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: Dynamic read schema from MSSQL database

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.

Six Stars

Re: Dynamic read schema from MSSQL database

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog