topic Re: merge two databases into one in Talend Studio

merge two databases into one

Anonymous — Sat, 16 Nov 2024 08:37:40 GMT

Hello,

I would like to know how to merge two Mysql database and oracle into one (oracle or mysql).

Thank you.

Re: merge two databases into one

Anonymous — Wed, 28 Feb 2018 15:53:32 GMT

Get your company to hire a data integration expert. This is a bit like asking a decorator "How do I decorate my house?". The decorator will probably quite happily advise you of which paints to use and which brushes are the best ones. They may even point you to some tutorials on how to get the best finish. But if you ask them "How do I decorate my house" they will either hand you a quote or ask you to break the problem down into smaller, targeted questions.

Re: merge two databases into one

Anonymous — Wed, 07 Mar 2018 09:59:18 GMT

Hello,

Please give us more information about your job requirement so that we can design a demo job for you.

Best regards

Sabrina

Re: merge two databases into one

Anonymous — Wed, 07 Mar 2018 10:27:24 GMT

Hello,

Thank's for your help,

I have realized this job until now,

tContextLoad->tFileInputDelimited

|_-->tJDBCInput(database_source_1)----->tMap------->tJDBCOutput(database_destination)

i have repository containt my files of parametres of my databases Input (databases_source_1 and databases_source_2) and i want to merge theses data

(databases_source_1 and databases_source_2) from to (database_destination), so for that i want to set up a iterate on the repository who contain db_sources.

theres is a example of my repository and how the files are structured :

my repertory named "databasesParameters " structured as follows:
database1.txt:
            - host, xxxx
            - port, xxxx
            - data_base_name, xxxx
            - user, xxxx
            - password, xxxx
            - table_name, xxxx

database2.txt:
            - host, xxxx
            - port, xxxx
            - data_base_name, xxxx
            - user, xxxx
            - password, xxxx

- table_name, xxxx

Real Exemple :

productsDb.txt

            - host,127.0.0.1
            - port, 5487
            - data_base_name, productsDb
            - user, free
            - password, pass

- table_name, construction_products_holding

Thanks again for your help.

Re: merge two databases into one

Anonymous — Wed, 07 Mar 2018 17:07:51 GMT

Ok, first of all thank you for trying helping me ,

in the second, this is my case, i have a repository who containt text files, this is a simple case of the organisation of theses files :

database1.txt:
            - host, xxxx
            - port, xxxx
            - data_base_name, xxxx
            - user, xxxx
            - password, xxxx
            - table_name, xxxx

database2.txt:
            - host, xxxx
            - port, xxxx
            - data_base_name, xxxx
            - user, xxxx
            - password, xxxx

- table_name, xxxx

so i want to iterate on the texte file to migrate data from database source to destination(only one destination and multiples source).

thank you