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

This was last published in October 2007

Dig Deeper on Business intelligence software

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.