topic Re: how to integrate many database (MYSQL) in one in Talend Studio

how to integrate many database (MYSQL) in one

_AnonymousUser — Mon, 13 Apr 2015 11:51:33 GMT

Hello everyone thanks in advance to everybody hwo will look at this post and will try to help me. I have many databases(MYSQL) in different systems in LAN and i need to integrate those in one (ouput in Mysql) to use in owncloud in WAN .Output database needs to be updated in both ways( owncloud --> databases,databases -->owncloud). To be honest with you i'm a beginner and i need your help.
Thanks again

Re: how to integrate many database (MYSQL) in one

Anonymous — Tue, 14 Apr 2015 04:43:42 GMT

Hi ALEXTT,
Do you want to extract data from your different Mysql tables and load them into one target DB table?

Output database needs to be updated in both ways( owncloud --> databases,databases -->owncloud).

Are you looking for DB synchronization? Have you checked talend feature about: TalendHelpCenter:CDC architectural overview?
You have a better chance if you describe your requirement better.

Best regards
Sabrina

Best regards
Sabrina

Re: how to integrate many database (MYSQL) in one

_AnonymousUser — Wed, 15 Apr 2015 10:13:55 GMT

Hi xdshi,
yes, that's what i mean , I want to exract data from many tables and load them into one taget DB table.I prepared a diagram which shows how the operation takes place and i hope it will descripes better.I am asking how will I do the transformation in talend open studio and if it is possible in first palce.
Thanks again

Re: how to integrate many database (MYSQL) in one

Anonymous — Wed, 15 Apr 2015 10:24:49 GMT

Hi ALEXTT,
Do you want to extract data from your different Mysql tables and load them into one target DB table?

Output database needs to be updated in both ways( owncloud --> databases,databases -->owncloud).

Are you looking for DB synchronization? Have you checked talend feature about: TalendHelpCenter:CDC+architectural+overview?
You have a better chance if you describe your requirement better.

Best regards
Sabrina

Best regards
Sabrina

Sorry,I have problem with the diagram upload
Hi xdshi,
yes, that's what i mean , I want to exract data from many tables and load them into one taget DB table.I prepared a diagram which shows how the operation takes place and i hope it will descripes better.I am asking how will I do the transformation in talend open studio and if it is possible in first palce.
Thanks again

Re: how to integrate many database (MYSQL) in one

Anonymous — Wed, 15 Apr 2015 10:38:45 GMT

Hi,
Firstly, you can use tMysqlInput component to extract tables from your servers and loading them into one target DB table.
You input tables are same structure?(Id, Name...)
The workflow should be:
tmysqlinput(server1)---> you can make some tranformation in this step(date type conversion, column name change....)-->tmysqlout
tmysqlinput(server2)-->
Secondly, for your requirment of synchronization between DB and cloud, what's your own cloud? Amazon?
Best regards
Sabrina

Re: how to integrate many database (MYSQL) in one

Anonymous — Thu, 16 Apr 2015 10:49:16 GMT

Hi,
Our tables have the same structure and i don’t have any modification to add in the transformation.Can you please give me an example in talend what component i need exactely to use because i ‘am beginner.In database synchronization, i ‘am using own cloud and synchronization will be manually by the cloud administrator.

Re: how to integrate many database (MYSQL) in one

Anonymous — Thu, 16 Apr 2015 11:07:36 GMT

Hi,
You can use tMySqlXXX components to achieve your goal.
Please take a look at component references about:TalendHelpCenter:tMysqlInput and TalendHelpCenter:tMysqlOutput.
Best regards
Sabrina

Re: how to integrate many database (MYSQL) in one

Anonymous — Thu, 16 Apr 2015 13:39:23 GMT

Hi,
how can i SELECT all tables from database using mysqlinput ?
Thank you for your help

Re: how to integrate many database (MYSQL) in one

Anonymous — Sat, 25 Apr 2015 08:03:34 GMT

the problem that I have 711 tables in DB and i can't make for each table a tmysqlinput !
plz help

Re: how to integrate many database (MYSQL) in one

Anonymous — Mon, 27 Apr 2015 06:55:49 GMT

Hi,
Have you already checked "dynamic schema" functionality?
You only need to create one subjob for all tables due to the 'dynamic schema' feature.
Please take a look at document about:TalendHelpCenter:How to process changing data structure?
Best regards
Sabrina