Reputation: 1422
I need to write a web application, which works only with MySQL database, but all actual data lies within an Oracle. So now i'm looking for some way to syncronize partially or use some automated tools to do that. Or just for a best practice for that case. To be clear, there's no way to use Oracle directly from web applications due to security policies. Any advices?
Upvotes: 1
Views: 43
Reputation: 1588
You can use tungsten replicator http://code.google.com/p/tungsten-replicator/ or also there is option of Data Integration / ETL tools like talend https://www.talend.com/resource/etl.html.
Upvotes: 1