You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Consolidate two mysql databases into a new output database
#1 2012-04-12 10:13:54
- Michael_H
- New member
- Registered: 2012-04-12
- Posts: 2
Consolidate two mysql databases into a new output database
Hi all
I'm trying to consolidate two mysql tables from different databases into one new output database with Talend Open Studio. I've tried different ways (tmap, tjoin etc.) to solve this, but it don't bring it to work.
For example:
Source-DB1
iD_us Name Firstname
1 Müller Michael
Source-DB2
iD_ch Name Vorname
1 Smith Peter
Result should be as following:
Target-DB1
iD Name Firstname
1 Müller Michael
2 Smith Peter
Could you please help me how I could do this?
Thank you very much in advance.
Offline
#3 2012-04-12 10:21:20
- Michael_H
- New member
- Registered: 2012-04-12
- Posts: 2
Re: Consolidate two mysql databases into a new output database
Hi Petro
Thank you very much for your quick response. I will try it with the tUnite componente.
Do you know if there is a tutorial or some other examples, documentations etc. available about the tUnite component?
Best regards,
Michael
Offline
#4 2012-04-12 10:24:44
- pedro
- Member
- Registered: 2011-11-17
- Posts: 3682
Re: Consolidate two mysql databases into a new output database
Hi Micheal
The document [TalendOpenStudio_Components_RG_50b_EN] will show you instructions and scenarios about the tUnite component.
You can download it here.
Regards,
Pedro
Only Paranoid Survive.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Consolidate two mysql databases into a new output database