DMC Data Management Solution

IBM DB2 Web Query for i offers a set of modernized tools for a more robust, extensible and productive reporting solution than the popular Query for System i (also known as Query/400) tool. DB2 Web Query for i preserves investments in the reports developed with Query/400 by offering a choice of importing definitions into the new technology or continuing to run existing Query/400 reports as is. But it also offer significant productivity and performance enhancements by leveraging the latest in DB2 for i query optimization technology.

DB2 Web Query provides the ability to query or build reports against data stored in DB2 for i (or Microsoft® SQL Server®) databases through browser-based user interface technologies. Build new reports with ease through the web based, wizard-like Report and Graph Assist tools or the WYSIWYG Power Painter component.

Simplify the management of reports by significantly reducing the number of report definitions required through the use of parameter driven reports. Deliver data to end users in many different formats, including directly into spreadsheets, or in boardroom-quality PDF format, or viewed from the browser in HTML. Leverage advanced reporting functions such as matrix reporting, ranking, color coding, drill-down and font customization to enhance the visualization of DB2 data.

Add the OLAP (On-Line Analytical Processing) feature to interact with the data through slicing and dicing and drill-down capabilities. For the end user on the go, choose the Active Reports feature to allow reporting without having to be connected to the server. Build simple dashboards with the optional DB2 Web Query Developer Workbench. Use the Developer Workbench to hide the complexities of the database (for example, join logic) from end users through metadata. Automate report execution and distribution with the DB2 Web Query Report Broker product. Integrate DB2 Web Query reports into applications with a Software Development Toolkit.