Anyone has experience with tTransferDatabase (custom component) ?

[Anonymous]

I was asked to move 10 tables from Mysql database to Oracle.

I found this tTransferDatabase component and have it installed, but want to know more before I could use it to move tables between databases.

BTW, I am on Talend Open Studio 7.1.1

Anyone has used it?

Thanks,

TM

[DataTeam1]

Why do you want to use this component instead of standard tDBinput and tDBoutput components?

[Anonymous]

@DataTeam  i think @Moe  requirement is to move from mssql to oracle sql, that means from one kind of data base platofrom to another platform, i think he wanted to do with one component rather using mutliple components.

@Moe  this is the good question 

[Anonymous]

Well, maybe I shouldn't.

I am waiting for the PC support to install Mysql Workbench on my computer. Before that, I can't see these sources tables and it seems impossible for me to use tMysqlinput and tOracleoutput to accomplish the task -

I guess I will have to define the schema in both source and target.

I was curious about the tTransferDatabase component -- it doesn't ask for schema, so it will do the job without me giving any column information?

[DataTeam1 · Accepted solution]

@Moe you're right, you don't need to set the tables schemas but you also can't set which tables you want to transfer.

This component transfer whole database (all tables)

Source schema and destine schema are for seting databases schemas (i.e. dbo in MS SQL) not tables schemas.