topic Re: Can we import a complete database from MYSQL DB to oracle DB in Talend Studio

Can we import a complete database from MYSQL DB to oracle DB

_AnonymousUser — Sat, 16 Nov 2024 12:06:55 GMT

Hi,
I have a mysql database with 40 tables. Is there a way to import all the tables from this DB into an oracle DB using a single job.
I know i can create a tMySqlInput to import each table (doing it for 40 tables), but is there a way import the complete DB in one go to oracle.
I using talend open studio 5.2.0
Thanks
Prash

Re: Can we import a complete database from MYSQL DB to oracle DB

Anonymous — Thu, 24 Jan 2013 02:45:54 GMT

Hi,
For community version, you have to create different jobs for mapping each table.
For enteprise version, you can create only one simple job for all table thanks to the dynamic schema feature, see
https://help.talend.com/pages/viewpage.action?pageId=5671283
However, dynamic schema feature is only available in Talend Enterprise Data Integration.
Best regards
Sabrina

Re: Can we import a complete database from MYSQL DB to oracle DB

_AnonymousUser — Wed, 30 Jan 2013 09:53:40 GMT

Hi,
You can use this component tTransferDatabase.
best regards

Re: Can we import a complete database from MYSQL DB to oracle DB

_AnonymousUser — Wed, 30 Jan 2013 09:57:15 GMT

Sorry,
You can download this componant here
http://www.talendforge.org/exchange/index.php?eid=457&product=tos&action=view

Re: Can we import a complete database from MYSQL DB to oracle DB

Anonymous — Wed, 30 Jan 2013 10:13:47 GMT

Hi,

You can use this component tTransferDatabase.

Because tTransferDatabase is a custom component, we provide you with the KB article Installing a custom componenton Talend Help Center.
Hope it will help you.
Best regards
Sabrina

Re: Can we import a complete database from MYSQL DB to oracle DB

emdelvis — Tue, 06 Sep 2016 10:35:30 GMT

Hi xdshi with the component tTransferDatabase is possible select only the tables that i want transfer ?
Thanks in advance

Re: Can we import a complete database from MYSQL DB to oracle DB

Anonymous — Thu, 08 Sep 2016 10:02:57 GMT

Hi,
Actually, tTransferDatabase is a custom component written by talend community user and shared on talend exchange.
Feel free to contact the author directly.
Best regards
Sabrina