Replicate database table along with table definition

Six Stars

Replicate database table along with table definition

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

Eleven Stars

Re: Replicate database table along with table definition

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 

 

 

Regards
Abhishek KUMAR
Six Stars

Re: Replicate database table along with table definition

Thanks!

 

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

 

Regards

Andreas

 

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 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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog