merge two databases into one

Four Stars

merge two databases into one

Hello,

 

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

 

Thank you.

 

Community Manager

Re: merge two databases into one

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.

Moderator

Re: merge two databases into one

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: merge two databases into one

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.

 

 

 

Four Stars

Re: merge two databases into one

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 

 

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now

How to Modernize Your Cloud Platform for Big Data Analytics With Talend and Micr...

Learn how<SPAN>to modernize your Cloud Platform for Big Data Analytics with Talend and Microsoft Azure</SPAN>

Read