I need OpenERP to fetch data from an external system running on MySQL. These data will be fed into the openERP system and be used to generate reports in the future. These data need to be fetched into the OpenERP system on a 30seconds interval or less to give a semblance of real time access.
What sort of information do i need to get from the developers of the other system, aside from the system's IP address, SQL statements, user name and password.
How do you advise i go about this and achieve integration in record time and effectively.
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: 9/30/14, 11:45 AM|
|Seen: 835 times|
|Last updated: 3/16/15, 8:10 AM|