Ask the Expert

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

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?

    Requires Free Membership to View

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 first published in October 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: