Copy tables

Four Stars

Copy tables

Hello,

 

I am a beginner, I would like to ask Talend Open Studio for ESB can achieve multi-table transmission?

For example, a database mysql based in more than one spread to another database, as Kettle copy tables function,

 

thanks.

Community Manager

Re: Copy tables

Hello
With Talend Open Studio for ESB, you need to create different subjob to map each tables, as the tables have different structure.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: Copy tables

Think you for your reply.

I think what I want to express the meaning did not express clearly.

If the two databases corresponding to the structure of the same table, how to import?

For example,suppose the source database has 100 tables, and they are the same structure, exported to the destination database.

Can I call this process to automatically create a model batch import?

Thanks.
One Star

Re: Copy tables

Hello sdwsy,

Can you please give more details on your requirement? How you will have 100 tables with same structure?

Four Stars

Re: Copy tables

thank you for your reply.
Here are two tables, their column attributes the same, such as table named table1 and table2,and they have the columns as id,name,address,but values are different.
I want to put these two tables from mysql to oracle.
I want to find a function similar to Kettle copy tables inside Talend because it's so convenient.
Thanks

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read