My problem is that i have to migrate data from sage to openerp using Talend Open Studio.
For example i don't know how to transfer data from one table to another especially they don't have the same number of columns, one more thing is how to automatize and synchronize between th two tables?
GOOD QUESTION !
For such operations, you have to deal with more than one table at a time.
ON BOTH SIDES (SAGE and OpenERP)
1_ You have to identify the DATA you need to migrate
2_ You have to identify, in which tables, and which columns, those DATA are recorded.
most often, if not always, the data in one table had to be spread on more than one table.
3_ How to deal with Foreign Keys and constraints ?
This is a big job. The kind of job that each computer scientist must do at least one time in his life.
You can find many responses to your questions in the following links:
Good luck, and keep us informed of the work progress.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/16/14, 8:12 AM|
|Seen: 2299 times|
|Last updated: 3/16/15, 8:10 AM|