Problem solve Get help with specific problems with your technologies, process and projects.

Accessing data from different systems: When ERP isn't enough

When data is stored in different transactional systems, data access can be compromised -- and ERP systems may not be enough. Our expert has a suggestion for how to get a singular view of the data.

We have different transactional systems and none of them provide good analytic tools. In other words, I don't have a fully integrated system from a single vendor. The ERP package was bought from one vendor and does not allow some types of managing information, the budget planning systems were bought from another vendor, and the BI capabilities from the ERP vendor do not allow simulation and scenarios. What is the best solution?
Certainly, the budget planning system BI might give you capabilities beyond what the enterprise resource planning (ERP) vendor provides. However, it may not allow you access to vital information in the ERP and other transactional systems. The best solution is a data warehouse which can provide a singular view of the information contained within all of these systems. With this in mind, you now have the ability to choose the best tool(s) for performing analytics. If you lack the support and funding for such a project, I recommend you start out with a small Proof of Concept using existing or low-cost software. Use this to demonstrate the possibilities and generate the required interest from management.

More ERP resources

Dig Deeper on Business intelligence software

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.