topic Re: Anyone has experience with tTransferDatabase (custom component) ? in Talend Studio

Anyone has experience with tTransferDatabase (custom component) ?

Anonymous — Sat, 16 Nov 2024 06:18:57 GMT

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,

Re: Anyone has experience with tTransferDatabase (custom component) ?

DataTeam1 — Fri, 15 Mar 2019 18:17:40 GMT

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

Re: Anyone has experience with tTransferDatabase (custom component) ?

Anonymous — Fri, 15 Mar 2019 18:23:31 GMT

@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

Re: Anyone has experience with tTransferDatabase (custom component) ?

Anonymous — Fri, 15 Mar 2019 18:31:21 GMT

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?

Re: Anyone has experience with tTransferDatabase (custom component) ?

DataTeam1 — Fri, 15 Mar 2019 18:54:03 GMT

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