Home > Ask the Data management / BI Experts > Integration and SOA data services Questions & Answers > ERP reporting tools' advantages and disadvantages
Ask The Data Management Expert: Questions & Answers
EMAIL THIS

ERP reporting tools' advantages and disadvantages

Jill Dyché EXPERT RESPONSE FROM: Jill Dyché

Pose a Question
Other Data Management Categories
Meet all Data Management Experts
Become an Expert for this site


Tips, expert advice and sample chapters
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 15 October 2007
What are the advantages and disadvantages of ERP reporting tools?


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Enterprise data integration (EDI) software
Informatica hopes to bridge the business/IT divide with latest release
Data integration for Software as a Service business intelligence software evolves
Yearbook publisher finds BI reporting, data integration tools from same vendor
Efficiencies can be gained at the intersection of middleware and data integration
Data warehouse project leads to data mashups in D.C.
Understanding the latest data integration strategies and technologies
Interest in open source data integration technologies growing
Understanding key data integration trends and business drivers
Informatica acquires complex event processing vendor Agent Logic
Informatica offers data integration software by the hour on Amazon EC2

Integration and SOA data services
What are some SOA risks and challenges and how can we mitigate risks?
How to estimate SOA costs and design an SOA strategy for integration projects
What's the difference between SOA and Web services?
What are the components of service-oriented architecture (SOA)?
SOA governance best practices
Data integration certifications: Finding the value
The ETL process and MySQL
ETL tools and EDR tools: What's the difference?
Data-as-a-service, explained and defined
ETL tools defined

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


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

  • A guide to enterprise resource planning for IT managers




    • Search and Browse the Expert Answer Center
    Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
    Browse our Expert Advice

    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Site Map




    All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy     		  TechTarget - The IT Media ROI Experts