I just read a new report from my colleagues at Andrews Consulting Group that I would recommend to any JD Edwards professional. The report, Why You Need a Data Warehouse, explains how a properly designed data warehouse can improve query, reporting, and analysis of JD Edwards data by orders of magnitude. I’ve posted the report on our Research and White Papers page where anyone can download it. I encourage you to do so.

Why You Need a Data Warehouse shows how critical this little-understood technology is to improving information flow in an organization. The report describes seven ways that a data warehouse makes life better for JD Edwards professionals and their users. Here are just two of them.

  • Sharply reduces report maintenance. When reports and queries run directly against JD Edwards databases, they have to be modified whenever changes are made to the databases and the EnterpriseOne and World applications that use them. When they run against a data warehouse, by contrast, the reports are insulated from application changes and new releases. In fact, a data warehouse can allow reports to run unmodified against data that is drawn from multiple JD Edwards releases.
     
  • Eliminates competition for system resources. Accessing operational databases directly creates another problem: contention with JD Edwards applications for access to the data. A data warehouse offloads the demands of reporting, query, and analysis tools to a separate system. This allows users to get the information they need whenever they need it without slowing down transactional systems.

Why You Need a Data Warehouse also examines three different ways to create a data warehouse. Historically, data warehouses have been time-consuming and expensive to deploy. As the report explains, that has changed considerably over the last several years. As a result, many more JD Edwards sites can afford a data warehouse than they did in the past.

If you are not satisfied with your reporting and data analysis systems (and few JD Edwards professionals are these days), I think you will benefit greatly from this paper. To get it, just go to our Download White Papers page and enter the password to our site. If you don’t have the password, you can get it by subscribing to our email updates. Don’t worry…it’s free and all you have to do is provide a valid email address. We promise never to use that address except to notify you of new content on this site.