Unanswered: Integrating MS Access with Sage 50 - databases
I need your help regarding integration of Sage 50 and Microsoft Access as ERP and CRM of the company, respectively.
My question is: Is it possible/feasible/wise from database point of view to integrate the two systems?
The scenario would be: Entries will be made on Access database through Access screens and then the data would be loaded into Sage database in real time. Currently the databases of Sage 50 and Access are different.
I would try to provide other information if it is needed.
Thanks for the quick reply.
I think, which may not be correct, that there would be problems in transforming the Access data according to Sage tables in real time. Did you use some other other tool (ETL?) to integrate the two databases or nothing else is required.
Please help in opening my eyes.