What are the advantages and disadvantages of ERP reporting tools?
Ahh. Are you drinking the ERP vendor bathwater, or do you want to leverage your current BI investment? Either way, the advantage of enterprise resource planning (ERP) reporting tools is that they are typically tightly coupled with the ERP data structures. Thus, development time is less than if you wanted to apply an off-the-shelf reporting tool against the ERP data and its associated table structures. With an off-the-shelf tool, someone will need to build the schema so that the front-end reporting tool knows how to navigate the underlying database structure, a complex task given that established ERP systems often involve thousands of tables. The trade-off of using an ERP vendor's reporting tool is that reporting against non-ERP data could be difficult. An off-the-shelf tool can report against data from a multitude of sources, whereas the ERP tool is typically limited to the ERP system's data. However, most reporting tools have specific "connectors" to the ERP tools -- an attempt at mitigating the extra development effort.
More on ERP tools
Dig Deeper on Enterprise data integration (EDI) software
Related Q&A from Jill Dyché
Do you need to gather business requirements for an MDM project? Find out and learn how functional requirements are the key difference between the MDM... Continue Reading
Learn about the most common master data management (MDM) project pitfalls that companies run into. Get a list of the major problems that can hold ... Continue Reading
Is it better for companies to go with an enterprise-wide master data management (MDM) implementation or deploy MDM departmentally? Find out which ... Continue Reading