merge two databases into one

[Anonymous]

Hello,

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

Thank you.

[Anonymous]

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.

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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.

[Anonymous]

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