Build DB2 Web Query Meta Data and Queries

DB2 Web Query relies upon the meta-data layer which describes and maps the existing application database. Adding all the meta-data information about the database is a manual and labor intensive process, especially for large complex databases typical of system i applications.

See Your System As You’ve Never Seen It
Simply fill out the form on the right for a
free, no obligation 30 day trial of X-Analysis.


Description :

X-WebQuery automatically builds the meta-data layer for DB2 Web Query, including all of the file to file foreign key or relational information which is extracted using Databorough's data modeling engine, used by companies worldwide. This means users can start using some of the basic and more advanced features of DB2 Web Query instantly, without any need for labor intensive manually setting up of the relational meta-data. On top of this, an entire ready-to-use set of standard linked queries is automatically built using the generated meta data. These auto generated queries use the relational information to bring in descriptor information to standard queries, as well as linking individual queries so users can drill-down through the hierarchical structure of the business data, like any Business Intelligence application. All done automatically. The generated queries can then be used as is, or as templates for customized queries for more specific user requirements. Add-ons for Instant OLAP and advanced query and data model extraction are also available.

Feature list:

  • Unlimited users per server License
  • Builds DB2 Web Query meta-data automatically
  • Includes relational information between files/tables in meta-data
  • Identifies totalable fields plus all key structures
  • Builds entire set of standard queries over database
  • Incorporates descriptors into standard queries using relational information
  • Uses relational information for drill down inquiries
  • Instant OLAP add-ons
  • Advanced Legacy Inquiry Program and Model extraction Add-ons
  • Date field and their formats Add-ons

X-Analysis customer list includes:
IBM Professional Services,
JD Edwards, Fiserv, Mapics, and thousands more.
See more

Rethinking Legacy Systems
Learn how companies are extending the lifetimes of legacy systems and reusing extracted designs for redevelopment.

On-Demand webinar:
A Visual Guide To Business Rules Recovery
Click here to view

A Customer Speaks

view more
We saved over a million dollars in
the first year using X-Analysis
Chris Nickchen,
Project Manager New Penn