topic Replicate database table along with table definition in Talend Studio

Replicate database table along with table definition

yoxler — Thu, 28 Feb 2019 12:42:01 GMT

We want to replace an old load logic in our data warehouse.

Current logic loads all data into staging in the data warehous along with new table definition. So if a column increases or a data type changes that is automatically fixed in the staging area.

The load come from an Oracle and the destination is a MSSQL Server.

is it possible to pick upp the table definition from Oracle and create a table in MSSQL? Once that is done the load can start.

Thanks

Andreas

Re: Replicate database table along with table definition

akumar2301 — Thu, 28 Feb 2019 13:18:18 GMT

For dynamic load transfer you could use dynamic schema

e.g.

http://jilanisyed786.blogspot.com/2017/10/dynamic-schema-load-in-talend.html

In Oracle you have table called user_tab_cols which has basic table definition. You could use to read these and create table statement for your sql server

Re: Replicate database table along with table definition

yoxler — Fri, 01 Mar 2019 06:49:41 GMT

Thanks!

Will try it out next week and see if I can make it work.

Regards

Andreas