I would like a little advice on how I can report various types of information from 3 separate ERP systems. I work for a company which has three different ERP systems which process data for three associated entities in three different geographic locations. The three different entities share a management team and operate economically like one unit. It would be ideal to be able to report summary and detailed information globally and regionally for these entities, however, I am unsure how I can achieve this in a cost effective way as the three different ERP systems are very different in nature. The systems are Sage 200, Xero and Quickbooks desktop version.
ODBC reporting: Initially, I was thinking I could set up ODBC links for each ERP system, then output whatever data is required onto a spreadsheet based report. However, I have been advised by a colleague that this is not possible as Quickbooks is not ideal for ODBC reporting. Is this correct, or is there another cost effective or better way to achieve what I am looking for? I'd like a bit of pointing me in the right direction towards best practice from this website, so any advice, even if very general, would be very appreciated.
Thanks in advance.