Data integrator framework
Hi,
One of our customer is using JDE 9.2 (tools 9.2.4.3) as their primary ERP system running on Oracle DB. They also has multiple other application running for different process which are hosted on different databases like MS SQL, MySQL etc..(all DBMS). Now they want to get all the data into Oracle. (This might get used for JDE also).
My query is:
1. Is there any standard tool available for doing the same. (except SQL developer, which I know works).
2. Also is there any framework / best practices available to follow. As customer is looking into standardizing the process.
Please advise.
Note:- I might not be asking the question in the right forum, kindly forward the query if required to right audience for advise.