Since its introduction in the early 1980s, enterprise resource planning (ERP) software has replaced custom-built applications and has become the primary transactional system of most established organizations. ERP software provides the ability to efficiently integrate departments and functions into a single application by automating business processes that conduct and record the activities of the organization.

Most ERP applications utilize relational database management systems (RDBMSs) as the primary software to manage and store the data that is collected and processed. While ERP applications are able to integrate the functions of the organization, accessing the data from the database is challenging. Having extensive experience in accessing ERP databases for reporting, ad hoc query and decision support, there are several technical aspects that should be considered.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access