Have you tried bypassing development of a data warehouse by running your reporting directly against an enterprise system?

In the last few months, I have received a greater than normal amount of e-mails inquiring about the pros and cons of using transactional systems as the main information delivery data store. After all, in today's environment of large integrated source systems such as human resource and financial enterprise resource planning (ERP), customer relationship management (CRM), supply chain management (SCM) and other enterprise systems, is a data warehouse really still needed? Today's business environment continues to demand fast access to the most accurate, latest, most current information, right? Could eliminating the development of a data warehouse and reporting directly against the transactional enterprise system be the right choice? Technology today continues to provide increases in processing speed, memory and disk capacity, I/O throughput and other efficiencies, which may also allow consideration of this approach. Database management systems have provided data warehouse-focused capabilities that could be used in source systems to provide denormalized structures for business reporting needs. Is it time to revisit the need for the data warehouse in your environment?

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