When information is located on various platforms, working with a data integration consulting professional can be very beneficial. They don't deal with data that is separated; they work on processes that gather that data into a single location. This simplifies the reporting process and helps minimize manual effort. I had a friend that had a similar issue with CRM and accounting software, and with the help of the professionals, it was much easier. One of the companies that caught their interest because of their emphasis on enterprise data projects was Datalance.