I am currently working on a project to connect ADempiere ERP with Drupal: I would like to display products from ADempiere database, process customer orders within ADempiere...
So far, i have thought of differents possibles ways of realising this:
-Developping a Drupal module to alter and redirect Commerce related queries to ADempiere database.
-Writing a script to sync both databases (not the best way, it would cause a heavy server load to have close to real-time changes synchronisation)
-Fully synchronising databases once and then committing changes on one database to the other in real time using HTML5 Websockets or webservices.
I'm also gonna contact egility.biz about this project.
If anyone have suggestions or advice on how to achive this, I would be grateful.